Sets
the user-defined character string, that associates an application
with a connection. When you set the ProgramID keyword, DB2® for z/OS® or IBM® Informix® database server associates
this keyword with any statements that are inserted into the dynamic
SQL statement cache.
- db2cli.ini keyword syntax:
- ProgramID = <string>
- Default setting:
- None
- Equivalent connection attribute:
- SQL_ATTR_INFO_PROGRAMID
- Usage notes:
Restriction: This keyword is supported only for CLI applications
accessing DB2 for z/OS servers, IBM Informix database server,
or DB2 for i servers.
When
monitoring a CLI application,
you can use the ProgramID keyword to identify
a statement that was inserted into the dynamic SQL statement cache.
You can use the ProgamID keyword to specify an
identifier, as a string of up to 80 bytes for connection to DB2 for z/OS,
or IBM Informix database server server
at the connection and statement level. CLI applications
can set the ProgamID keyword on DB2 for i V6R1
and later servers. DB2 for i servers
support up to a length of 255 characters.
If
you set the ProgamID keyword, the SQLGetConnectAttr() and SQLGetStatementAttr() APIs
return the specified ProgamID keyword value.