• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Cursor in DB2

 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Anyone know or used to implement cursor in DB2. For update for each row in table, i think
i need cursor to implement this. I've asked uncle Google for this, but he has no answer..
Could you guys show me how to use cursor in DB2 or comment on any knowledge about this.

Thanks

Ramses
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ramses,
Are you thinking of an updateable resultset maybe?
 
Ramses Butarbutar
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Jeanne Boyarsky wrote:Ramses,
Are you thinking of an updateable resultset maybe?



Hi Jeanne,
Hmm.. i'm not sure.. let me describe what i got here..
There are 3 tables.. part master, part detail, stock. One item subject in part master contain
several item parts.. So when parts came in to warehouse, it should insert part detail based on each subject in part master table.. After that it should automatically update stock table..
e.g. subject A has 10 item ( B - K ).. And i should check each row , write to part detail and based on
each row , update data in stock.. We have more and less 200 subject and each subject contain more and less 30 item parts.. And all transaction daily..
I hope you can get what i mean...
Any suggestion on that jeanne??
 
reply
    Bookmark Topic Watch Topic
  • New Topic