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):||28 January 2014|
|PDF File Size:||8.48 Mb|
|ePub File Size:||2.90 Mb|
|Price:||Free* [*Free Regsitration Required]|
Sign up using Email and Password.
Red Flag This Post Please let us know here why this post is inappropriate. By the way, creating a csv file with grid lines epxort somehow contradictory. Is it possible to put Grid lines, only in the records which contain data?
Click Here to join Tek-Tips and talk with other members! Thank you for helping keep Tek-Tips Forums free from inappropriate posts. I don’t believe that FastExport allows delimited files, unless you want to concatenate a delimiter between each field.
BTEQ – Exporting results to a file in Teradata – Forget Code
The Tek-Tips staff will check this out and take appropriate action. Post as a guest Name. Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Teradata – BTEQ
You may add terminal escape codes in your SQL query, but I wouldn’t recommend it. While doing this I face 3 tbeq Close this window and log in.
BTEQ – Exporting results to a file in Teradata
Email Required, but never shown. By joining you are opting in to receive e-mail. What do you want to do with the data once it is exported?
The leading zeroes of few columns get dropped. Please do not suggest to use Teradata Export. Students Click Here Join Us! Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. I need to use UNIX. Leading zeros are 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.
Everything I try to do pads the data with extra spaces. Sign up or log in Sign up using Google.
I am not sure how to make the Headers bold, to make it look better.