Hello there,
I have a sequential file with 76 coloums with the following datatypes
varchar,decimal,Integer,timestamp
How can I combine all these fields to one column and what should be the datatype of the resulting column.
Thank you
Sai
Concatinate columns
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Data type string is the only possibility. You need to convert each of the non-string data types to string and concatenate.
This seems to be a strange requirement.
This seems to be a strange requirement.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.