SQLTYPES, like SQLINFO, exists in SYSFILES and a Q-pointer is created to it from each account on which SQLM is run. It contains information used by SQLM and by the Reality SQL server.
Caution
Do not modify the contents of SQLTYPES.
In particular, it contains a record of the SQL data types supported by the Reality server. To see a listing of these records, enter:
LIST SQLTYPES
This displays the following:
TYPE TYPENAME....... SUPPORTED. -7 BIT YES -6 TINYINT YES -5 BIGINT YES -4 LONGVARBINARY YES -3 VARBINARY YES -2 BINARY YES -1 LONGVARCHAR YES 1 CHAR YES 2 NUMERIC YES 3 DECIMAL YES 4 INTEGER YES 5 SMALLINT YES 6 FLOAT YES 7 REAL YES 8 DOUBLE YES 9 DATE YES 10 TIME YES 11 TIMESTAMP YES 12 VARCHAR YES