ABC, XYZ, Main theme is to load the same exported data using BTEQ import .csv file). Please suggest me how to skip the column. I am runnign the following fast export and getting a chararcter ‘N’ in the beginng of my data. Please let me how to get the data without the unwanted character in. Sample BTEQ Export. exec 1> 2>&1 bteq << WIDTH ;.SET SESSION TRANSACTION BTET;.run file LoginFile;.
|Published (Last):||1 March 2009|
|PDF File Size:||4.17 Mb|
|ePub File Size:||10.88 Mb|
|Price:||Free* [*Free Regsitration Required]|
BTEQ – Exporting results to a file in Teradata
Close this window and log in. I need to use UNIX. Please do not suggest to use Teradata Export. While doing this I face 3 issues: Register now while it’s still free! Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.
The leading zeroes of few columns get dropped. By the way, creating a csv file with grid lines is somehow contradictory. Aswath M 1 1. You may add terminal escape codes in your SQL query, but I wouldn’t recommend it. The format is “. There are no terminal capabilities built in Basic Teradata Query. I don’t believe that FastExport allows delimited files, unless you want to concatenate a delimiter between each field. Join your peers on the Internet’s largest technical computer professional community.
I am not sure how to make the Headers bold, to make it look better. Email Required, but never shown. But as ULick already stated, csv doesn’t have grid lines or bold headers. Does anyone have a fastexport script that will output a delimited file from a teradata table? Please help as to how I can retain them.
What do you want to do with the data once it is exported? Everything I try to expot pads the data with extra spaces.
BTEQ – Exporting results to a file in Teradata – Forget Code
Post as a guest Name. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.
By joining you are opting in to receive e-mail.
Teradata – BTEQ
Sign up using Email and Password. ULick 3 Does anyone know how to use the BTEQ export command to export data? The Tek-Tips staff will check this out and take appropriate action.
Sign up or log in Sign up using Google. Red Flag This Post Please let us know here why this post is inappropriate.
Click Here to join Tek-Tips and talk with other members!