SQL Programming Manual for TAL

NonStop SQL Statements and Directives
HP NonStop SQL Programming Manual for TAL—527887-001
3-42
SYMBOLPAGES
°
Specify the STACK option to allow TAL to create a default extended segment
for initial placement of the data structures.
°
Convert the program to use the default extended segment and specify the EXT
option (or allow EXT to be the default). For some programs, the MAPPED
option might be simpler to implement than to convert the program.
°
Specify the MAPPED option. As for the STACK option, TAL creates a default
extended segment to store the data structures initially.
•
If your program uses the default extended segment and also manages additional
extended segments, use SQLMEM based on your specific environment and the
guidelines in this section.
•
Because memory allocation can change in various parts of a program, you might
need to specify SQLMEM more than once.
SYMBOLPAGES
The SYMBOLPAGES TAL compiler directive specifies the number of 2048-byte pages
that the TAL compiler allocates for the symbol table. The TAL compiler uses the symbol
table as a temporary storage area in memory for processing variables.
The syntax for SYMBOLPAGES is:
num-pages
specifies the number of pages that the TAL compiler should allocate for the symbol
table in the automatic extended data segment. The range is 512 through 32767
pages. The default is 512 pages.
If a symbol table overflow occurs, the TAL compiler displays error 57 (symbol table
overflow). Use SYMBOLPAGES to enlarge the size of the table.
To specify the SYMBOLPAGES directive, you must issue the directive on the
command line for the TAL compiler when you compile a program. For example:
TAL /IN tsrc, OUT $s.#tlst, NOWAIT/ tobj; SYMBOLPAGES 4096
UPDATE
The UPDATE statement updates values in one or more columns in a row or set of rows
of a table or a protection view. The number of rows is determined by the WHERE
clause. An UPDATE statement can update:
•
A single row
•
A set of rows
SYMBOLPAGES num-pages