Syntax Summary
Data Definition Language (DDL) Reference Manual — 426798-002
F- 10
OCCURS DEPENDING ON Clause
OCCURS DEPENDING ON Clause
OCCURS min TO max TIMES DEPENDING ON field-name
[ INDEXED BY index-name ]
PICTURE Clause
PIC[TURE] [“] {picture-string } [“]
{ national-picture-string }
picture-string is:
{ }
{ X...[(length)] }
{ A...[(length)] }
{ 9...[(length)] }
{ N...[(length)] }
{ [S]9...[(length)[V[9...[(length)]]]] }
{ T[9...[(length)[V[9...[(length)]]]] }
{ 9...[(length)[V[9...[(length)]]]]S }
{ 9...[(length)[V[9...[(length)]]]]T }
{ }
national-picture-string is:
{ N } ...[(length)]
{ n }
REDEFINES Clause
REDEFINES { field-name }
{ group-name }
SPI-NULL Clause
{ “character” }
SPI-NULL { number }
{ constant-name }
SQLNULLABLE Clause
{ SQNULLABLE }
{ NOT SQNULLABLE }