View previous topic :: View next topic
|
Author |
Message |
ashutosh.pr
New User
Joined: 13 Apr 2007 Posts: 36 Location: Pune
|
|
|
|
Hi!
We are working on a Stored Proc which accepts data in Unicode format and using those values queries/updates in both EBCDIC and UNICODED tables.
The problem is that when we are trying to use the Unicoded input values to query the Unicoded tables we are getting the error like this:
SQLCODE = -302, ERROR: THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER 2 IS INVALID OR TOO LARGE FOR THE
TARGET COLUMN OR THE TARGET VALUE
This is when we compile the SP with the following options:
COMPILE PROCEDURE ===> CMNCOB3I
COMPILE PARMS ===> VBREF
LINK EDIT PARMS ===> RENT
Based on some inputs that we got from others we changed the parameters to :
COMPILE PROCEDURE ===> CMNCOB3
COMPILE PARMS ===> VBREF
LINK EDIT PARMS ===> RENT
After this we started getting the error that a cursor has not been declared.
(though it is declared)
Can someone throw some light on this?
Thanks !!!
Ashutosh |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
do not post screen images
it is a waste of resources, a plain text cut and paste is more than enough
ask Your support ( they customized CHANGEMAN)
they should be able to tell the proper parameter for different situations |
|
Back to top |
|
|
|