Advantage DBMS Notes

Home

ODBC Driver

Advantage StreamlineSQL ODBC 9.10.00.09

Synchronizing autoincr column data is not supported

• Synchronizing autoincr column data is not supported.
• No information is returned by driver for ::SQLForeignKeys
• Driver does not support transactions (auto-commit mode only).
• Creating second index on a table by executing sql script using ODBC user DSN connection fails (does not happen if you use system DSN instead). Example,

  create table in_sync_column_cmp( 
  cmp_type_cd char(8) constraint not null, 
  rs_oid integer constraint not null, 
  column_name varchar(128) constraint not null, 
  rs_oid_other integer constraint not null, 
  column_name_other varchar(128), 
  constraint PK_IN_SYNC_COLUMN_CMP primary key (cmp_type_cd, rs_oid, column_name, rs_oid_other) 
  ) 
  in database;
  
  create index IXin_sync_column_cmp on in_sync_column_cmp (rs_oid ASC,rs_oid_other ASC); 
  create index FK_ISCC_RS_OID_OTHER on in_sync_column_cmp (rs_oid_other ASC);

  [iAnywhere Solutions][Advantage SQL][ASA] Error 7200: AQE Error: State = HY000; NativeError = 7008; 
  [iAnywhere Solutions][Advantage SQL][ASA] Error 7008: The specified table, memo file, or index file 
  was unable to be opened. Table name: in_sync_column_cmp
  

See Also

DBMS Notes