Need a SORT job

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

Hi,

I need a SORT job for the below requirement.

I have two different types of records in a file.

formats of records as below.

record description of 1st type:

Object x(15) ex: "part "
ID x(6)
A 9(3)
B 9(3)
C 9(3)
Part-No 9(6)
FILLER x(20)

record description of 2nd type:
Object x(15) ex: "part name "

Part-No 9(6)
Part-Name x(20)

My required output should be as below:

Object x(15) ex: "part "

ID x(6)
A 9(3)
B 9(3)
C 9(3)
Part-No 9(6)
Part-Name x(20)
FILLER x(20)

The file can contain other types of record also..
Object field will decide the value in it. in my output the other types of records should be eliminated and only the "Part" objects must be present.

Thanks & Regards,
Hari

Frank Yaeger · Posted: Tue Mar 18, 2008 10:07 pm Post subject:

It's not clear what you want to do. What field or fields are you matching on?

Please show an example of your input records with actual values and what you expect for the output records. Explain the "rules" for getting from input to output based on the example. Give the RECFM and LRECL of the input file.

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

Hi Yeager,

There can be different types of records in a file.

ex:
Part type record:
Object A B C Part-No FILLER
--------------------------------------------------------------------
PART 100 022 012 123456

Part name type record:

Object Part-No Part-Name
-------------------------------------------------------
Part name 123456 SCREW

and my output should look like below

Object A B C Part-No Part-Name FILLER
--------------------------------------------------------------------
PART 100 022 012 123456 SCREW

so, the matching should be done on Part-no of "part" and "part-name" type records.

My output should only have the "Part" records and all other records(other records have some other value for the object field) must be eliminated.

Thanks,
Hari

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

I hope, this time it would be readable.

Object A B C Part-No FILLER
--------------------------------------------------------------------
PART 100 022 012 123456

Object Part-No Part-Name
-------------------------------------------------------
Part Name 123456 screw

Output is like this:

Object A B C Part-No PART-NAME FILLER
--------------------------------------------------------------------
PART 100 22 12 123456 screw

Frank Yaeger · Posted: Tue Mar 18, 2008 10:56 pm Post subject:

Again, what is the RECFM and LRECL of the input file?

Can you have more than one record with the same part no in either or both types of records? If so, what would you want to do about that?

Please show a more extensive example of input records and expected output records with all variations (match, no match, dups if possible).

You can use code tags to make it readable.

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

Hi,

Record format is fixed. and the LRECL is 800.

PART 100 012 011 123456
PART 100 230 410 111111
PART 099 210 102 222222
AAA 123 123 ABCDE
AAA 099 123 BDECF
BBB 029 AB DEF 123

Part Name 123456 Screw
Part Name 111111 Bolt
Part Name 222222 Mirror

PART 100 012 011 123456 screw
PART 100 230 410 111111 Bolt
PART 099 210 102 222222 Mirror

Part records can have duplicates, in that case part name will be the same for the duplicate part records.

Part name records will not have duplicates.

All the parts appearing in Part records will definitely have the Part name records.

Input file can also have AAA, BBB records. But they must not appear in the output file.

Thanks & Regards,
Hari.

Frank Yaeger · Posted: Tue Mar 18, 2008 11:34 pm Post subject:

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

No.

Sorry for the confusion.

PART 100 114 011 123456
PART 001 002 005 123456
PART 999 888 777 123456

In the above case, the output should be like this..

PART 100 114 011 123456 Screw
PART 001 002 005 123456 Screw
PART 999 888 777 123456 Screw

And Part name record will not appear in the output and only the part name from that records is refered to write in to the ouput file.

Frank Yaeger · Posted: Wed Mar 19, 2008 12:55 am Post subject:

Now I'm even more confused. You said you had two types of records in the input file, PART records and Part name records. I showed those two types in my input file example:

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

Thanks yeager.
I wanted this exactly.

Thanks,
Hari

Frank Yaeger · Posted: Wed Mar 19, 2008 2:30 am Post subject:

Good.

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

Hi Yeager,

The requirement is changed now and the files are VB.

Please give the sort JCL for the same requirement.

And also please explain the below statements if possible as I did not understand.

ON(31,6,ZD)
WITH(1,30)
BUILD=(31:16,6,37:22,20,801:C'0')

sclater · Posted: Wed Mar 19, 2008 6:17 pm Post subject:

Hi hariibm,

To quote Frank
"All of the DFSORT/ICETOOL documentation is available online from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. "

Frank Yaeger · Posted: Wed Mar 19, 2008 9:38 pm Post subject:

Here's a DFSORT/ICETOOL job for VB files:

hariibm · New User Joined: 05 Feb 2007 Posts: 44 Location: Chennai

Hi Frank,

I am confused with the lengths in my example given. Below is the actual requirement.
Please provide JCL for this requirement. The input records are as below.