does a stored procedure use a Plan

red_roses · New User Joined: 31 Oct 2005 Posts: 27

I am writing a stored procedure in cobol for accessing data that is on DB2, now i need to compile it. and since it a cobol pgm i assume the compile steps will be similar too.

so in this case for the bind step, do we need to create a plan for this stored procedure??

has anyone used cobol SP? so as to explain to me the steps involved in compiling n setting this up.?

valeti_sashi · New User Joined: 23 Jun 2006 Posts: 7

stored procedure can not be executed by itself. it needs a program to call it. so there is no need of Plan for a SP. and the steps of compilation are exactly similar as normal cobol db2 program, only diff is u do creatd a plan for SP

kgumraj · Posted: Wed Sep 13, 2006 8:29 pm

Use the following query in the cobol program

EXEC SQL
CALL <strred procedutre>
( :<arguments1,
:<arguments2,
:<arguments3)
END-EXEC.

There is a need for binding since DBRM is created.