Scott Palmer
asked on
Export file with bad column names
Using Teradata to export a query. I am exporting it in pipe delimited text file. The export works except that the column headings come out with all of the format like this:
((((((((Member_ID||'|')||P roduct_ID) ||'|')||Va lid_From)| |'|')||Val id_Till)|| '|')||Enro llment_ID_ Type)
Here is my code:
SELECT Member_ID || '|' || Product_ID || '|' || Valid_From || '|' || Valid_Till || '|' || Enrollment_ID_Type
FROM Medicare_Enrollment
;
Is there a way to have the columns come out like they are in the table?
Thanks,
Scott
((((((((Member_ID||'|')||P
Here is my code:
SELECT Member_ID || '|' || Product_ID || '|' || Valid_From || '|' || Valid_Till || '|' || Enrollment_ID_Type
FROM Medicare_Enrollment
;
Is there a way to have the columns come out like they are in the table?
Thanks,
Scott
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Arana.
Scott