boolean
dbInfo, in Class DB2Routine
Documentation
From the DB2 SQL Reference for Cross-Platform Development v1.1
http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html
CREATE PROCEDURE (External):
NO DBINFO or DBINFO
Specifies whether additional status information is passed to the procedure
when it is invoked. The default is NO DBINFO.
NO DBINFO
Additional information is not passed.
DBINFO
An additional argument is passed when the procedure is invoked.
The argument is a structure that contains information such as the name of
the current server, the application run-time authorization ID and
identification of the version and release of the database manager that
invoked the procedure. See "Database information in external routines
(DBINFO)" on page 708 for further details.
DBINFO can be specified only if PARAMETER STYLE DB2SQL is
specified.
Parameter passing for external functions or procedures written in C or COBOL
This input argument is set by the database manager before invoking the
program. It is only present if the CREATE FUNCTION statement for the
routine specifies the DBINFO keyword. The argument is a structure whose
definition is described in "Database information in external routines
(DBINFO)" on page 708. The dbinfo argument is input only and any changes to
the argument value made by the program are ignored by the database
manager upon return from the program.
From the v8.1 UDB documentation for external UDFs and stored procedures:
Specifies whether specific information known by DB2 is passed to the
stored procedure when it is invoked as an additional invocation-time
argument (DBINFO) or not (NO DBINFO). NO DBINFO is the default.
DBINFO is not supported for LANGUAGE OLE (SQLSTATE 42613). It is
also not supported for PARAMETER STYLE JAVA or DB2GENERAL.
If DBINFO is specified, a structure containing the following information is
passed to the stored procedure:
- Data base name - the name of the currently connected database.
- Application ID - unique application ID which is established for each
connection to the database.
- Application Authorization ID - the application run-time authorization ID.
- Code page - identifies the database code page.
- Database version/release - identifies the version, release and
modification level of the database server invoking the stored procedure.
- Platform - contains the server's platform type.
The DBINFO structure is common for all external routines and contains
additional fields that are not relevant to procedures.
CREATE PROCEDURE (External)
From the os390 v7 SQL reference:
Specifies whether specific information known by DB2 is passed to the stored
procedure when it is invoked.
NO DBINFO
Additional information is not passed. NO DBINFO is the default.
DBINFO
An additional argument is passed when the stored procedure is invoked.
The argument is a structure that contains information such as the
application run-time authorization ID, the schema name, the name of a
table or column that the procedure might be inserting into or updating, and
identification of the database server that invoked the procedure. For details
about the argument and its structure, see DB2 Application Programming
and SQL Guide.
DBINFO can be specified only if PARAMETER STYLE DB2SQL is
specified.
From the as400 SQL v5r1 SQL reference:
DBINFO Indicates that the database manager should pass a structure containing
status information to the function. Table 24 in the SQL reference
contains a description of the DBINFO structure. Detailed information
about the DBINFO structure can be found in include file SQLUDF in QSYSINC.H.
DBINFO is only allowed with PARAMETER STYLE DB2SQL.
Export Control | PublicAccess | Containment | Unspecified |
Static | No | Derived | No |
Property Settings
Data Modeler
dmItem | False | DMName | |
Ordinal | 0 | IsIdentity | False |
IsUnique | False | NullsAllowed | False |
Length | 0 | Scale | 0 |
ColumnType | Native | ForBitData | False |
DefaultValueType | | DefaultValue | |
SourceId | | SourceType | |
OID | False | | |