Announcement

Collapse
1 of 2 < >

IBMi Brunch and Learn Series by Programmers.io

Dear IBMi Community Member,

We are delighted to announce the launch of our new educational series, the "Brunch and Learn" sessions, here at Programmers.io. We are excited to provide you with an opportunity to participate in these upcoming sessions. To accommodate a wider audience, these sessions will be conducted at 11:30 am EST/8:30 am PST, allowing for greater flexibility.

To gain more insights about the sessions and secure your spot, we invite you to visit the following link:

https://programmers.io/ibm-i-brunch-learn/

We kindly request you to share this information with your friends and colleagues who are actively working in the IBMi world. Their participation will contribute to a more enriching and collaborative learning experience.



Thank you for your support.
Programmers.io Team
2 of 2 < >

IBMi Brunch and Learn Series by Programmers.io

Dear IBMi Community Member,

We are delighted to announce the launch of our new educational series, the "Brunch and Learn" sessions, here at Programmers.io. We are excited to provide you with an opportunity to participate in these upcoming sessions. To accommodate a wider audience, these sessions will be conducted at 11:30 am EST/8:30 am PST, allowing for greater flexibility.

To gain more insights about the sessions and secure your spot, we invite you to visit the following link:

https://programmers.io/ibm-i-brunch-learn/

We kindly request you to share this information with your friends and colleagues who are actively working in the IBMi world. Their participation will contribute to a more enriching and collaborative learning experience.



Thank you for your support.
Programmers.io Team
See more
See less

CCSID issue

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    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
    Tags: ccsid
  • #2
    Re: CCSID issue

    Have you tried to cast the replacement value into UNICODE?

    Code:
    Update ....
     set YourValue = Cast('NewValue' as VarGraphic(256) CCSID 13488)
....;
    BTW if you are already on Release 6.1 or higher a RUNSQL CL command was introduced via PTF (SF99701 Level 14 SF99601 Level 25 ), that allows you to directly execute almost all (Except SELECT) SQL commands from within CL.

    Birgitta
    Last edited by B.Hauser; December 20, 2012, 12:37 AM.

    Comment

    • #3
      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.

      Comment

      Previous template Next
      Working...
      X