|
|
|
Junior Member
 
Group: Forum Members
Last Login: 6/18/2007 5:02:00 PM
Posts: 18,
Visits: 1
|
|
Hi,
I have some 1000 SQL statements which I have written based on different logic. Now I need to run those scripts and verify results againse DB. I can manually run all scripts and verify the results manually against DB.
I need some idea or information if these can be done more efficiently by some sorts of automation or any such tool.
If anyone came with such situation then please pass me the information.
Thanks,
rlaskar
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 12/13/2006 3:52:00 PM
Posts: 14,
Visits: 1
|
|
rlaskar:
To my knowledge, there are two ways you can automate.
1: Type in all your SQL statements in SQL Assistant. Got to Teradata SQL Assistant's Menu > File > Export Results option. After selecting the option hit F5 function key (or run the SQL). It will ask for enter a file name to save the output. (if you are using Teradata 7.1.0.07 version, go to Tools > options > Export/Import tab and select appropriate options to write the output).
2: Type all your SQL statements in BTEQ script and execute the BTEQ script. Divert your output using a nohup statement.
Regards S S
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/9/2007 3:07:00 PM
Posts: 13,
Visits: 1
|
|
|
I am not entirely clear what do you mean by verifying results against DB, but if the only thing you need is to compare the results against some fixed values, you could use the http://www.excelsql.com/ and do it in Excel.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/24/2008 11:55:46 AM
Posts: 168,
Visits: 45
|
|
As suggested by Mr.Shastry, you can either use SQL assistant's export option or re-direct the out while running the BTEQ script.
One other way is to use BTEQ's .Export command.You have several modes in which BTEQ transfer the output to destination file.
Leo Issac "Wants to Learn More!"
|
|
|
|