Link to home
Start Free TrialLog in
Avatar of Scott Palmer
Scott PalmerFlag for United States of America

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||'|')||Product_ID)||'|')||Valid_From)||'|')||Valid_Till)||'|')||Enrollment_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
ASKER CERTIFIED SOLUTION
Avatar of Arana (G.P.)
Arana (G.P.)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Scott Palmer

ASKER

Yes, I know what you are talking about.  I have seen that before in some other programs.  I think I can figure it out.

Thanks Arana.

Scott