Micro Focus Studio Enterprise Edition for Windows
>
Programming
>
Data Access
>
Database Access
>
Reference
>
SQL TYPEs
>
DATE-RECORD
DATE-RECORD SQL Type
Note:
OpenESQL only
Syntax
SQL [TYPE] [IS] DATE-RECORD
Use DATE-RECORD to generate a group-level record for the date containing individual records for each element of the date as follows:
Year
Month
Day
Example
01 hv-name SQL TYPE IS DATE.
generates
01 hv-name PIC X(10).
Parent topic:
SQL TYPEs
Related information
DATE
