To create tables in relational databases (such as SQL Server, Oracle, DB2, Sybase, and Informix) using the current CONNX schema (instead of the schema specified at import time), set the following value:

 

USECONNXSCHEMAFORNATIVE =1

 

When USECONNXSCHEMAFORNATIVE = 0, relational database tables are created using the schema specified at import time.

 

When USECONNXSCHEMAFORNATIVE = 1, relational database tables are created using the current CONNX schema.

 

NOTE:  If the current CONNX schema name does not exist in the database,  the specified schema must be valid on the target database. Otherwise, an error can occur on the Create Table command.  

 

Default = 0

 

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX\Adabas; Key Value/Value Name =  USECONNXSCHEMAFORNATIVE

 

Unix Configuration Setting: USECONNXSCHEMAFORNATIVE