Column Specification—Data Types
Specify data types by entering a type identifier and, in some cases, a number representing the maximum width of the data column. For example, the data type c15 specifies a character data type and a maximum width of 15 characters. Be aware of the maximum possible length of the data type so that you do not exceed it when you are specifying data types.
The following general data types are supported:
• Character
• Numeric
• Money
• Date
For a full description of all data types and their functionality, see the chapter "Working with Data Types and Data Display Formats" and your query language reference guide.