Back to SPR List Previous Next
VALID VALUES, and CAT VAR lists can become zeros after unload reload
Moderate Closed - Fixed Found:XS.01.07 17 SEP 2007 Fixed:XS.01.08 19 SEP 2007

DETAILS
 When VALID VALUES or CAT VARS are added to a database schema then the database is
 unloaded and reloaded then the value lists can become all zeros.
EXAMPLE PROGRAM
 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'
WORKAROUND
Export and import the database after adding valid values / cat vars
Back to SPR List Previous Next