Symptom
- executing DDL generated by iqunload -n utility results in 'NOT NULL foreign key not supported' error message.
Could not execute statement.
NOT NULL foreign key not supported.
SQLCODE=-1000163, ODBC 3 State="HY000"
- executing ALTER or CREATE table SQL statements containing clause "ADD NOT NULL FOREIGN KEY" results in the same error as above.
Read more...
Environment
- SAP IQ 15.4 all versions , all platforms
- SAP IQ 16.0 all versions , all platforms
- SAP IQ 16.1 all versions , all platforms
Product
SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7
Keywords
failure, sybase, CR632876, CR#632876, 632876, 'IQ 12.7' , iq12.7, IQ16, IQ15, abort, foreignkey, foriegn, NOTNULL, referential, integrity, migrating, upgrading, schema, FK, 'SQLCODE 1000163', '-1000163', 'SQLCODE -1000163', syntax , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.