RE: Creating UTF-16 LE Unicode files for BI system

Sounds like they just want line feed... That IS supported in the CPYTOIMPF command. Normally, the PC world uses CRLF to mark end of line... Unix prefers LF only, I think...

-Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of sjl
Sent: Tuesday, June 26, 2012 5:19 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Creating UTF-16 LE Unicode files for BI system

...and I neglected to mention that BI also wants them as stream files
WITHOUT carriage returns, which CPYTOIMPF apparently cannot handle.
- sjl


"sjl" wrote in message
news:mailman.6180.1340748988.2513.midrange-l@xxxxxxxxxxxx...

We have a home-grown ETL process on our iSeries (V5R4) which builds various
extract files from our inventory and sales systems.

If I create iSeries database file MYFILE using CCSID(13488) and then

CPYTOIMPF FROMFILE(MYFILE) TOSTMF('MYFOLDER/MYFILE.TXT') RCDDLM(*CR)
DTAFMT(*FIXED)

This appears to create a stream file which is encoded as UTF-16 BE with no
BOM.

However, the BI folks have indicated that they want us to send them the data
encoded as UTF-16 LE with no BOM, and I am not quite sure how to accomplish
this...

- sjl