FNC_GetQueryBandUの使用例 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL外部ルーチン プログラミング

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
2020年6月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/qwr1571437338192.ditamap
dita:ditavalPath
ja-JP/qwr1571437338192.ditaval
dita:id
B035-1147
Product Category
Software
Teradata Vantage

SQL定義

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

C関数定義

#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;
}