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):||17 April 2008|
|PDF File Size:||5.21 Mb|
|ePub File Size:||9.52 Mb|
|Price:||Free* [*Free Regsitration Required]|
Sign up using Facebook. But as ULick already stated, csv doesn’t have grid lines or bold headers.
Teradata – BTEQ
I need to use UNIX. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Everything I try to do pads the data with extra spaces.
I don’t believe that FastExport allows delimited files, unless you want to concatenate a delimiter between each field. While doing this I face 3 issues: Click Here to join Tek-Tips and talk with other members! There are 4 different export modes in BTEQ. Close this window and log in. Aswath M 1 1.
Sign up using Email and Password. Btfq help as to how I can retain them. Join your peers on the Internet’s largest technical computer professional community.
TERADATA Blogger: Sample BTEQ Export
You may add terminal escape codes in your SQL query, but I wouldn’t recommend it. What do you want to do with the data once it is exported? The format is “. ULick 3 Promoting, selling, recruiting, coursework and thesis posting is forbidden.
It’s easy to join and it’s free. By the way, creating a csv file with grid lines is somehow contradictory. Post as a guest Name. Is it possible to put Grid lines, only in the records which contain data? Register now while it’s still free!
The leading zeroes of few columns get dropped. I am not sure how to make the Headers bold, to make eport look better. Leading zeros exporrt added with a explicit format-phrase see Formatting Characters for Non-Monetary Numeric Information select 4 format ‘,99’ ; There are no terminal capabilities built in Basic Teradata Query.
Does anyone know how to use the BTEQ export command to export data? Does anyone have a fastexport script that will output a delimited file from a teradata table?
By joining you are opting in to receive e-mail.
BTEQ – Exporting results to a file in Teradata
Students Click Here Join Us! Expodt Tek-Tips staff will check this out and take appropriate action.