Two Accounts, Same Data, Same Dicts, Different Formats

[Tom Pellitieri]

We're working on an upgrade of our software, and for some reason, TCL is listing a file differently between our test and live versions.  I've compared both the SB+ and UniData level dictionaries for the fields involved, but don't understand why the file would list differently.

The total width of the fields are too wide for the 80 column screen, but it gives results in a readable format on the live account, as seen here:

LIST F.LIVE ACCOUNT.NUM TOTAL CREDIT TOTAL DEBIT DOC.ID ID-SUPP

Account                         Credit         Debit
1!!100!30!!03320                 95.08          0.00
1!!100!30!!90990                 12.28          0.00
1!!100!70!!00125                  0.00         12.28
1!!200!30!!43320                168.15          0.00
1!!200!30!!53320                  0.00         95.08
1!!200!30!!68080                 12.28          0.00
1!!200!30!!90990                  0.00         12.28
1!!200!70!!00120                  0.00        180.43
1!!700!70!!19620                 12.28          0.00
Document Id                      2121658

========== finish result ==========
Account
       Credit                           300.07
        Debit                           300.07
Document Id
1 record listed

However, on our test upgrade account, the fields have shifted, as seen here:

LIST F.TEST ACCOUNT.NUM TOTAL CREDIT TOTAL DEBIT DOC.ID ID-SUPP

Account                          1!!100!30!!03320
                                 1!!100!30!!90990
                                 1!!100!70!!00125
                                 1!!200!30!!43320
                                 1!!200!30!!53320
                                 1!!200!30!!68080
                                 1!!200!30!!90990
                                 1!!200!70!!00120
                                 1!!700!70!!19620
       Credit         Debit
        95.08          0.00
        12.28          0.00
         0.00         12.28
       168.15          0.00
         0.00         95.08
        12.28          0.00
         0.00         12.28
         0.00        180.43
        12.28          0.00
Document Id                      2121658

========== finish result ==========
Account
       Credit                           300.07
        Debit                           300.07
Document Id
1 record listed

Any ideas, thoughts, etc?

--Tom

[precisonline]

To verify if it has something to do with the dictionaries, list both files with the USING DICT F.LIVE and see if they both show up properly. If they do, then the problem is most likely the F.TEST dictionaries.  If F.TEST shows wonky with the F.LIVE dictionaries, then it's more likely the TERM setting.