Re: CCSID 37 / 500 issues with FTP

Well, so, o.k., per my previous post, I tried putting the SQL cast in the
application, but, unlike the test I did in the interactive SQL session, it
didn't work in the embedded RPG. ??????

Before I saw this response, I made the change in my application to create
the file (CRTPF) before the FTP to GET the file. For reasons unknown to me,
this didn't work last night, but it works tonight. (I was probably on hour
14 by the time I gave up last night, and that might explain a lot of the
mystery.) Anyway, the data is now getting transferred (it wouldn't last
night), and the translation is good! Problem solved.

I will keep the "LOCSITE CRTCCSID *SYSVAL" tip handy if for future
reference.

Scott, again, many thanks for all the help! Mike, thank you as well!

- Dan

On Fri, Feb 19, 2010 at 8:15 PM, Scott Klement
<midrange-l@xxxxxxxxxxxxxxxx>wrote:

Correct. This document is referring to a Windows FTP user doing a PUT
to OS/400. Therefore, the CHGFTPA command won't help you. (The CHGFTPA
only affects the IBM FTP server, and you're not using that.)

However, the CRTCCSID suggestion will work -- provided you use LOCSITE
instead of 'QUOTE SITE'. The 'QUOTE SITE' is sending a SITE command to
the Windows FTP server, which can only serve to confuse it.

However, LOCSITE controls your FTP client. So you could do:

LOCSITE CRTCCSID *SYSVAL

In your FTP session (or script) and that should work (knock on wood)


On 2/19/2010 6:19 PM, Dan wrote:

Additional searching turned up this document:

http://www-912.ibm.com/s_dir/slkbase.NSF/0/b919ff1b461a3b7386256fcc0080d66a?OpenDocument

- or -
*http://tinyurl.com/ftpccsiddoc*

Option 1 ?possible?, as we discussed before.
Option 2 isn't feasible (CHGFTPA)

Tried option 3 with the *QUOTE SITE CRTCCSID *SYSVAL*, but got:

QUOTE SITE CRTCCSID *SYSVAL

500 'SITE CRTCCSID *SYSVAL': command not understood

This might be the result of the document describing a Windows user trying

to

do a PUT to the iSeries, which is the "opposite" way I'm going.

Not sure if this confuses the issue, but maybe someone has insight on

this.

- Dan

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