Data Types in CA Dataquery

This page provides information about which data types are used by dqd DQL Mode and the Personal Database Facility.
datacom151
This page provides information about which data types are used by 
Dataquery
 DQL Mode and the Personal Database Facility.
For complete details about 
Datacom/DB
 data types, including SQL data types, see Basic SQL Language Elements.
Topics discussed on this page include:
 
 
DQL Mode 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:
  1. Look at the length of the column. SQL-DATE length is always 10, SQL-TIME is always 8, and SQL-TIMESTAMP is always 26.
  2. 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.
Personal Database Data Types
The Personal Database data types are:
  •  
    CHARACTER
    Character string
  •  
    NUMERIC
    Zoned decimal
  •  
    DECIMAL
    Packed decimal
  •  
    SMALLINT
    Small integer
  •  
    INTEGER
    Large integer
  •  
    FLOAT
    Floating-point