C関数定義 - 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
#define SQL_TEXT Latin_Text
#include <sqltypes_td.h>
#include <string.h>
/* return a pointer to the SQLSTATE string */
void *Find_Text(VARCHAR_LATIN *searched_string,
                VARCHAR_LATIN *pattern,
                CHARACTER_LATIN  *result,
                char  sqlstate[6])
{
  int pattern_found = 0;
  if (strlen((char *)pattern) == 0)
  {
      /* send a warning because probably a mistake */
      *result = 'T';
      strcpy(sqlstate, "01H01"); /* see SQLSTATE table */
      return;
  }
  /* do the pattern match -- code not shown */
  ...
  if (pattern_found)
      *result = 'T';
  else
      *result = 'F';
  /* SQLSTATE is initialized to zero so normal return does */
  /* not need to set it */
  return;
}