|
midrange.com
This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Are you trying to merge these files, or join these files? For example, a
merge might mean combine data from 2002 with data from 2001, or data from
division 01 with data from division 02. While a join might say From the
customer order line file join to the customer order header, customer,
order type, tax table, etc.
If you are doing a merge then I might suggest
1) constructing a list of those files
2) processing this list from within RPG and then opening and closing the
file manually while using the proper keyword, (available in newer releases
of RPG but I can't look it up right now as they are reloading my primary
PC), to override to the current file.
Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin
----- Forwarded by Rob Berendt/DEKKO on 01/03/2003 08:39 AM -----
"N, Muralidhar" <Muralidhar.N@blr.hpsglobal.com>
01/03/2003 08:34 AM
To: "'rob@dekko.com'" <rob@dekko.com>
cc:
Fax to:
Subject: RE: Need a API.
Dear Rob
Iam looking at merging these 40 files and pulling out
selected fields from them.How do i do this?
Regards&Thanks,
Murali
> -----Original Message-----
> From: rob@dekko.com [SMTP:rob@dekko.com]
> Sent: Friday, January 03, 2003 6:44 PM
> To: rpg400-l@midrange.com
> Subject: RE: Need a API.
>
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> I guess a more "what result are you trying to achieve?" would be in
order.
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
>
>
> fields
> from them.
>
>
>
> "N, Muralidhar" <Muralidhar.N@blr.hpsglobal.com>
> Sent by: rpg400-l-admin@midrange.com
> 01/03/2003 12:25 AM
> Please respond to rpg400-l
>
>
> To: "'rpg400-l@midrange.com'" <rpg400-l@midrange.com>
> cc:
> Fax to:
> Subject: RE: Need a API.
>
>
> I need to process around 40 files (INPUT TO MY CL COMING FROM 40
> FILES)and
> create openqueries for each one..how can i do this in CL
> reply asap....
> MURALI
>
> > -----Original Message-----
> > From: Srinath R , Gurgaon [SMTP:srinathr@ggn.hcltech.com]
> > Sent: Thursday, January 02, 2003 6:17 PM
> > To: rpg400-l@midrange.com
> > Subject: RE: Need a API.
> >
> > Hi,
> >
> > I got some idea to display the output without using the subfile or
> > anything
> > like that.
> > So, thought of sharing with you all.
> > This is a crude approach, but it works.
> >
> > I wrote a CL program, that receives a parameter and that of-course is
> User
> > Id.
> >
> > The CL program has a DSPOBJD command, an Opnqryf command to select
only
> > the
> > records of the particular user and a CPYFRMQRYF command that just
stores
> > the
> > result of the OPNQRYF. Then a Runqry (Queryfile) Statement.
> >
> > QueryFile is a Work query where in I have selected the Fields that are
> to
> > be
> > displayed to the user.
> >
> > And to make life bit simple, have created a Command.
> >
> > It would be great, if there's an API for this.
> >
> > regards
> > Srinath
> > HCL Technologies Ltd.
> > 244, Udyog Vihar Phase-1
> > Gurgaon - 122016
> > Ph-124-6346405/406/407
> > Extn: 1108
> >
> >
> > -----Original Message-----
> > From: Venkateshwar V.
> [SMTP:venkateshwar.raman@wipro.com]
> > Sent: Thursday, January 02, 2003 12:57 PM
> > To: RPG400-L@midrange.com
> > Subject: Need a API.
> >
> > This is a multi-part message in MIME format.
> > --
> > --
> > [ Picked text/plain from multipart/alternative ]
> > Hi All,
> > I want to write a program that diplays the lits of
object
> created by
> > user in a particulat Library as Subfile. I can do this by writing a CL
> > that
> > captures the objects for a user by doing DSPOBJD in a file and then a
> RPG
> > program that reads this file and builds this subfile. Is there any API
> > that
> > will make my job easy i.e. get me a list of objects for a User in a
> > Library
> > ?
> >
> > Thanks and regards,
> > Venky.
> > --
> >
> >
> > --
> >
> >
>
**************************Disclaimer**************************************
> > **
> > **********
> >
> > Information contained in this E-MAIL being proprietary
> to Wipro
> > Limited is 'privileged'
> > and 'confidential' and intended for use only by the
> individual or
> > entity to which it is
> > addressed. You are notified that any use, copying or
> dissemination
> > of the information
> > contained in the E-MAIL in any manner whatsoever is
> strictly
> > prohibited.
> >
> >
> >
>
**************************************************************************
> > **
> > ************
> >
> >
> >
> > --
> >
> > _______________________________________________
> > This is the RPG programming on the AS400 / iSeries
> (RPG400-L)
> > mailing list
> > To post a message email: RPG400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit:
> http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> > or email: RPG400-L-request@midrange.com
> > Before posting, please take a moment to review the
> archives
> > at http://archive.midrange.com/rpg400-l.
> > _______________________________________________
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> > or email: RPG400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> WARNING: The information in this message is confidential and may be
> legally
> privileged. It is intended solely for the addressee. Access to this
> message
> by anyone else is unauthorised. If you are not the intended recipient,
> any
> disclosure, copying, or distribution of the message, or any action or
> omission taken by you in reliance on it, is prohibited and may be
> unlawful.
> Please immediately contact the sender if you have received this message
in
> error. Thank you.
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
WARNING: The information in this message is confidential and may be
legally
privileged. It is intended solely for the addressee. Access to this
message
by anyone else is unauthorised. If you are not the intended recipient,
any
disclosure, copying, or distribution of the message, or any action or
omission taken by you in reliance on it, is prohibited and may be
unlawful.
Please immediately contact the sender if you have received this message in
error. Thank you.
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.
