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;
- 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" - 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
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.