Ximi Elga


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;.

Author: Kazrarr Dairg
Country: Bhutan
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 17 June 2007
Pages: 66
PDF File Size: 6.76 Mb
ePub File Size: 17.60 Mb
ISBN: 169-9-43757-212-7
Downloads: 20693
Price: Free* [*Free Regsitration Required]
Uploader: Kigarisar

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.

The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! Join your peers on the Internet’s largest technical computer professional community. It’s easy to join and it’s free.


Register now while it’s still free! Close this window and log in. By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden.

TERADATA Blogger: Sample BTEQ Export

Does anyone know how to use the BTEQ export command to export hteq Everything I try to do pads the data with extra spaces.

What do you want to do with the data once it is exported? There are 4 different export modes in BTEQ.

The format is “. Does anyone have a fastexport script that will output a delimited file from a teradata table? 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

Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Students Click Here Join Us! Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.