Original record number in a original file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Original record number in a original file

Postby Ganymedes » Thu Nov 03, 2011 4:28 pm

I have a file with data which need to select one or more records according to specific criteria (filters). Please, see below:

original file -

number of records - data
000001 jose silva dept purchasing manager position
000002 john coast dept maintenance supervisor position
.
.
.
.
003000 Paulo Santos purchasing dept coordinator position

I'm selecting records dept purchases. This is usually quite simple, but I need to maintain or generate a separate report indicating the number of the original record in the input file.
as below:
000001 jose silva dept purchasing manager position
003000 Paulo Santos purchasing dept coordinator position
and not so:
000001 jose silva dept purchasing manager position
000002 Paulo Santos purchasing dept coordinator position
Ganymedes
 
Posts: 1
Joined: Thu Nov 03, 2011 4:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Original record number in a original file

 

Re: Original record number in a original file

Postby Frank Yaeger » Thu Nov 03, 2011 10:53 pm

Your description is quite confusing.

Are the record numbers you show actually in the input file or do you want to add them? If they are in the input file, then why wouldn't they just appear as you want them in the output file? If they are not in the input file, then you can just use INREC to add the input numbers and OUTFIL INCLUDE to select the records you want which will have the original input numbers.

If you need more help on this, you need to do a better job of explaining what you want to do.

Show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. Give your exact criteria (or INCLUDE statement) for including the records you want.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post