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

ManualsBrandsHP ManualsServerHP NonStop G-Series

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 }