

CA Datacom/DB SQL Preprocessors › Embedding SQL Statements in Host Programs › Coding Embedded SQL in Assembler › Rules for Coding Host Variables in Assembler
Rules for Coding Host Variables in Assembler
When you code host variable declarations, you must comply with the following requirements:
- Cannot be longer than 32,765 bytes.
- Indicator variables must be declared as a halfword with implied or explicit length of two.
- You may declare structures of fields. Only elementary level fields can be referenced as host variables.
- Definitions may be defined in SQL INCLUDE directives.
- Host and indicator fields must have a duplication factor of one, explicit or implied.
- Fixed format is not required.
- All eligible field definition statements must have a name entry. Use of the prefix SQL should be avoided.
- The operation entry can be either a DS or DC.
- The operand entry must define a single field with the exception noted below.
Operand Subfields
The operand subfields:
- The duplication factor must be 1, regardless of whether it is explicitly specified.
- Valid types are listed below with the corresponding SQL type.
- Modifier use is limited primarily to length. Where the explicit length is specified and a nominal value is given, the explicit length takes precedence.
- Nominal values can be used to calculate length implicitly where no length modifier is given. A nominal value may be scanned to determine the number of decimal places.
Copyright © 2014 CA.
All rights reserved.
 
|
|