dbs/db4/auto_dsql_schema SAP Parameter attribute - Auto-qualification for objects in native SQL statements

dbs/db4/auto_dsql_schema is a SAP Parameter attribute which is used to control Auto-qualification for objects in native SQL statements information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

dbs/db4/auto_dsql_schema profile paramerter attributes

Parameter Name: dbs/db4/auto_dsql_schema
Description: Auto-qualification for objects in native SQL statements
Default Value: 1
Parameter Type ( See IF_PARAMETER_TYPES): String(STRING)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-DB4
System-Wide parameter: No
Dynamic Parameter: No
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

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.

See SAP Parameter Documentation for full SAP documentation for this profile parameter.