Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Some doubts

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
rtalapaneni

New User


Joined: 20 Mar 2005
Posts: 13
Location: Bangalore

PostPosted: Mon May 16, 2005 5:58 pm    Post subject: Some doubts
Reply with quote

1) I am calling subprogram with three parameters. But in subprogram i am recieving two parameters. It will give any error?

2) If i alter a table with new column. Do i need to rebind the program?
(if i am not using the new column in the program)

3) What is Twophase Commit?
Back to top
View user's profile Send private message

subhasis_50

Moderator


Joined: 09 Mar 2005
Posts: 363
Location: Earth

PostPosted: Tue May 17, 2005 11:55 am    Post subject: Re: Some doubts
Reply with quote

HI,
1.You will not get any error.
2. As u r not using the column it is not required to bind the DBRM. As there are no changes in your SQL statement in the programs.
Thanks
Subhasis
Back to top
View user's profile Send private message
arunoday

New User


Joined: 17 May 2005
Posts: 18
Location: Bangalore

PostPosted: Wed May 18, 2005 3:11 pm    Post subject: Re: Some doubts
Reply with quote

Hi

I am answering the third question.
rtalapaneni wrote:
3) What is Twophase Commit?


Two phase commit takes place when the transaction spread across more than one transaction manager.
The primary transaction manager who wants to do the COMMIT inquires to other transaction managers about their status ,i.e - whether ready to COMMIT or not. This is "Preparation phase" (First phase). If any of the other tarnsaction manager replies about its inability , the primary transaction manager issues a ROLLBACK command.

In the next step, when all the transaction managers are ready to COMMIT, the primary transaction manager issues the actual COMMIT statement. This is called "Commit PHase" (Second Phase).
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Doubts in MQ data Converstions Thamilselvi Java & MQSeries 3 Mon Jul 02, 2012 3:48 pm
No new posts Doubts related to insertion of table ... Vidya Kajale COBOL Programming 1 Tue Apr 24, 2012 11:54 am
No new posts Doubts regarding Merging Rahul_kumar JCL & VSAM 5 Wed Apr 27, 2011 4:41 pm
No new posts Doubts in LA BhavaniV PL/I & Assembler 4 Wed Oct 06, 2010 6:45 pm
No new posts Need to Clarify some Doubts in Stream... Vigneshwaran S All Other Mainframe Topics 8 Mon Apr 12, 2010 12:34 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us