View previous topic :: View next topic
|
Author |
Message |
cijojosev
New User
Joined: 16 Dec 2005 Posts: 4 Location: Mumbai
|
|
|
|
Hi friends,
i am new here.i want to know how to call a stored procedure in a cobol program.
the requirement is that i need to insert some data into a Midrange Database(Distributed side) from mainframe.the data in tha mainframe part is in tha form of flat file.the stored procedure will be created by the Distributed side midrange DBA.we will have to call the stored procedure using a cobol program and insert the data into the Midrange Database.
we havint used the stored procedures yet
so can anyone help out on how to deal with it on the cobol part |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
Friend cijojosev,
I think you will have better luck getting an acturate answer to your quesry in the DB2 forum. I would repost this there.
I'll look for the query the the DB2 forum and try to give you some basics on DB2 Stored procedures.
A DB2 Stored Preocedure is nothing more than a subroutine with a few additional considerations. NBD |
|
Back to top |
|
|
k_vikram07
New User
Joined: 23 Nov 2005 Posts: 35
|
|
|
|
Hi Cijo,
You can use the sql statements to run it
YOu need to know the parameters to be passed to the stored proc.
EXEC SQL
CALL stoproc(:inparm1,:inparm2,:outparm1,:outparm2)
END-SQL.
Do the normal sql checks as usual.
The first thing we need to know is, what are the parameters it needs, and what are the things it return. |
|
Back to top |
|
|
cijojosev
New User
Joined: 16 Dec 2005 Posts: 4 Location: Mumbai
|
|
|
|
hi,
thanks k_vikram07 & DavidatK,i am looking for a little more detailed data on that . as DavidatK said i have posted it on DB2 also.however i am trying with what i have recived. |
|
Back to top |
|
|
|