Can you please let me know how i can write the script for getting data as follows: col1 col2 col3 data1 data2 data3 Source is a simple Teradata table. The output is an excel sheet.. I've tried searching the net but was unable to find a solution. Please help soon. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. Hi Anu, Please write the script as below.
|Published (Last):||9 April 2010|
|PDF File Size:||9.83 Mb|
|ePub File Size:||10.66 Mb|
|Price:||Free* [*Free Regsitration Required]|
Can you please let me know how i can write the script for getting data as follows: col1 col2 col3 data1 data2 data3 Source is a simple Teradata table. The output is an excel sheet.. I've tried searching the net but was unable to find a solution.
Please help soon. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. Hi Anu, Please write the script as below. GOTO Failure;. You can use the below sample code:. Once the file is created.
Hi, I am not sure whether my suggestion would help your or not. Just go thru. Go to file menu and then enable the export results option. When you try to run the query you will asked to save the results in a file. XLS Hope this would work. Teradata Environment is new to me and I beg your pardon if my idea was not relevant to your Question.
I am guessing that most people don't understand that you can use the native capabilities of Excel to go out and query a database. When you exit this, choose "return data to MS Excel". Hi All, A very interesting discussion is goin on over here. Ya I understand that sometimes in the project you'll face such problems - similiar problem is there in my project where i want to take the output of the query in an unix variable can any one guide me for the same - The solution given by Anu is excellent and worked too.
Thanks for your help anu. Tech Sign In Page. Forgot Password? Don't have an account? Sign up. Follow Tech Sign In Page. February 27, PM. Something went wrong on our end. Please try again later. Tom Robbins. February 28, AM. SivaPrakash Jayaraman. February 28, PM. Whats the need of BTEQ???????? Farhan Nisar. March 03, AM. Charudatt Gadekar. March 03, PM.
That is not what I am saying. Do not use SQL Assistant. Do not use BTEQ. Shaounak Nasikkar. July 07, AM. Sign In to Post a Comment. Sign In. Hide Comments View Comments. Looking for more? Search the archive of solutions and how-to's. Ask a new question to a community of peers. Zoom to Partner With Oracle for Cloud. Oracle Cloud: Invoice Tolerance.
Can we disable "Accrue at receipt" flag for the Inventory?
Teradata BTEQ – Part 2
December December 22, You can execute queries, export data, and import data. Data lineage with ETL Tools? Usually not given. A little transformation here, a little transformation there…and it's impossible to understand what exactly happens in the ETL process.
Share your knowledge with other Developers in REVISIT CLASS.