Data Definition Language (DDL) Reference Manual (G06.24+)

Index
Data Definition Language (DDL) Reference Manual—426798-002
Index-17
S
sample database schema B-2
sample SPI user subsystem
definitions B-10
sample ZSPIDEF.ZSPIDDL
definitions B-9
SECTION command 9-94
Section name
DDL schema 9-94
host-language source code 9-96
reference in source schema 9-98
Sequence of keys 5-22
SERIALWRITES file attribute 5-17
SETLOCALENAME command 9-95
SETSECTION command 9-96
Shift to uppercase characters 6-73
SHOW USE OF statement 8-11
SIGN LEADING in COBOL 6-29
SIGN LEADING SEPARATE in
COBOL 6-29
SIGN TRAILING in COBOL 6-29
SIGN TRAILING SEPARATE in
COBOL 6-29
Signed numeric string
PICTURE clause 6-27
TYPE clause 6-48
Simple statement 2-12
Simple token 7-1
Sort field in RECORD statement 5-22
Source code generation
for programming languages 1-3
from entire schema 1-8
from selected definitions 1-8
OUTPUT statement 8-5
SOURCE command 9-98
SPACE(S)
MUST BE clause 6-17
VALUE clause 6-80
SPACING command 9-99
Special characters 2-8
SPI
constants 4-9
messages, defining 1-3
null value 6-35
null value, token map 7-16
sample schema B-7
standard definitions
in token map definitions 7-19
token code 7-11
token type 7-5
standard names
token code 7-11
token type 7-5
tokens
DDL definitions for 1-1
in SPI messages 7-1
SPI-NULL clause
DEFINITION statement 5-7
RECORD statement 5-20
syntax 6-35
SQL data types
and host languages 6-52
DATE 6-49
DATETIME 6-49
in VALUE clause 6-83
INTERVAL 6-49, 6-54
SQL DATETIME 6-49, 6-53
TIME 6-49
TIMESTAMP 6-49
VARCHAR 6-49, 6-52
SQL DATE data type 6-49
SQL DATETIME data type 6-49
SQL INTERVAL data type 6-49
SQL literal 6-80
SQL TIME data type 6-49
SQL TIMESTAMP data type 6-49
SQL VARCHAR data type 6-49
SQLNULL
in VALUE clause 6-83
SQLNULLABLE clause
syntax 6-38
SSID clause