CCSID in AS400
Home > IT Answers > AS/400 > CCSID in AS400
Karthick083
5 pts.
0
Q:
CCSID in AS400
AS/400, SQL error messages, CCSID
Hi,

i am trying to update a DBCS data defined through ODW BPCS version 6 to DB400 and i run into error SQL-332.I do not whether the problem is with the host variable.I find all the definition of variable being handled properly.


Thanks,
karthick
ASKED: Nov 29 2007  5:20 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Karthick083
5 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Nov 29 2007  5:20 AM GMT by Karthick083   5 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

TomLiotta   8025 pts.  |   Oct 29 2009  12:37AM GMT

What is “SQL-332″? Is that SQLCODE -332? That would be reasonable since SQLCODE -332 comes out as “Character conversion between CCSID &1 and CCSID &2 not valid.” in the system QSQLMSG message file at message identifier SQL0332.

A little information would be helpful. What is your OS version/release? What is your system’s QCCSID value? What CCSID does the failing job run under? What CCSID is the DBCS data data defined as?

Most commonly, this kind of problem comes up in systems that are configured with QCCSID 65535. That is an incorrect setting unless you have explicit reason for telling your system not to do character conversions. But you apparently do want character conversions done if you’re seeing SQLCODE -332.

Tom

 
0