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
 

 

Some DB2 Interview Questions

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Mon Jan 18, 2010 12:17 pm    Post subject: Some DB2 Interview Questions
Reply with quote

Hi All,


1) We have a internal tool which will accept GDG name as an input, but we can't pass the GDG with the Generations like 0,-1,-2.. but it has to take the latest generation with the generation no like GDGname.G0010V00, how can we pass this to the tool. We are not suppose to pass the generation no directly also.


2) Db2 question
name code
aaa 1
bbb 1
ccc 2
ddd 1
eee 3

if we give select * from tablename where code = 1 then the output will be

name code
aaa 1
bbb 1
ddd 1

but the expected output should be

aaa bbb ddd
1 1 1

how can we achieve this either by using sql query or any logic in program.

karthik
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jan 19, 2010 6:12 am    Post subject:
Reply with quote

Hello,

Post how you answered and we can tell how well you did. . .

Both questions have been topics in this forum. Find related topics and if you find sojmething that is not clear, post what you found and your doubt avout what you found and someone will be able to clarify.
Back to top
View user's profile Send private message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Tue Jan 19, 2010 2:48 pm    Post subject: Reply to: Interview Questions
Reply with quote

Hi Dick,

I didn't answer for those questions.

I even searched in this forum but it is showing many links which is not relevant to the topic.

Can you tell me how to search in this forum and also if possible send me the link of previous answers.

Thanks
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 20, 2010 2:05 am    Post subject:
Reply with quote

Hello,

Quote:
I even searched in this forum but it is showing many links which is not relevant to the topic.
As with the internet in general, the better the search criteria specified, the more useful the "hits". Lots of practice also helps - but that will take some time.

When using the forum SEARCH, you'll do better if you specify multiple keywords and only search in the part of the forum you are interested in. Again, practice is your friend icon_smile.gif

Try here for info about the gdg question:
http://ibmmainframes.com/viewtopic.php?t=44607

If you have QMF, you might use ACROSS to solve the query. Otherwise, write code and use arrays.
Back to top
View user's profile Send private message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Wed Jan 20, 2010 11:26 am    Post subject: Reply to: Some DB2 Interview Questions
Reply with quote

Hi dick,

Thanks a lot for your answers. I will follow the way you mentioned for Search.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 21, 2010 5:02 am    Post subject: Reply to: Some DB2 Interview Questions
Reply with quote

You're welcome - good luck icon_smile.gif

When you get stuck, someone will be around. . .

d
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am
This topic is locked: you cannot edit posts or make replies. Mainframe interview on 10th Oct 2015 ... kotesh Mainframe Jobs 0 Thu Oct 08, 2015 5:21 pm


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