running multiple SQL queries at the same time in Teradata

Question

1.80/5 (3 votes)

See more:

Hi,
I created 6 different SQL queries in Teradata SQL Assistant. In order to complete my project, I need to run 6 of them to get the final report that I want.
Could any body please show me how to put those 6 queries together into simple SQL statements to execute them at one time instead of run one by one.

Thank you,

Posted 31-Oct-13 12:12pm

Christine_13

Updated 5-Nov-13 3:23am

coded007

v4

Add a Solution

Comments

CHill60 3-Nov-13 9:56am

Without seeing the queries themselves we can't help. Are you trying to get all of the results into a single table/dataset that is returned from "something"? Have you tried contacting http://www.aquafold.com/support.html[^]

Christine_13 4-Nov-13 17:34pm

Hi,
My queries are long to post here.
In general, I created query1 to clean all existing tables, query2 to create a new list of customer, query3&4 to upload this list as Ushare table in Teradata, query5&6 to get the final reports.
In order to get the final reports, I need to run these 6 queries one by one because they are related to one another. I consider them as step1, 2,... and so on to get the final reports.
I'd like to know if there are any ways that I can execute them all at one time by using one single query.

Thank you,

syed shanu 5-Nov-13 1:14am

Hi,
Try to use Stored procedure where you can run all your 6 query one by one

Christine_13 5-Nov-13 12:13pm

Hi Syed,
Could you please lead me to build a stored procedure?
Consider Query1, Query2, Query3, Query4, Query5, and Query6 in order for this procedure.
I appreciate your help.

2 solutions

Solution 1

There is no such thing as "one time" in nature. You can talk about parallelism, but, as you explained yourself that your queries depends on each other (that should mean that one statement depends on the result of another one), they should be executed sequentially.

That's it.

—SA

Posted 5-Nov-13 3:54am

Sergey Alexandrovich Kryukov

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

syed shanu · Accepted Answer · 2013-11-05T18:42:00

Hi
Check this link hope this will help you to create SP in Teradata

http://readvitamin.com/2007/08/20/how-to-create-a-stored-procedure-in-teradata/[^]

SQL

Example:
CREATE PROCEDURE MyFirstProc (IN emp_number INTEGER,
                                             IN dept_number INTEGER,
                                             OUT dept_name CHAR(10),
                                             INOUT errstr VARCHAR(30))
BEGIN
        INSERT INTO Employee (EmpNo, DeptNo )
        VALUES (emp_number, dept_number);
        SELECT DeptName INTO dept_name FROM Department
        WHERE DeptNo = dept_number;
END;
To execute/call the above Stored Procedure:
CALL MyFirstProc (495, 211);