field order

Hi,

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?

Thanks in advance,

Cori Griswold
PricewaterhouseCoopers


Listserv Archives (BOB member since 2002-06-25)

Please disregard this message…I was finally able to get through to the archives web page and found the answer there. Sorry for the inconvenience!

Cori Griswold
PricewaterhouseCoopers


Listserv Archives (BOB member since 2002-06-25)

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.

Thanks,
Lynne Fee


Listserv Archives (BOB member since 2002-06-25)

Cori,

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?


Listserv Archives (BOB member since 2002-06-25)