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

Andy Nolen-Parkhouse

> -----Original Message-----
> From:
> On Behalf Of Paul Tykodi
> Sent: Monday, December 03, 2001 12:19 PM
> To:
> 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
> also experiencing a Client Access file transfer request problem as
well. I
> mentioned that some years ago I used to build Client Access file
> requests to test twinax emulation cards and that as a last resort type
> 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
> 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
> on
> their machine.
> I was wondering whether anyone knows if the Client Access SQL logic
> file
> transfer support can retrieve data from an RPG II formatted file that
> 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
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email:
> To subscribe, unsubscribe, or change list options,
> visit:
> or email:
> Before posting, please take a moment to review the archives
> at

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.