Hello!


I'm developing an application with AS/400. When i call a stored procedure with appropriate input parameters, for every output parameter value i get an array of small cubes instead of data.
Data is taken from user table and it would be username, password, e-mail, status..., but there are only senseless cubes
Output parameter values (cubes) are logged right after the procedure call.

I appreciate any hint!


Regards

I suspect this might be a code page conversion problem, but, judging by the way you've formulated the question, I'm afraid this answer won't make much sense to you. Unfortunately, you did not provide enough detail to allow for a better answer.

What is the DB2 version? What interface do you use to call the procedure? What are the parameter data types?

Thanks a lot for Your answer n_i!


I'm developing the application with Java/iBatis/AS400.

When i call a stored procedure with appropriate (String, CHAR(10)) IN parameters, for every OUT parameter value i get an array of small cubes instead of data (String).


I did some researches around the web in the meantime, and i get idea to tweak some of the parameters described on:
http://publib.boulder.ibm.com/infoce...properties.htm
Still no success...

Am i digging in the right direction?
Any more useful hints?


Regards

P.S.
Let me know if any more details are necessary for appropriate diagnose