DB2 graphic  QMF Version 8

APPL_AUTHNAMES

The syntax description for the user defined function table is:

Read syntax diagramSkip visual syntax diagram>>-APPL_AUTHNAMES(--+----------+--)----------------------------><
                    '-adjuncts-'

Read syntax diagramSkip visual syntax diagram>>-RETURNS TABLE(--+----------+--)-----------------------------><
                   +-authname-+
                   '-namekind-'

The APPL_AUTHNAMES function returns the DB2 authorization IDs for the current application process. A row is returned for each authorization name. The schema name is Q.

adjuncts VARCHAR(255)

A string of authorization names. Specify each authorization name as an identifier or a delimited identifier. Separate each authorization name by one or more blanks:

'SALES "DEPT A1" PAYROLL'

These three names would be added to the output of the function should they represent distinct values not already defined as authorization IDs for the current process.

The result of the function is a DB2 table with the following columns:


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004