Salesforce

SQL Keywords (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

SQL Keywords (Magic xpa 4.x)

The utility uses the existing connection to the data source selected and sends the function SQLGetInfo, with ‘SQL_KEYWORDS” in the fInfoType field.

This will return a character string containing a comma-separated list of all data source-specific keywords. This list does not contain keywords specific to ODBC or keywords used by both the data source and ODBC. Keywords are reserved words - you can use them only in specific places according to the syntax.

To retrieve the same information, simply connect to the data source with Connect\Full Connect, and select Connect\SQLGetInfo with SQL_KEYWORDS in the fInfoType field. The result is in the rgbInfoValue field in the result window.

SQL_KEYWORDS =

ALPHANUMERIC

AUTOINCREMENT

BINARY

BYTE

COUNTER

CURRENCY

DATABASE

DATABASENAME

DATETIME

DISALLOW

DISTINCTROW

DOUBLEFLOAT

FLOAT4

FLOAT8

GENERAL

IEEEDOUBLE

IEEESINGLE

IGNORE

INT

INTEGER1

INTEGER2

INTEGER4

LEVEL

LOGICAL

LOGICAL1

LONG

LONGBINARY

LONGCHAR

LONGTEXT

MEMO

MONEY

NOTE

NUMBER

OLEOBJECT

OPTION

OWNERACCESS

PARAMETERS

PERCENT

PIVOT

SHORT

SINGLE

SINGLEFLOAT

SMALLINT

STDEV

STDEVP

STRING

TABLEID

TEXT

TOP

TRANSFORM

UNSIGNEDBYTE

VALUES

VAR

VARBINARY

VARP

YESNO

Reference
Attachment 
Attachment