Joined: 07 May 2005 Posts: 110 Location: hyderabad
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.
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,
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.