CHAR-VARYING

Syntax:

SQL [TYPE] [IS] CHAR-VARYING(n)

General Rules:

  1. CHAR-VARYING data is passed to OpenESQL as SQL_VARCHAR.
  2. Data sent to the data source eliminates trailing spaces except for the first space if the value is all spaces.
  3. Values fetched from the data source are padded with spaces.

Example:

01 hv-name SQL TYPE IS CHAR-VARYING(n)

generates

01 hv-name pic x(n).