table-to-file Script Output Column Order

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''