IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

For The Update of in Declare Cursor with Order By.....

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
pkmurali



Joined: 15 Dec 2005
Posts: 58

Posted: Fri Jul 04, 2008 3:41 pm    Post subject: For The Update of in Declare Cursor with Order By.....  

Dear all,

Like to have a discussion with Declare cursor. I am declaring a cursor for an table with order by clause and using For update of columns of the table.

How the cursor will be declared? Order by clause sorts the columns by condition if so whether it is possible to declare with these combinations? if not why?

Regards,
Murali.
Back to top  
dbzTHEdinosauer



Joined: 20 Oct 2006
Posts: 1639
Location: germany

Posted: Fri Jul 04, 2008 8:17 pm    Post subject:  

that is what the documentation says. use links at the top of the page to access any db2 programmers guide.
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM