Changing column positions
Moderators: chulett, rschirm, roy
Changing column positions
Hey, is there a simple way to reposition the columns that is got from the metadata. Only thing I could do is insert columns, but with all the typings. Importing metadata does not provide solution since it maintains the original order. I require it for maintaining the column order to be used by the BI tool.....That guy wants it that way.
If you are using column generated or fully generated then the columns can be in any order.
I have a routine which will sort the column names in DS_METADATA. I am looking for it now. When I find it then I will post it if you ask for it. I thought I already had.
Updating DS_METADATA and other IBM hash files is dangerous. Do not blame me if you break your project. I know how to recover from these kinds of errors. I am very comfortable doing this. I learned the format of this table from a post from Ray. He posted a way to extract this table to comma delimited and XML. Look for this routine.
I have a routine which will sort the column names in DS_METADATA. I am looking for it now. When I find it then I will post it if you ask for it. I thought I already had.
Updating DS_METADATA and other IBM hash files is dangerous. Do not blame me if you break your project. I know how to recover from these kinds of errors. I am very comfortable doing this. I learned the format of this table from a post from Ray. He posted a way to extract this table to comma delimited and XML. Look for this routine.
Mamu Kim