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.