SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-11
S
Relative table
insert into 3-20
RELEASE 2 option
in INCLUDE SQLDA directive D-11
RELEASE statement, SQL 3-31
RELEASE1 option
in INCLUDE SQLDA directive D-11
in SQL directive 3-36, D-11, D-14
RELEASE2 option
in SQL directive 3-36
, D-11, D-14
Renaming program file
effect on SQL validity 5-23
REPLY system procedure 7-3
Requester, SCREEN COBOL 7-3
Reserved words, SQL
for C10 program migration D-5
RESTORE/BACKUP
version issues D-10
Retrieving data
multiple rows 3-34
single row 3-33
with cursor 3-35
RETURNING LASTSYSKEY option,
INSERT statement 7-6
RISC (TNS/R) system 1-7
Row in SQL table
deleting 3-14
fetching 3-7, 3-18, 3-29
inserting data in 3-19
selecting 3-32, 3-34
updating 3-43, 3-44
RTDU
See Run-time data unit (RTDU)
RUN command
for SQL program file 1-7
RUN command, TACL
for SQL object file 1-7
, 5-30
Run option, TACL
for SQL object file 5-31
for SQLCOMP command 5-6
Run option, TACL (continued)
for TAL compiler 5-3
RUND command, TACL
for SQL object file 5-30
Run-time data unit (RTDU) 3-37
Run-time memory allocation 7-14
Run-time recompilation errors 5-28
S
Scale
from DATA^LEN field 7-27
SEARCH directive, TAL compiler 5-4
Section location table
(SLT) 3-37
Security attribute, altering
effect on SQL validity 5-23
SELECT statement, SQL 3-31
Selecting data, cursor declaration 3-11
Semicolon (;)
in SQL statements 1-2
, 3-1
Sequential I/O (SIO) procedures 4-2, 4-6,
4-8
, 4-14, 4-22, 4-23
SET DEFINE command, TACL 5-19
Set operations
delete 3-14
update 3-44
SETSCALE SQL function 2-4, 2-5, 2-7,
2-12
, 2-13, 3-21
Shared memory, using 3-41
Single row in SQL table
deleting 3-14
selecting 3-32
updating 3-43
Single-code thread design D-13, D-14
SIO
See Sequential I/O (SIO)
procedures 4-22
Sizing SQL data structures 3-41
SLT
See Section location table (SLT)
Sort operations, using TACL DEFINEs 5-32