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 Update/Insert stored procedure using JCC driver

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

New User


Joined: 31 Mar 2011
Posts: 3
Location: India

PostPosted: Thu Mar 31, 2011 1:11 pm    Post subject: Problem with Update/Insert stored procedure using JCC driver
Reply with quote

Hi ,

My application is a Java front End & Mainframe back end application.

We were using a type 2 driver with Db2 client version 8 to invoke the SP on mainframe.

We are now upgrading the db2 Client version to 9.5 with type 4 jcc universal driver.

All the stored procedures which are used to select data are working fine , but the SP having update/insert are giving issue.

The main issue is the SP invokes properly but after execution it fails before the control is passed back to java side.

I am not sure whether the new JCC driver handles some parameter differently from type 2 driver.

Can anyone help me out for the possible reason/solution.

Thanks ...
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Thu Mar 31, 2011 1:21 pm    Post subject: Reply to: Problem with Update/Insert stored procedure using
Reply with quote

Quote:
The main issue is the SP invokes properly but after execution it fails before the control is passed back to java side.
Quote:
Can anyone help me out for the possible reason/solution.


check line/statement 34821 of Your SP or line/statement 26479 of the invoking program!
Back to top
View user's profile Send private message
Ankukr Solanki

New User


Joined: 31 Mar 2011
Posts: 3
Location: India

PostPosted: Thu Mar 31, 2011 2:00 pm    Post subject:
Reply with quote

Thanks Enrico for the response..

I Couldn't trace the Line no. in my PGM, My SP is a plain cobol program.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Thu Mar 31, 2011 2:14 pm    Post subject: Reply to: Problem with Update/Insert stored procedure using
Reply with quote

Ankur, You seem to lack a bit of sense of humor icon_biggrin.gif

my suggestion was a nonsense reply to a nonsense question

You described You problem as ...
I had something working
I changed something
now it does not work any longer
help me to yak yak yak ( equivalent to blah blah blah )

You will find very little help and sympathy if You ask questions in that way
to get help You must provide facts, You just whined/vented Your disappointment

to make the most out of the questions You ask it might be helful to read and meditate on
How To Ask Questions The Smart Way
http://catb.org/~esr/faqs/smart-questions.html
Back to top
View user's profile Send private message
Ankukr Solanki

New User


Joined: 31 Mar 2011
Posts: 3
Location: India

PostPosted: Thu Mar 31, 2011 7:09 pm    Post subject:
Reply with quote

All ,

The Issue was happening because the new JCC type 4 driver does not allow the type mismatch which was allowed in the previous versions.

Thanks...
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 IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 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


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