SQL Programming Manual for TAL

Dynamic NonStop SQL Operations
HP NonStop SQL Programming Manual for TAL—527887-001
7-24
Using the Names Buffer
Some examples of entries in the names buffer are:
To prompt the user with the parameter names in the input names buffer, you must read
the length of the name and then position a pointer past the length field and onto the
name. Figure 7-4
shows code to use the names buffer, prompt for input, and read
parameter values input by the user.
Complete Entry Entry Part Description
|04|ABCD| |04|
|ABCD|
2-byte length 4-character string with value = 4
4-character string
|06|ABCDE | |06|
|ABCDE |
2-byte length 4-character string with value = 6
5-character string padded with 1 trailing blank
|00| | |00|
| |
2-byte length with value = 0
Null string
A complete names buffer with the names shown in this example might look like this:
|04|ABCD|06|ABCDE |00|
Note. If the SQL statement includes indicator parameters, the indicator parameter names are
included in the names buffer. For more information, see Handling Null Values
on page 7-36.