how to execute stored procedure in mainframe

veena_nagesh2002 · Posted: Tue Aug 22, 2006 12:02 pm

hi,

anyone please update me immediately about stored procedures procedure.

I want to execute stored prodecures in Mainframes, which are already developed in DB2 UDB[universal Database]. There is no concern of COBOL, purely stored procedures.
please send me the details as early as possible.

regards

Nagesh

ofer71 · Posted: Tue Aug 22, 2006 12:19 pm

Have you considered reading the fina manual?

O.

Muthukumar.PLindia · New User Joined: 03 Jul 2006 Posts: 51 Location: Chennai

the manual is fine.. It states that a stored proc should have 1 or more sal statements and it needs some programming codes for logical processing. So cant we write stored procedures as we write in oracle, only using sql and plsql commands

If we are writing such type of pure sql statements compiled and executed by DB2 itself without ht eintervention of our os.. then how can we do it in mainframes,

Muthukumar.PLindia · New User Joined: 03 Jul 2006 Posts: 51 Location: Chennai

stly · New User Joined: 25 Jul 2005 Posts: 93

u can execute storedproc using DB2connect

surya_pathaus · Active User Joined: 28 Aug 2006 Posts: 110

Hi

If you want to test Stored Proc in Mainframe not using any DB2TOOLS like DB2 CONNECT said by stly, you have to modify the store proc little bit.

1) Remove all CBL statement which we add in storeproc.
2) add one output file and write the record which are inserting into temporary table. (dont remove any code related to temporary table just add one write statement before or after inserting into temporary table)
3) prepare one run jcl and execute the storeproc like cobol program.
4) you will get the output into a file which is inserted in temporay table.