sagqdeco (

int sqllen,

int sqlprecision,

int sqlscale,

int sqllength

);

 

The SAGQDECO function decodes the sqllen of decimal and numeric SQL data type columns into three components: sqlprecision, sqlscale and sqllength. The values for sqlprecision and sqllength are interchangeable.

 

sqllen	Input	SQLVAR->SQLLEN to be decoded.
sqlprecision	Output	SQLPRECISION
sqlscale	Output	SQLSCALE
sqllength	Output	SQLLENGTH

 

Examples

 

C/C++

#include <aceapic.h>

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

          &API_SQLPRECISION,

          &API_SQLSCALE,

          &API_SQLLENGTH);

COBOL

All parameters must be declared as COMP-5.

 

COPY ACEAPIB.

CALL "SAGQDECO" 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 sagqdeco(

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

     API_SQLPRECISION,

     API_SQLSCALE,

     API_SQLLENGTH) ;