15.10 - Response Processing with CLIv2 - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

PM/API requests are processed similarly to Teradata SQL requests because CLIv2 is used for both. Response processing is similar in both parcel ordering and buffer allocation. For an example CLI program, see Appendix A: “Sample PM/API Application.”

Just as input data can be sent to the Teradata Database in indicator or record mode, the response can be returned from the Teradata Database in either indicator or record mode, depending on how the response mode option is set in CLIv2. You can set response mode to be independent of input data mode. For example, it may be more convenient to send the input data in record mode, but the response may require indicator mode if NULL is expected.

Response mode is usually set to a default value for the site. If you want to change the default value set, change options to Y in the application program.

 

If you want to return data in…

Set the response mode option in DBCAREA to…

indicator mode

I for Indicator. CLIv2 automatically uses the correct request parcel format.

record mode

R for Record. CLIv2 automatically uses the correct request parcel format.

Note: Field mode, represented by F, is not supported in a PM/API request.