Concatinate columns

[saikiran]

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

[ray.wurlod]

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.