Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Problem with a stored procedure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Lkmi

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Thu Jun 22, 2006 5:19 am    Post subject: Problem with a stored procedure
Reply with quote

I need to write a simple stored procedure in db2 which has a simple select.

so all i did was to declare a cursor with return option and i open the cursor after populatinhg the where clause with the input parameters send to the stored proc.

the stored proc is defined in the sysibm.sysprocedures.

when i call the stored proc through the java program, i get a sql code of -430. iam not able to find why it aBENDS,

what are the system tables in which definitions for the stored proc should be present apart from sysibm.sysprocedures?????
Back to top
View user's profile Send private message

anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Sat Jun 24, 2006 1:47 am    Post subject:
Reply with quote

Firstly,he stored procedure definition would be stored in SYSIBM.SYSROUTINES and not in SYSIBM.SYSROUTINES, not sure if such a table called SYSIBM.SYSROUTINES exists. The In and out parameter definitions are stored in SYSIBM.SYSPARMS table.


If you are writing an external stored procedure with embedded SQL statments you need to crteate a package and mention the COLLECTION ID in the definition. If you are creating SQL PROCEDURE, then need not create a package.

Have you handled for SQL code +100 in your procedure?

have you opened and closed the cursors?

have you done the iterations for fetching until sqlcode 100?

can you publish the definition of your Stored procedure.(The create procedure statement).

Anamika
Back to top
View user's profile Send private message
Lkmi

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Sat Jun 24, 2006 9:23 pm    Post subject:
Reply with quote

thanks for the response
i fouind what the problem was. the environment was not properly set up.
i fixed that. and one more mistake was i had the input fields as 10 level under a 01 level..which is wrong.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us