If you are wondering how to export a file in SQL assistant with delimited characters like a comma, tab, pipe, or a hash then follow the steps. 

1. First set desired delimiters.

1. Go to menu Tools.
2. Select the menu item Options.
3. Go to the tab Export/Import.
4. You would see a label and a drop down box which says:
5. ‘Use this delimiter between columns in files’.
6. Choose/Select your desired delimiter.
7. Click OK.

You can also have the option present to enclose the columns in single or double quotes. 

2. Execute the Export option from Teradata SQL Assistant:

1. Select File menu and click on the item Export Results.
2. You would see a gray menu bar at the top of the screen, you should see the message ‘Results are redirected to a file or table’.
3. In the Query window, enter your SQL query.
4. Execute your SQL query.
5. You will be prompted for the location of the file to be exported to.
6. Give a name for the file, and click OK.
7. The export process will begin. At the lower left gray margin, you should see a counter incrementing as each row is exported.
8. When finished, the gray menu bar at the top of the screen will say ‘Results were written to <filename path>’

3. Come out of export mode by selecting File and again clicking Export Results item.

Our Random Articles

• Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
• How To Choose A Good Online Traffic School
• New Year Wishes 2010
• New Year Wishes
• How to use EXTRACT function with date and time columns

More Links