Unanswered: Incorrect sqlcode returns from spb V7.0
I am new to the forum but have found answers here before but this one I cann't find the answer to without asking.
UDB V7.0 on win2k machine
local and remote admin access.
My problem...(ok...just my DB2 problem...insert your smile <here>)
When using the IBM SPB to create dynamic(JDBC) stored procedures I get sqlcode = +0 on selects and updates when it should return a +100.
An insert will gen a -803 on unique key violation.
In 'CLP' or "command Center' selects or updates kick out as expected. I have not modified or updated any Java related sys files on the host machine.
The question...do I have a config problem or is something else going on?
Appreciate any help you can offer.