RE: S36EE Client Access File Transfer Question

["Andy Nolen-Parkhouse" <aparkhouse@xxxxxxxxxxxx>]

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.