|
midrange.com
my problem is:
Iam having flat file DAACDTRN (input)
Iam having outfile DAACDTRNO(output)
Iam using FMTDTA INFILE(LIB/DAACDTRN)MBR(DAACDTRN)
OUTFILE(LIB/DAACDTRNO)MBR(DAACDTRNO)
SRCFILE(LIB/QFMTSRC) MBR(DASORT50).
Iam getting following error when iam executing this command on command
line.
0 error(s) found in source file QFMTSRC in library NFHPGMR mbr DASORT50,but
still iam nt getting data into outfile.
i went to file description of DAACDTRN and saw the following info***
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 39081
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 18190336
-----------------------------------------------------------
i went to file description of DAACDTRNO and swa the following info***
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 29997
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 14721024
so i came to conclusison that i need to change the length of the DAACDTRNO
for format data operation to be successful..how do i change ...please
provide me specific command and please explain how do i solve this so that i
get the requested records into my outfile without error
adv thanks®ards,
Murali
> -----Original Message-----
> From: rob@dekko.com [SMTP:rob@dekko.com]
> Sent: Friday, January 03, 2003 7:16 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 ]
> 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.
>
> _______________________________________________
> 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.
