|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com 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.