Re: S36EE Client Access File Transfer Question -- MIDRANGE-L

And if it is one flat field, any embedded packed or binary fields are going
to be translated from EBCDIC to ASCII in a very unhelpful manner...

Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: "Andy Nolen-Parkhouse" <aparkhouse@mediaone.net>
To: <midrange-l@midrange.com>
Sent: Monday, December 03, 2001 9:52 AM
Subject: RE: S36EE Client Access File Transfer Question


> Paul,
>
> As far as Client Access is concerned, the S36 Environment data file is
> just another AS/400 physical file.  If the file is only used in RPG II
> programs, there is a chance that the file does not have fields defined.
> Since RPG II programs maintain their field definitions internally, the
> database may look like one flat field, which can contain packed, zone,
> and character data.  If the file is keyed, only those fields necessary
> to define the key are required.
>
> Thus you should be able to process the file, but you may need to parse
> the fields yourself.  Alternatively, the data can be copied into a
> completely defined physical file and the RPG II programs should still
> function as before and you would have the benefits of a defined
> database.
>
> Regards,
> Andy Nolen-Parkhouse
>
>
> > -----Original Message-----
> > From: midrange-l-admin@midrange.com
> [mailto:midrange-l-admin@midrange.com]
> > On Behalf Of Paul Tykodi
> > Sent: Monday, December 03, 2001 12:19 PM
> > To: midrange-l@midrange.com
> > Subject: S36EE Client Access File Transfer Question
> >
> > Dear List,
> >
> > I was recently speaking with an AS/400 (V4R2) end user about a remote
> > printing problem and they mentioned during the conversation that they
> were
> > also experiencing a Client Access file transfer request problem as
> well. I
> > mentioned that some years ago I used to build Client Access file
> transfer
> > requests to test twinax emulation cards and that as a last resort type
> of
> > problem resolving option I would be willing to at least look at their
> > problem.
> >
> > The end user has decided to accept my offer and has let me know the
> target
> > file on the AS/400 that holds the data they need is a database file
> for a
> > custom RPG II application they wrote in-house that runs within the
> S36EE
> > on
> > their machine.
> >
> > I was wondering whether anyone knows if the Client Access SQL logic
> for
> > file
> > transfer support can retrieve data from an RPG II formatted file that
> is
> > stored in the S36EE? If yes, are there any special customization steps
> > required in the creation of the file transfer request?
> >
> > Thanks.
> >
> > Best Regards,
> >
> > /Paul
> > --
> > Paul Tykodi
> > Director, Printer Connectivity Product Management
> > LCI-Intermate US, Inc.
> >
> > p: 603.431.0606 x115
> > f: 603.436.6432
> > paul@intermate-us.com
> > www.intermate.com
> >
> > _______________________________________________
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> > or email: MIDRANGE-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com