The user’s startup string is not automatically executed when a connection is established through CLIv2. Instead, the startup string is executed by issuing a RunStartUp request. The RunStartUp request can be issued at any time during the execution of the program.
The following information is presented as though the connection to Teradata Database is already established.
To run a startup string after the session is established, an application must perform the following steps:
- Modify the DBCAREA.
- Set the Function to RunStartUp.
- Set the Input CLIv2 Session Id to the Output CLIv2 Session Id obtained when the session was established.
- Optionally set the following:
Any option values required (remember to set Change-options = Y if any option values are changed)
- Call DBCHCL to perform the RunStartUp function, then checks the return code from DBCHCL:
Return Code. Result 0 Call DBCHCL to perform a Fetch function (see Fetching the Response for a Request) until the complete response has been processed. anything else Process the return code and DBCAREA message.
- Call DBCHCL to perform the End Request function (see Ending a Request).
The runstartup string can contain either a macro requiring input parameters or a request with a USING row descriptor. In this situation, the application must pass the address and length of the data area to CLIv2. The USING-data-pointer and USING-data-length fields of the DBCAREA are provided for this purpose.