 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 10 matches |
| Author | Message |
|---|---|
 Topic: Query on Cursors |
|
| CRaviKota Replies: 6 Views: 3269 |
 Forum: Application Programming Posted: Thu Jan 18, 2007 8:02 am Subject: Query on Cursors |
Thanks for your replies again  |
|
| Topic: Query on Cursors |
|
| CRaviKota Replies: 6 Views: 3269 |
Forum: Application Programming Posted: Wed Jan 17, 2007 10:03 am Subject: Query on Cursors |
| Thanks to all for your quick replies,
But as I mentioned earlier "Given a cursor C1 on table T1. For every row fetched from T1, open a cursor C2 on table T2. For every row fetched from T2, up ... |
|
| Topic: Query on Cursors |
|
| CRaviKota Replies: 6 Views: 3269 |
Forum: Application Programming Posted: Tue Jan 16, 2007 10:40 pm Subject: Query on Cursors |
| Hi,
Given a cursor C1 on table T1. For every row fetched from T1, open a cursor C2 on table T2. For every row fetched from T2, update column C1 in table T2 and issue a COMMIT. How ... |
|
| Topic: Cursor open |
|
| CRaviKota Replies: 3 Views: 2127 |
Forum: Database Posted: Tue Jan 16, 2007 10:35 pm Subject: Cursor open |
| Kolusu, you mentioned that above req is possible with Dynamic SQL. Does it mean that we use positional parameters in the place of the cursor name just like given below and we need to bind the cursor n ... | |
| Topic: Is Devolopment Center not available with DB2 viper |
|
| CRaviKota Replies: 2 Views: 1891 |
Forum: Database Posted: Tue Jan 16, 2007 9:50 pm Subject: Is Devolopment Center not available with DB2 viper |
| Hi Kolusu,
I verified my installations in my computer. I could find only , Control Center, Journal, License Center, Replication Center, Task Center with in General Adminstration Tools. I ... |
|
| Topic: Is Devolopment Center not available with DB2 viper |
|
| CRaviKota Replies: 2 Views: 1891 |
Forum: Database Posted: Tue Dec 26, 2006 9:42 pm Subject: Is Devolopment Center not available with DB2 viper |
| Hi,
I downloaded a trial version of DB2 9.0 Viper for Windows machine and Installed it. I could not find Devolopment Center, deployment center tools after Installations. Are these two, not av ... |
|
| Topic: How can the result set be used as input table |
|
| CRaviKota Replies: 5 Views: 3533 |
Forum: Database Posted: Tue Dec 26, 2006 9:05 pm Subject: How can the result set be used as input table |
| Hi Kolusu,
I guess, I got the culprit here. I used a Column function in an SQL SELECT with out using a GROUP BY clause. This might be the reason for my error. Actually I was trying to u ... |
|
| Topic: How can the result set be used as input table |
|
| CRaviKota Replies: 5 Views: 3533 |
Forum: Database Posted: Tue Dec 26, 2006 8:33 pm Subject: How can the result set be used as input table |
| Kolusu,
You are really genius. Thanks for your solution. Now actually I tried to solve this using Common Table Expressions.. but end up in an error. Can you tell me where I could have gone wr ... |
|
| Topic: How can the result set be used as input table |
|
| CRaviKota Replies: 5 Views: 3533 |
Forum: Database Posted: Mon Dec 25, 2006 10:07 pm Subject: How can the result set be used as input table |
| Hi Kolusu,
Thanks for your answer. Your reply would surely result in the required answer. Actually I'm thinking if there could be any way where we can use the result set of query "SELE ... |
|
| Topic: How can the result set be used as input table |
|
| CRaviKota Replies: 5 Views: 3533 |
Forum: Database Posted: Mon Dec 25, 2006 5:27 pm Subject: How can the result set be used as input table |
| Hi All,
Assume I have a table Dept_Stores in denormalized format : Dept_Stores: Dept_Name Money ========== ====== Marketing ... |
|
All times are GMT - 5 Hours |