Page History
...
When connecting to a Server with DBID=*ANY, the following PSxx arguments can be used:
Param | Directly Equates to this Built-In Function: | Argument Number |
|---|---|---|
PSLU | DEFINE_ANY_SERVER | 2 (LU partner name) |
PSCC | DEFINE_ANY_SERVER | 3 (Commitment control) |
PSEA | DEFINE_ANY_SERVER See PSEA Notes (Primary Server Exceptional Arguments) | 4 (X_RUN exceptional arguments) |
PSDL | DEFINE_ANY_SERVER | 5 (Divert locks) |
PSWM | DEFINE_ANY_SERVER | 6 (Show please wait message) |
PSEP | DEFINE_ANY_SERVER | 7 (Server execution priority) |
PSCT | DEFINE_ANY_SERVER | 8 (Client to Server table) |
PSST | DEFINE_ANY_SERVER | 9 (Server to Client table) |
PSPW | CONNECT_SERVER | 2 (Password) |
PSTC | CONNECT_SERVER. See PSTC Notes (Primary Server Trusted Connection) | 3 (Use Kerberos Authentication) |
PSUS | ||
PSTY | ||
PSRA | ||
PSRR |
The SSN (Symbolic Server Name) used when automatically connecting to a server with DBID=*ANY is always DTASERVER. This value cannot be changed.
When connecting to an IBM i with DBID=*AS400, the following PSxx arguments can be used:
Param | Directly Equates to this Built-In Function: | Argument Number |
|---|---|---|
PSLU | DEFINE_OS_400_SERVER | 2 (LU partner name) |
PSCC | DEFINE_OS_400_SERVER | 3 (Commitment control) |
PSDB | DEFINE_OS_400_SERVER | 4 (DBCS capable) |
PSDL | DEFINE_OS_400_SERVER | 5 (Divert locks) |
PSWM | DEFINE_OS_400_SERVER | 6 (Show please wait message) |
PSEP | DEFINE_OS_400_SERVER | 7 (Server execution priority) |
PSCT | DEFINE_OS_400_SERVER | 8 (Client to Server table) |
PSST | DEFINE_OS_400_SERVER | 9 (Server to Client table) |
PSPW | CONNECT_SERVER | 2 (Password) |
PSUS | ||
PSTC | CONNECT_SERVER. See PSTC Notes (Primary Server Trusted Connection) | 3 (Use Kerberos Authentication) |
PSTY | ||
PSRA | ||
PSRR |
The SSN (Symbolic Server Name) used when automatically connecting to an IBM i server with DBID=*AS400 is always AS400. This value cannot be changed.
When connecting to a Server with DBID=*OTHER, the following PSxx arguments can be used:
Param | Directly Equates to this Built-In Function: | Argument Number |
|---|---|---|
PSLU | DEFINE_OTHER_SERVER | 2 (Server network name) |
PSDL | DEFINE_OTHER_SERVER | 3 (Divert locks) |
PSWM | DEFINE_OTHER_SERVER | 4 (Show please wait message) |
PSEA | DEFINE_OTHER_SERVER See PSEA Notes (Primary Server Exceptional Arguments) | 5 (X_RUN exceptional arguments) |
PSTC | CONNECT_SERVER. See PSTC Notes (Primary Server Trusted Connection) | 3 (Use Kerberos Authentication) |
PSPW | CONNECT_SERVER | 2 (Password) |
PSUS | ||
PSTY | ||
PSRA | ||
PSRR |
The SSN (Symbolic Server Name) used when automatically connecting to a non-IBM i server with DBID=*OTHER is always DTASERVER. This value cannot be changed.
...
DEFINE_ANY_SERVER, DEFINE_OS_400_SERVER or DEFINE_OTHER_SERVER to define the server as per the PSxx= parameter
CONNECT_SERVER to establish the connection
CONNECT_FILE to connect all files (file name "*" is used) to the server.
Note Note: The connection uses the default blocking factor on all files. This means that SELECT / UPDATE / ENDSELECT and SELECT / DELETE / ENDSELECT loops that are updating the last record read (i.e. the DELETE or UPDATE has no WITH_KEY or WITH_RRN parameter) may not process as expected. Refer to the CONNECT_FILE Built-In Function for more details of this problem and how to correct it. Another method of correcting this problem is described in 18.4.7 INIT and TERM Parameters.
If any of these actions fail then the function will fail during start up. This cannot be trapped. To use trapping, avoid using the PSxx= parameters and initially invoke your own start up function instead.