Parameter
dbs/db4/auto_dsql_schema
Short text
Auto-qualification of native SQL statements.
Parameter Description
If dbs/db4/auto_dsql_schema is set to ‘false’, IBM i system naming is used to locate database objects in a native SQL statement (ADBC, EXEC SQL).
If dbs/db4/auto_dsql_schema is set to ‘true’, the following class of SQL statements will be handled differently:
DQL (SELECT),
DML (INSERT, UPDATE, DELETE),
DDL (CREATE [OR REPLACE], DROP, ALTER)
For the above statement types, database objects will be recognized and auto-qualified with the schema name of the current database connection, simulating SQL naming.
For more information, see SAP Note 1509678.
Application Area
Database
Default Value
1
Who is permitted to make changes?
DB administrator
Database System Restrictions
The parameter is only evaluated on DB2 for IBM i.
Are other parameters affected or dependent?
No.
Values allowed
Boolean value, case-insensitive:
1, on, yes, true — Auto-qualification is enabled
0, off, no, false — Auto-qualification is enabled
