Run the following schema of company then UNLOAD/RELOAD
MAX INPUT COLS 80
RECORD SCHEMA 4 VALID /LOCK
DOCUMENT VALID Record (4)
DATA LIST (1)
ID * (I2)
CAT * (A3)
INT * (I1)
CAT VARS CAT ( 'AAA'
'BBB'
'CCC'
'DDD' )
STRING LENGTH 32
VALID VALUES INT ( 1
2
3
4
5
6
7
8
9 )
END SCHEMA
After Unload / Reload you can see the schema now has blanks and zeros for the valid values.
CAT VARS CAT (''
''
''
'' )
VALID VALUES INT (0
0
0
0
0
0
0
0
0)
VALUE LABELS CAT ('')'AAA'
('')'BBB'
('')'CCC'
('')'DDD'
|