Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 2441
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: 2441
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 Profile changed to NUMBER ON STD (fro... Martylin TSO/ISPF 1 Thu Aug 03, 2017 9:14 am
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts how to mask the phone number kumarinfy DB2 4 Mon Apr 03, 2017 5:23 pm
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us