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
 

 

Number of DBRM's formed..

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

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Apr 21, 2010 1:13 pm    Post subject: Number of DBRM's formed..
Reply with quote

Hi..
This was the question asked to me..

If we have prog A and Prog B in such a way that prog A calls Prog B..
how many DBRM's will be formed after precompilation.??

Prog A does not contain any sql statements..all the sql's are present in Prog B.
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Apr 21, 2010 1:17 pm    Post subject:
Reply with quote

DBRM: DataBase Request Module, has the SQL statements extracted from the host language program by the pre-compiler.
PLAN: A result of the BIND process. It has the executable code for the SQL statements in the DBRM.
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Apr 21, 2010 1:22 pm    Post subject:
Reply with quote

Hi PeterHolland
u mean to say ...only one DBRM will be formed after precompilation..?
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Wed Apr 21, 2010 1:29 pm    Post subject:
Reply with quote

That is what i assume. But im not a DB2 programmer.
Back to top
View user's profile Send private message
Pravesh

New User


Joined: 30 Jul 2009
Posts: 32
Location: Gurgaon

PostPosted: Wed Apr 21, 2010 2:04 pm    Post subject: Reply to: Number of DBRM's formed..
Reply with quote

whenever we have multiple Db2 cobol porgarms, we plan to have one just cobol pgm(sayA) which calls remaining db2 cobol pgms(say B,C). We will have B and C packages(after binding DBRMs) and one plan with name A.


Regards,
Pravesh
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Apr 21, 2010 2:53 pm    Post subject:
Reply with quote

Hi Parvesh ..
thx for ur reply..
as far as i understand DBRM is the extracted sql statements by the precompiler ...but if we dont have any sql statement in the calling program..then will the precompiler make a DBRM for the same?

Please correct me if wrong..
Back to top
View user's profile Send private message
Pravesh

New User


Joined: 30 Jul 2009
Posts: 32
Location: Gurgaon

PostPosted: Wed Apr 21, 2010 3:01 pm    Post subject: Reply to: Number of DBRM's formed..
Reply with quote

no if we do not have any SQL statement in our program, there will not be any DBRM created


Regards,
Pravesh
Back to top
View user's profile Send private message
LearningDb2

New User


Joined: 19 Jun 2009
Posts: 40
Location: India

PostPosted: Wed Apr 21, 2010 5:06 pm    Post subject:
Reply with quote

ok.thx Parvesh..

icon_cool.gif
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 Sequence number add in SORT pshongal SYNCSORT 3 Fri Sep 02, 2016 3:32 pm
No new posts Casting a Binary Number to Numeric in... Bob Steinkraus Java & MQSeries 6 Tue Aug 09, 2016 5:58 pm
No new posts GDG vsersion number change Raghu navaikulam JCL & VSAM 5 Fri May 27, 2016 4:49 pm
No new posts CPU time Vs Number of records Nileshkul JCL & VSAM 5 Mon May 09, 2016 4:05 pm
No new posts Syntax to check the first 4 digits of... kshirabdhi DFSORT/ICETOOL 10 Tue May 03, 2016 12:21 pm


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