SQL Programming Manual for TAL

Dynamic NonStop SQL Operations
HP NonStop SQL Programming Manual for TAL—527887-001
7-39
Handling Null Values
byte length, name is a parameter name, ind-len is the length of an indicator parameter
name, and ind-name is an indicator parameter name. Each instance of IND^PTR
points to the length field for the corresponding indicator parameter name.
Like input parameter and output variable names, indicator variable names are padded
with blanks to even lengths.
When you are reading through the names buffer to prompt the user for parameter
names, you might need to be aware of the indicator fields and perform tasks such as:
1. Check the NULL^INFO field.
2. If NULL^INFO is -1, read the length field for the indicator.
3. Add this length field plus 2 to the pointer or index to skip to the next name in the
names buffer.
SQLVAR[1].VAR^PTR
len1 name1
SQLVAR[1].IND^PTR
ind-len-1 ind-name-1
SQLVAR[2].VAR^PTR
len2 name2
SQLVAR[2].IND^PTR
ind-len-2 ind-name-2
VST0707.vsd