Re: CCSID issue
Thanks Birgitta.... Let me try using RUNSQL CL command. Current version is v5r3 bt the one for upgrade is on 6.1 so I can use it there.
Also I have not used UNICODE so far, will try that too.
I will post the result soon.
Announcement
Collapse
No announcement yet.
CCSID issue
Collapse
X
-
Re: CCSID issue
Have you tried to cast the replacement value into UNICODE?
Code:Update .... set YourValue = Cast('NewValue' as VarGraphic(256) CCSID 13488) ....;
BirgittaLast edited by B.Hauser; December 20, 2012, 12:37 AM.
Leave a comment:
-
CCSID issue
I need to execute SQL statement on file whose CCSID is 13488. I have tried changing the user profile CCSID to 13488 but giving error for the invalid value.
Can someone suggest if there is any other alternative. I need to update particular field value from say A to B for certain set of records.
Also this is to be done in the CL program using RUNSQLSTM.
BTW I just figured out that AS400 file is SQL Table
Leave a comment: