Guest_imported
New member
- Jan 1, 1970
- 0
How do I create a delimited file in teradata fastexport ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
delimited file
- Thread starter Guest_imported
- Start date
- Status
In your 'select' statement make every other column either a comma or a space:-
Select col1
,','
,col2
,','
,col3
From Table
;
If you need a delimited file with alined columns then cast each column as a character field. This will ensure that the column is always 'n' characters wide regardless of the value held.
Select col1
,','
,col2
,','
,col3
From Table
;
If you need a delimited file with alined columns then cast each column as a character field. This will ensure that the column is always 'n' characters wide regardless of the value held.
- Status
Similar threads
- Locked
- Question