Use-default-conn is a one-byte EBCDIC field that indicates whether a connection being established by an External Stored Procedure calling CLIv2 and executing in the database is a new connection or the connection used by the application to call the procedure.
Use-default-conn exists only when DBCHINI had been called for a DBCAREA with Total-length set to at least 640 (that is, the returned DBCAREA Level value is at least 1). For a smaller DBCAREA, Use-default-conn is ignored.
| In this language... | The variable name for Use-default-conn is... |
|---|---|
| COBOL | USE-DEFAULT-CONN |
| PL/I | USE_DEFAULT_CONN |
| C, C++ | useDefaultConn |
| IBM Assembler | DBCNIDC |
| This routine... | Does this for... |
|---|---|
| DBCHINI | writes |
| DBCHCL | reads (CON; IRQ; IWPF) |
| Use-default-conn is used by... | To.. |
|---|---|
| applications | write |
One of the following values may be set before initiating a request:
| If... | Then set Connect-type to... |
|---|---|
| 'N', indicates that a new connection is established. |
|
| 'Y', indicates that the connection used to call the procedure is used. |
|
If not specified 'N' is assumed.
If Use-default-conn is set to 'Y', since a new connection is not being established, the following DBCAREA settings that normally apply to the Connect function are ignored: Connect-type, Delegate-user-identity, input-TDP-pat, Logon-length, Logon-pointer, Mechanism-data-encoding, Mechanism-data-len, Mechanism-data-ptr, Mechanism-name, Run-length, and Run-pointer.
If Use-default-conn is set to 'Y' since session-wide settings from the existing connection are used, the following DBCAREA options that normally apply to the Connect function are ignored: Date-form, Language-conformance, Statement-status, Transaction-semantics, and Two-phase commit.
For more information on External Stored Procedures, see Stored Procedures.