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

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

SAP IQ 16.1

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