Syntax
SQL [TYPE] [IS] CHAR-VARYING(n)
- CHAR-VARYING data is passed to OpenESQL as SQL_VARCHAR.
- Data sent to the data source eliminates trailing spaces except for the first space if the value is all spaces.
- Values fetched from the data source are padded with spaces.
Example
01 hv-name SQL TYPE IS CHAR-VARYING(200).
generates
01 hv-name PIC X(200).