Hello all,

Just for those who contibuted to this issue ...

At the end of the day it was quite simple actually ...

1. Before the data was outputted I changend the CCSID of the Jop to CCSID(870)

-- Exec Sql CALL QSYS2.QCMDEXC('CHGJOB CCSID(870)');

2. Create outfile as UTF8

exec sql
CALL QSYS2.IFS_WRITE(
PATH_NAME => trim(:Path),
LINE => '',
END_OF_LINE => 'NONE',
FILE_CCSID => 1208,
OVERWRITE => 'REPLACE')
;

3. Wite to Output

exec sql
CALL QSYS2.IFS_WRITE(
PATH_NAME => trim(:Path),
LINE => trim(:data),
OVERWRITE => 'APPEND',
END_OF_LINE => 'CRLF');


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.