Re: Intl address progress

Javier: My from and to variables are both defined in tables using CCSID
1208. Do I need to create another intermittent variable?

If it helps describe what I'm trying to do we receive JSON and write the
data to IBM i tables. Then we need to create a CSV for international labels
to import in Fedex shipping program.

Art

On Thu, Aug 1, 2024 at 10:47 AM Javier Sanchez <
javiersanchezbarquero@xxxxxxxxx> wrote:

If your program is an embedded sql rpg:

Declare a variable like this:

dcl-s myUTF8Var char(50) ccsid(1208) inz; // ccsid(*utf8) works too.

The char(50) is only illustrative, give the same length as your table's
1208 column.

Then in your program, assign whatever to myUTF8Var, even literal strings.
The compiler generates under the hood a call to a conversion routine that
would translate what you are loading it with as UTF-8 and then use this
variable to insert or update your field. Personally I'd expect that not
doing this, the conversion should take place, but if not, better do this.

Try again and let us know.

El jue, 1 ago 2024 a las 8:34, Art Tostaine, Jr. (<atostaine@xxxxxxxxx>)
escribió:

I created a CSV of FILEA with iACS SQL and it looks right. My program

takes

FILEA, Adds some data and creates FILEB. FILEB didn't download right. So
something is happening when my program runs. I tried CHGJOB CCSID(*HEX)
before I Ran it but that didn't work.

Art

On Thu, Aug 1, 2024 at 10:10 AM Javier Sanchez <
javiersanchezbarquero@xxxxxxxxx> wrote:

Try this one first: with iACS, download the file to your PC and then
inspect it with Notepad++ and see if the character shows correctly.

El jue, 1 ago 2024 a las 7:40, Art Tostaine, Jr. (<atostaine@xxxxxxxxx

)

escribió:

Thanks for the reply. It's 1208. This is how it looks:
Zhang ( )

On Thu, Aug 1, 2024 at 9:29 AM Javier Sanchez <
javiersanchezbarquero@xxxxxxxxx> wrote:

With option 8 using WRKLNK, check the CCSID that the stream file

was

created with when imported with CPYTOIMPF and tell us back.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.