SAP Knowledge Base Article - Preview

3518222 - Backup and Restore table having Primary Key - SAP IQ

Symptom

Currently there are a limitations to restore a source table having Primary Key. Request enhancement in future IQ releases.

Example:

create table foo (a int, b int, primary key(a) );
insert into foo values (1,1),(2,2),(3,2),(4, 8) ;
commit;

  1.  If target table is created without Primary Key, 
    create table foo2 (a int, b int) ;

    then  

    restore table foo2 from '/tmp/foo'  ;

    fails with error

    Could not execute statement.
    The meta data of the table backup archive is incorrect. 
    --
    (dblib/db_tableBackup.cxx 363)
    SQLCODE=-1009209, ODBC 3 State="HY000"

  2.  If target table is created with Primary Key as the source, 

    create table foo2 (a int, b int, primary key (a)) ;

    restore fails because of secondary indexes :

    restore table foo2 from '/tmp/foo'  ;

    Could not execute statement.
    Cannot restore table backup while secondary indexes are declared on it
    SQLCODE=-1009211, ODBC 3 State="HY000"
    Line 1, column 1


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

sybase, 829845, CR829845, CR#829845 , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.