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
 

 

Unicode to EBCDIC conversion issues

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
ashutosh.pr

New User


Joined: 13 Apr 2007
Posts: 36
Location: Pune

PostPosted: Wed Apr 01, 2009 12:22 pm    Post subject: Unicode to EBCDIC conversion issues
Reply with quote

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
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Wed Apr 01, 2009 12:47 pm    Post subject: Reply to: Unicode to EBCDIC conversion issues
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm
No new posts Conversion of a VB file to FB. isssal DFSORT/ICETOOL 1 Mon Oct 31, 2016 10:23 pm
No new posts EBCDIC to ASCII conversion using OCOPY mistah kurtz All Other Mainframe Topics 5 Tue Sep 06, 2016 2:26 pm
No new posts Converting EBCDIC to Unicode (TimeStamp) muralikrishnan_new COBOL Programming 2 Mon Jul 25, 2016 10:42 pm


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