Fujitsu UDS/SQL V2.5 Network Router User Manual


 
User interface Subschema DDL
U929-J-Z125-9-76 187
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
18. Oktober 2007 Stand 11:29.49 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k06
The item definition with PICTURE and USAGE clauses can be derived from the following
table 12, where n, m and l denote integers.
If no entry is specified for USAGE and the mask string does not contain the symbol N,
DISPLAY is assumed by default. If the mask string contains the symbol N, NATIONAL is
assumed if the USAGE clause is missing.
Item type Item definition in schema Item definition in subschema
numeric,
unpacked PICTURE IS
mask-string
PICTURE IS mask-string
[USAGE IS DISPLAY]
mask-string identical with mask-string in
schema
alphanumeric,
fixed length
TYPE IS CHARACTER m PICTURE IS X(m) [USAGE IS DISPLAY]
national PICTURE IS N(m) PICTURE IS N(m)
[USAGE IS NATIONAL]
numeric,
packed
TYPE IS
FIXED REAL DECIMAL n,m
for n > m, m > 0
PICTURE IS S9(l)V9(m)
USAGE IS COMPUTATIONAL-3
l:= n - m
for n > 0, m < 0 PICTURE IS S9(n)P(-m)
USAGE IS COMPUTATIONAL-3
for n < m
PICTURE IS SP(l)9(n)
USAGE IS COMPUTATIONAL-3
l:= m - n
for n = m PICTURE IS SV9(n)
USAGE IS COMPUTATIONAL-3
for m = 0 PICTURE IS S9(n)
USAGE IS COMPUTATIONAL-3
binary
TYPE IS FIXED REAL
BINARY 15
PICTURE IS S9(l)
USAGE IS COMPUTATIONAL
l: = 1,2,3,4
BINARY 31
PICTURE IS S9(l)
USAGE IS COMPUTATIONAL
l: = 5,6,7,8,9
Table 12: Item definition with PICTURE and USAGE clauses