Joined: 27 Oct 2009 Posts: 2445 Location: Netherlands, Amstelveen
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.
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.
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?