DQL Mode Data Types

Following is a list of CA Dataquery statements and the data types which they can use.

WITH,: CHAR, NUM, DEC, BIN, 1/2 BIN, FUL BIN, DBL CHAR, KANJI
RELATED: CHAR, NUM, DEC, BIN, 1/2 BIN, FUL BIN, DBL CHAR, KANJI
SET: NUM DEC, BIN, 1/2 BIN, FUL BIN, DBL CHAR, KANJI
SORT: NUM DEC, BIN, 1/2 BIN, FUL BIN, DBL CHAR, DBL MIXED, KANJI
PRINT/DISPLAY: CHAR NUM, DEC, BIN, FLOAT-PT SHRT, FLOAT-PT LONG, EXT, 1/2 BIN, FUL BIN, DBL CHAR, DBL MIXED, KANJI
DO: CHAR NUM, DEC, BIN, FLOAT-PT SHRT, FLOAT-PT LONG, EXT, 1/2 BIN, FUL BIN, DBL CHAR, DBL MIXED, KANJI

Note: For details about these data types, see the CA Datacom/DB SQL User Guide.

DATE, TIME, or TIMESTAMP

DQL Mode queries cannot include columns defined as data types DATE, TIME, or TIMESTAMP. These data types are reserved for SQL Mode queries. These data types are listed as character types on Extended Column Display panels because SQL Mode queries return character-type data.

To test a column that is suspected of being one of these types before selecting it for a DQL Mode query, follow these steps:

Look at the length of the column. SQL-DATE length is always 10, SQL-TIME is always 8, and SQL-TIMESTAMP is always 26.
If the data type is suspect, create a query that finds one row and PRINT the output.

Use the PF key for Extended Column Definitions to check the data type of the column you wish to use, and correct your query.