Data Definition Language (DDL) Reference Manual
Syntax Summary
Data Definition Language (DDL) Reference Manual—529431-004
F-13
PICTURE Clause
PICTURE Clause
picture-string
{ alphanumeric-string | numeric-string }
alphanumeric-string
{ A | X | 9 }...[(length)]
numeric-string
{ [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
{ { N | n } [(length)] }
{ { N | n }... }
REDEFINES Clause
SPI-NULL Clause
SQLNULLABLE Clause
PIC[TURE] { "{picture-string }" }
{ {national-picture-string } }
{ }
{ {picture-string } }
{ {national-picture-string } }
REDEFINES { field-name | group-name }
SPI-NULL {"character " | number | constant-name }
[NOT]SQLNULLABLE