Fujitsu UDS/SQL V2.5 用户手册

User interface

U929-J-Z125-9-76

  

187

D

ok

us

c

h

abl

on

en

 1

9x

24 V

e

rs

ion

 7

.3

us

 f

ü

r F

ram

eM

ak

er

 V

7

.x

v

o

m

 1

4.

02

.2

00

7

©

 c

o

gni

tas

 Gm

b

H

 20

01-

20

07

18

. Ok

tobe

r 20

07

  S

ta

nd

 1

1:

29

.4

9

P

fa

d:

 G

:\

v

og

t\

fs

c

\ud

s

\M

anu

al

e

\e

n\

ud

s

e

nt

_e\

u

ds

ent

.k

0

6

The item definition with PICTURE and USAGE clauses can be derived from the following 

, 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.

numeric,
unpacked

PICTURE IS
mask-string

PICTURE IS mask-string
[USAGE IS DISPLAY]

 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