Creating Dataviews for CA Datacom/DB Native Command Access › Rules for CA Datacom/DB Native Command Access › Cataloging the Dataview › Data Types of Columns

Data Types of Columns

Rules for data types of columns are as follows:

• CA Ideal supports the following data types:
  • Alphanumeric (display) (C)
  • Zoned decimal (N)
  • Packed decimal (D)
  • Binary (B)
  • Date (D)
• CA Ideal converts all other, unknown data types to alphanumeric and issues a warning message.
• CA Ideal supports numeric columns (or fields) up to the equivalent of 31 decimal (base 10) digits (for zoned or packed decimal) and up to the equivalent of 9 decimal (base 10) digits (full word or half word binary) for binary fields. CA Ideal supports only half word (2 bytes) and full word (4 bytes) binary fields. Binary fields of other than 2 or 4 bytes (including data types 2, 4, and 8) can be defined, but CA Ideal treats them as alphanumeric fields (with a warning message) and the user must call a non‑CA Ideal subprogram to handle them. CA Ideal does not support floating point items of any precision.
  • A native dataview can contain null eligible columns.
  • DATE, TIME, and TIMESTAMP columns are supported. When the PDL statement FOR NEW is executed at runtime, the columns with these data types are initialized with the current date or time.