VAR

VAR

The VAR statement allows you to mark a host variable as storage for binary data.

General format

EXEC SQL

VAR Host-Variable IS { BINARY }

{ LONG RAW }

{ RAW }

END-EXEC

Syntax rules

1. Host-Variable is a host variable.

2. BINARY, LONG RAW and RAW are synonymous.

3. Any value other than BINARY, LONG RAW and RAW is treated as a comment and doesn’t have any effect.

General rules

1. The VAR statement must appear in the source after the definition of Host-Variable.

Examples

Mark the wrk-ascii data item as RAW:

working-storage section.

...

77 wrk-ascii pic x(128).

exec sql var wrk-ascii is raw end-exec.