View previous topic :: View next topic
|
Author |
Message |
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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
Try here for info about the gdg question:
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 |
|
|
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
Hi dick,
Thanks a lot for your answers. I will follow the way you mentioned for Search. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome - good luck
When you get stuck, someone will be around. . .
d |
|
Back to top |
|
|
|