IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

WHERE CURRENT OF with two tables.
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
pecram24

New User


Joined: 12 Oct 2009
Posts: 35
Location: Chennai
PostPosted: Wed Jul 14, 2010 4:56 pm
 Reply with quote
Hi,

I am having a query regarding the WHERE CURRENT OF clause...

If i am declaring a cursor, in which i have two tables employee, Salary in the from clause... is that possible to Update/Delete a current row using the WHERE CURRENT OF CLAUSE..
can someone please clarify the above question.....


Thanks,
Ram
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
PostPosted: Wed Jul 14, 2010 5:10 pm
 Reply with quote
you can only have a read only cursor on joined tables.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Similar Topics
Topic Forum Replies
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts Changeman - how can we know the curr... Compuware & Other Tools 2
No new posts Fetch data from programs execute (dat... DB2 3
No new posts replace word 'MONTH' with current mon... SYNCSORT 11
No new posts create rexx edit Macro that edits the... CLIST & REXX 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us