Example: Passing Fixed Length Character Values to the Host Variables - Teradata Vantage

This example passes fixed length character values to the host variables declared for the statement and session variables in an ANY COMPLETION INTO clause:

EXEC SQL WAIT ANY COMPLETION INTO :STMTNAMF, :CONNAMEF;

Lines generated by C Preprocessor2:

{
static struct {
       char      sqldaid[8];
       SQLInt32  sqldabc;
       short     sqln;
       short     sqld;
       struct {
              short     sqltype;
              short     sqllen;
              char     *sqldata;
              char     *sqlind;
              struct {
                     short     length;
                     char      data[30];
                     } sqlname;
              } sqlvar[2];
       } Sql_DA019_StructO =
       {'S','Q','L','D','A',' ',' ',' ',104,2,2,{{460,31,0,0,{0,{' '}}}
,{460,31,0,0,{0,{' '}}}}};
      Sql_DA019_StructO.sqlvar[0].sqldata = STMTNAMF;
      Sql_DA019_StructO.sqlvar[1].sqldata = CONNAMEF;
      {
      static struct {
             SQLInt32 RdtCType;
             SQLInt16 RdtVersn;
             SQLInt16 RdtDec;
             char     RdtUserid[8];
             SQLInt32 RdtEntty;
             char     *RdtCA;
             char     *RdtDAIn;
             char     *RdtDAOut;
             char     *RdtSql;
             char     *RdtRtCon;
             SQLInt32 RdtAux1;
             SQLInt32 RdtAux2;
             char     RdtLCS;
             char     RdtComit;
             char     RdtRelse;
             char     RdtExt;
             char     RdtSepBT;
             char     RdtUCStm;
             char     RdtCmpat;
             char     RdtComp;
             SQLInt16 RdtXTotL;
             char     RdtXFill[2];
             struct {
                    SQLInt16 RdtXLen;
                    SQLInt16 RdtXType;
                    SQLInt32 RdtXCode;
                    } RdtX005;
             } RDTIN019 =
             {470,10,0,{' '},0,0,0,0,0,0,2,0,'N','B','N','Y','N','N',
             ' ','C',12,{' '},{8,5,255}};
      RDTIN019.RdtDAOut = (char *)(&Sql_DA019_StructO);
      RDTIN019.RdtCA = (char *)(&sqlca);
      RDTIN019.RdtRtCon = SQL_RDTRTCON;
      TDARDI(&RDTIN019);
      SQL_RDTRTCON = RDTIN019.RdtRtCon;
      }
  }