CCSID in AS400

5 pts.
Tags:
AS/400
CCSID
SQL error messages
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: November 29, 2007  5:20 AM
UPDATED: October 29, 2009  12:37 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following