I have a universe set up in DB2…the columns displayed are in the proper order (i.e., the order in which they were created in the table). However, we are setting up an Oracle8 universe but now the columns are in alphabetical order. Is there a parameter I can set somewhere to override this or is it database specific?
In a message dated 8/19/98, Cori wrote: I have a universe set up in DB2…the columns displayed are in the proper order (i.e., the order in which they were created in the table).
However,
we are setting up an Oracle8 universe but now the columns are in alphabetical order. Is there a parameter I can set somewhere to override this or is it database specific?
Try adding the parameter ColSort=13 in the Defaults section of the Oracle8.sbo file.
This brings the columns in in the order they were created in the table with Oracle7.3, so I
assume this works for Oracle8 also.
You can change the value of the COLSORT parameter in the ociv8.sbo file to 13 (file can be found in oracle folder of BO). It now has probably the value 3 which means that colomns will be sorted in alphabetiocal order.
Regards,
Raymond van Beekum
ING Netherlands
Cori Griswold wrote:
I have a universe set up in DB2…the columns displayed are in the proper order (i.e., the order in which they were created in the table). However, we are setting up an Oracle8 universe but now the columns are in alphabetical order. Is there a parameter I can set somewhere to override this or is it database specific?