Re: CCSID 37 / 500 issues with FTP

[Dan <dan27649@xxxxxxxxx>]

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.