Issue:
The output of “/OSS/NEX/nexoss/unix/bin/start_table_to_file.sh” seems to have changed. All the currency values and many other important columns are coming in as 0 (Ex. O_BillingAmountCustCurr and O_BillingAmounFuncCurr).
Troubleshoot:
The select statement by default selects all columns in the order that they are defined.
$ cd $NexOSS_HOME/etc
$ vi SQL.etc
~
Table2File.SELECT=SELECT {0}.* FROM {0} WHERE {0}.UPDATABLE=''Y''
Perhaps you can modify the way that you interpret the data.
Another option is to change the statement to select only the columns that you need, and the order that you prefer.
Note: UPDATABLE column is required to be in the select list.
Example:
Table2File.SELECT=SELECT O_BillingAmountCustCurr, O_BillingAmounFuncCurr, O_Duration, UPDATABLE FROM {0} WHERE {0}.UPDATABLE=''Y''