SAGQENCO

sagqenco (

int sqllen,

int sqlprecision,

int sqlscale,

int sqllength

);

 

The SAGQENCO function encodes the sqlprecision, sqlscale and sqllength into sqllen of decimal and numeric SQL data type columns.

Any value may be supplied for sqllength, only sqlprecision and sqlscale will be used for the encoding.

 

sqllen

Output

SQLVAR->SQLLEN

sqlprecision

Input

SQLPRECISION to be encoded

sqlscale

Input

SQLSCALE to be encoded

sqllength

Input

SQLLENGTH to be encoded (not used)

 

Examples

 

C/C++

#include <aceapic.h>

sagqenco (&API_OUTPUT_SQLDA->sqlvar[column].sqllen,

          &API_SQLPRECISION,

          &API_SQLSCALE,

          &API_SQLLENGTH);

COBOL

All parameters must be declared as COMP-5.

 

COPY ACEAPIB.

CALL "SAGQENCO" USING

      BY REFERENCE SQLLEN OF SQLVAR OF API-OUTPUT-SQL(column)

      BY REFERENCE API_SQLPRECISION

      BY REFERENCE API_SQLSCALE

      BY REFERENCE API_SQLLENGTH

PL/I

%INCLUDE aceapip ;

CALL sagqenco(

     API_OUTPUT_SQLDA_PTR->API_OUTPUT_SQLDA.SQLVAR(column).SQLLEN,

     API_SQLPRECISION,

     API_SQLSCALE,

     API_SQLLENGTH) ;