An authorization ID is a character string that is passed to the database manager when a connection is established between the database manager and a program, whether the program prepares another program or allows end-user access to SQL tables. The character string is the user identifier that is required to check the database-access authorization held by the preparer or end user.
The source of the authorization ID depends on the system where database access occurs.
For iSeries COBOL programs, the authorization ID is the user ID under which the programs runs.
The situation for EGL-generated Java programs is as follows:
The authorization ID may be used when you specify a table name. In that case, you can specify a table-name qualifier, in accordance with this syntax:
tableOwner.myTable
If you do not include a table-name qualifier when you specify a table name, the table owner is resolved at run time. The qualifier is set to the authorization ID.
For more information on authorization IDs, consult your database manager documentation.
Related concepts
Dynamic SQL
Java run-time properties
SQL support
Related reference
Java run-time properties (details)
SQL record part in EGL source format
sysLib.connect
sysLib.connectionService
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.