Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

conversion tables on FTP

226 views
Skip to first unread message

tom

unread,
Jan 12, 2010, 6:32:36 AM1/12/10
to
Hi.

We're trying to ftp file from Windows/linux server on
iseries (v5r4m0).
File on iseries site is coded in CCSID 870, on windows/linux
latin2/utf/1250 (can be any kind).

Problem is that after ftp on iSeries I can't see some characters (polish
chars). I know about conversion tables used with ODBC connections but
what about FTP connection?

Regards,
Tomasz

iseriesflorida

unread,
Jan 12, 2010, 7:51:55 AM1/12/10
to

You might need to change the job ccsid that is doing the FTP or maybe
you could change the file ccsid before sending it.

awr357

unread,
Jan 12, 2010, 8:36:27 AM1/12/10
to

The chars should be there if you did a "bin" before ftp-ing. ( "ascii"
is set as transfer mode by default in ftp i think... not sure )

Change ccsid of file see what you get !?

Peter H. Coffin

unread,
Jan 12, 2010, 8:53:35 AM1/12/10
to
On Tue, 12 Jan 2010 12:32:36 +0100, tom wrote:
> Hi.
>
> We're trying to ftp file from Windows/linux server on
> iseries (v5r4m0).
> File on iseries site is coded in CCSID 870, on windows/linux
> latin2/utf/1250 (can be any kind).

That's kind of the problem. The same file can OFTEN be any kind. It
isn't like the iSeries where files (or parts of files) get tagged with
what character set the data is in.

> Problem is that after ftp on iSeries I can't see some characters (polish
> chars). I know about conversion tables used with ODBC connections but
> what about FTP connection?

If you specify it, it'll use the CCSID that you specify for the
conversion, but you need pick which one.

E.G:

FTP RMTSYS('otherhost.example.com') CCSID(852)

However, your remote applications and whatever's beyond the ftp won't
necessarily know that the file is in 852 unless you tell it so.

--
For every subject you can think of there are at least 3 web sites.
The owners of these web sites know each other and at least one of
them hates at least one of the others.
-- mnlooney's view of Skif's Internet Theorem

CRPence

unread,
Jan 12, 2010, 4:04:34 PM1/12/10
to

What one can "see", i.e. the glyphs, may not reflect what the
actual data is. What is seen in glyphs depends too much on the
setup for code page, character set, and font. Review instead, the
actual hex code points of the data; ignoring the glyphs, verify that
the correct code point is seen for the data of the assigned CCSID.
For a database member use CPYF OUTPUT(*PRINT) OUTFMT(*HEX) or use
the Display Hex [optionally over\under] of the DSPPFM feature. For
a stream file, use the DMP command.

Regards, Chuck

0 new messages