FTP with UTF-8 - French characters having issues.

[Graham Scott]

I'll try the short description first and see how it goes.

Have a straight AS/400 database file. Record length of 1000, one field, just
text.
FTP it to Windows, works fine.
FTP it to an Oracle environment, and certain characters (specifically the E
with the accent) get incorrectly translated.

Apparently it's because the UNIX (Oracle) box needs it in UTF-8 format.

I took a quick look, and tried to create a PF with a CCSID of 1208 (My
default is 0037) but can't, not a source file.
I tried to FTP using 1208 with a CCSID, no go.
Tried copying to a folder, but couldn't find it (QDLS) on a FTP session.

I'm sure this isn't a new issue, can anyone point me in the right direction!

Thanks.

[Ken Sims]

Hi Graham -

On Wed, 8 Jun 2011 23:37:17 -0400, "Graham Scott"
<newsg...@fingerscrossed.org> wrote:

>I took a quick look, and tried to create a PF with a CCSID of 1208 (My
>default is 0037) but can't, not a source file.

I think you can do it by creating the file from DDS where you define
the character with the given CCSID. You can probably do it by
creating the file with SQL with CREATE TABLE where you specify the
CCSID as a field attribute, but I'm not familiar with that.

>Tried copying to a folder, but couldn't find it (QDLS) on a FTP session.

You need use to use namefmt 1 to switch to where you can specify IFS
paths. (You should double check on the namefmt parameter. I may have
it backwards.) Personally I wouldn't use QDLS unless there is a real
need to do so. That folder system has built-in limitations. I would
create my own folder off the root.

namefmt 1
put /QDLS/file somewhere

--
Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.

[Graham Scott]

Thanks for the prompt response Ken, I'll try this out this morning.

"Ken Sims" <ng3122@kensims.#nospam#.net.invalid> wrote in message
news:aum1v6h8echjt5hvr...@4ax.com...