CliPostSQLExt - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities

CliPostSQLExt is the CLI Post-process SQL User Exit function of DBCHCL. CliPostSQLExt is used to collect user-supplied time statistics of SQL requests.

Calling CliPostSQLExt

CliPostSQLExt is called and executed after CLIFET. The following functionality will be added:
  • The user written function is executed when the Process_Post in CliPreSQLExt is set to 1 or true and CliPreSQLExt is put in CliPostSQLExt.
  • The Post-process SQL flag from CliPreSQLExt is set to false so further execution of CliPostUsrSQLExt will not occur during parcel return.

Interface

struct CliPostSQLExit
{
   char   *SQL_Request_ptr;    /* pointer to user request */
   char   Start_date[80];      /* start date in ascii */
   Int32  Clock_time;          /* clock time */
   char   dbcname[DBCNAMLEN];  /* DBC name */
   char   username[USRNAMLEN]; /* username */
   char   account[ACTNAMLEN];  /* account */
   char   password[PWDNAMLEN]; /* password */
   char   domain[DOMAINLEN];   /* domain */
   Int32  *SQL_len_ptr;        /* length of user request */
   Int32  logsessid;           /* logical session id */
};

Return Value

No values are returned by this function.

Error Handling

No special error conditions will be processed by this function. Parcel information returned by the Teradata SQL request will be passed to the calling utility (that is, BTEQ, FastLoad, etc.) or the user application calling CLI.