Originally posted by: SystemAdmin

I have what I consider to be an unusual requirement. A client wants data selected from an Access table, and written to a Sybase table. Getting the data is simple enough, but the client also wants the column names as part of the result set, i.e.

"ColumnOne", "ColumnTwo", "ColumnThree"
"123", "ABC", "456"
"789","XYZ","987"
etc...

I expected to do a system table query, like "Select ColumnNames From SysObjects Where TableName = MyTable", but I can't find anything like that. Has anyone solved an issue like this?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

If this is goint to be a map that is used in a system for some time, you might just want to hard code the column names, ir run the SQL and put the info in a file. You wouldn't normally change the column names in a production DB.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

You are correct, I wouldn't normally change column names in a production database. But, I have no control over the database, nor does the client who is reading the database. I tried pointing out to him that he should just be requesting the information that he knows he wants, and that we could change the maps when the need comes up.

The actual response was: If we do it this way (select all column names, followed by the records), then whatever data is required is already there.

The client doesn't want to get back to me for changes, it HAS to be included whether he needs it or not.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

I recently had a request to capture or create metadata for data in a table along with the data itself. I exported the type tree and then read the XML export file into the map and passed or computed the values I needed to the output.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

If there will be changes to the names or number of columns, even if you do what divokyj@nationwide.com (good suggestion too). suggests, the customer will still need to re-map, since the tree will need to be changed.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange