DBCHCL CMD Function - Teradata Tools and Utilities

Purpose

CMD (Command) issues a TDP command within a CLIv2 program.

This function is used to send the TDP command, specifying a buffer and length that contain the command text.

Usage Notes

• Use the CMD function to send a TDP command, specifying a buffer and length for the command text.
• If the Return Code is 0, a pseudo-connection number and a request number are returned.

To process the response, issue a FETch function with the returned pseudo-connection number and request number.

The response data is composed of various parcels in the following order:

1. A Success parcel with an activity count that indicates the number of subsequent Record parcels
2. The Record parcels themselves (one Record parcel for each line of command output)
3. An End Statement parcel
4. An End Request parcel
   • After the response has been completely processed, the application must invoke the ERQ function to release the fetch buffer used by the CMD.

     Since the application does not establish a connection, no DISCONN function may be used for the pseudo-connection number. Rewind and Abort functions are not supported.

     If the specified response buffer is too small for the entire response, a code of 535 is returned, either as a warning code in the Success parcel or as a return code from the CLIv2 call.

DBCAREA Input Fields

Before using the Command function, the application must set the DBCAREA fields in the first table and may optionally set those in the second table depending on the application's requirements.

DBCAREA Output Fields

Upon completion of the Command function, CLIv2 will always set DBCAREA fields in the first table and will set those in the second table if the function was successful.