Data Types

SQL Concepts and Language Elements › Supported SQL Language Elements › Data Types

Data Types

CA Ideal supports the following SQL data types:

CA Datacom SQL	DB2
Character	Fixed‑length string
Variable length string	Variable length string
Small integer	Small integer
Large integer	Large integer
Numeric
Decimal	Decimal
Date	Date
Time	Time
Timestamp	Timestamp

All data types include the null value.

CA Ideal fields that correspond to SQL date and time type columns appear to PDL with the following attributes, unless DB2 user exits override the defaults:

Date Columns: X(10)

Time Columns: X(8)

Timestamp Columns: X(26)

For CA Datacom SQL access, variable length character strings are shown as type X, with the maximum length as the length.

Not Supported: Graphic string and any type of floating point.

For more information, see the CA Datacom/DB Database and System Administration Guide.