Example Using FNC_GetQueryBandU - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

SQL Definition

REPLACE FUNCTION GetQueryBandExample()
    RETURNS VARCHAR(6159) CHARACTER SET UNICODE
    LANGUAGE C
    NO SQL
    PARAMETER STYLE TD_GENERAL
    EXTERNAL NAME 'CS!GetQBExample!GetQBExample.c';

C Function Definition

#define SQL_TEXT Latin_Text

#include<string.h>
#include<sqltypes_td.h>          

extern void
FNC_GetQueryBandU(void      *QBandBuf,
                  int        BufSize,
                  int       *QBandLen);  


/****************************************************/

void GetQueryBandExample (
        VARCHAR_UNICODE *QBandBuf,         
        char sqlstate[6])
{
    int QBandLen;
    int MaxQBLen;
              
    MaxQBLen = FNC_MAXQUERYBANDSIZE_U;
    
    FNC_GetQueryBandU(QBandBuf, MaxQBLen, &QBandLen); 

    return;
}