Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Queries on SQL,Teradata

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Jayalakshmi

New User


Joined: 02 Sep 2005
Posts: 26
Location: Hyderabad

PostPosted: Fri Sep 22, 2006 8:30 pm    Post subject: Queries on SQL,Teradata
Reply with quote

Hi all,

I have some couple of questions;

(1) Suppose that I have 16 different tables and I have to retrieve a set of data based on Where Conditions using 1st 4 tables and again retrieve another set of data based on Where conditions using next 4 tables and so on..
After this i need to merge all these 4 sets of data into a single dataset with just one column as a common entity.
I want to do all this as a single Query.. Any suggestions on how to do this...
(2) Any inputs about Inline View?
(3) Any Inputs about Teradata?

Regards,
Jaya.
Back to top
View user's profile Send private message

anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Tue Sep 26, 2006 11:56 am    Post subject:
Reply with quote

Hi Jayalakshmi,


1) your question is not clear. But if i have understood correctly, then a clue for your first question is db2 utlilities.

If you want to ask generic questions like your second and third questions, then it is better to find out from Google.

referto links below for your second and third:

http://en.wikipedia.org/wiki/Teradata

http://www.dbazine.com/db2/db2-disarticles/gulutzan9

Anamika
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
This topic is locked: you cannot edit posts or make replies. Sr. System Analyst & SA Positions... Heeraj Mainframe Jobs 0 Wed Apr 30, 2014 12:27 pm
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us