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

Diff between package and plan and when we use package


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
knprao
Currently Banned

New User


Joined: 02 Mar 2005
Posts: 2
Location: chennai

PostPosted: Tue Mar 20, 2007 8:02 pm
Reply with quote

1.How to fetch 500th row directly from 1000 rows in db2
2.diff between update and commit
3.diff between package and plan and when we use package and plan
4. what are the sql warnings u faced
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Thu Mar 22, 2007 3:38 am
Reply with quote

Quote:
2.diff between update and commit
You got me, one is the function of changing the values of data and the other is having those changes "stick".
Quote:
3.diff between package and plan and when we use package and plan
That one was fairly easy, along with the links below there is this one.
Quote:
4. what are the sql warnings u faced
What, you want "war stories"? icon_rolleyes.gif
And first but not least,
Quote:
1.How to fetch 500th row directly from 1000 rows in db2
This has been answered before, I'm not (any more) much of a DB2 person, but the nth occurrence of a cursor has been dealt with here. Try searching for your own answer.
search for difference, update, commit
search for difference, update, commit
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 -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Rebind issue - Package DB2 2
No new posts current batch plan DB2 3
No new posts Sort on different fields, removing du... SYNCSORT 8
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts Usage/Utiliy of Plan in DB2 DB2 4
Search our Forums:

Back to Top