SQL Programming Manual for TAL

Dynamic NonStop SQL Operations
HP NonStop SQL Programming Manual for TAL—527887-001
7-34
Using Statement and Cursor Host Variables
Figure 7-6. Statement and Cursor Host Variables (page 1 of 2)
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL END DECLARE SECTION;
.sbuf := @ibuf '<<' 1;
STRING
INT
INT
INT
STRING
INT
INT
.buf^end;
.home^term[0:11];
home^term^fnum;
.ibuf[0:19];
i;
sqlcode;
?SQL
?INSPECT
?SYMBOLS
?NOCODE, NOMAP, NOLMAP
?DATAPAGES 64
answer;
.curs[0:2]; - - Table of 3 cursor names
INT(32)
STRUCT
BEGIN
STRING name[0:1];
END;
.stmt[0:2]; - - Table of 3 statement namesSTRUCT
BEGIN
STRING name[0:1];
END;
LITERAL
STRUCT
BEGIN
STRING str[0:TEXT^LEN-1];
END;
TEXT^LEN = 80;
.text[0:2]; - - Table of text for 3 statements
? NOLIST
? SOURCE $SYSTEM.SYSTEM.EXTDECS (
? CLOSE,
? DNUMOUT,
? INITIALIZER,
? MYTERM,
? OPEN,
? WRITE
? )
? LIST
VST0706.vsd