SQL for Reality > SQL Environment Files > SQLTYPES File

Comment on this topic

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.0 ()

SQLTYPES File (SQL) (m6915ad+sqltypes.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

SQLTYPES File

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

RealityV15.0Comment on this topic