combining 2 files into one file and excluding some columns

sant532 · New User Joined: 02 Jun 2008 Posts: 48 Location: India

Hi all,
i'm having 2 files...
File1 lrecl is 12 and is having following records...

1111sant1234
1112raju1345
1113john1655
1114mahi5454

and file 2 lrecl is 6 and is having following records

222222
333333
444444
555555

now i want output like below

1111sant222222
1112raju333333
1113john444444
1114mahi555555

Thanks.

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi,

You can find a lot on this topic in DFSORT/ICETOOL forum

Try executing the below job :

sant532 · New User Joined: 02 Jun 2008 Posts: 48 Location: India

what is the meaning of
15:SEQNUM,8,ZD in INREC FIELDS=(1,8, 15:SEQNUM,8,ZD)

sant532 · New User Joined: 02 Jun 2008 Posts: 48 Location: India

Hi Kapil...That is WORKING WELL.
Thanks A lot.

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi,

SEQNUM,8,ZD : This generates sequence nos. of 8 digits in zone decimal format.

Thanks,
-Kapil.

sant532 · New User Joined: 02 Jun 2008 Posts: 48 Location: India

hi Kapil one more question ....what is the use of WITH

SPLICE FROM(T1) TO(OUT) ON(15,8,ZD) -
WITH(9,6) USING(CTL3)

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Try reading this. It gives detailed description on DFSORT's SPLICE operator.

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA30/6.13?DT=20080528171007

Further if you search this forum for SPLICE. You will get lots of various ways to use SPLICE.

Thanks,
-Kapil.

Frank Yaeger · Posted: Mon Jan 19, 2009 10:48 pm

For more specific information on the technique Kapil used, see the "Join fields from two files record-by-record" Smart DFSORT Trick at:

Use [URL] BBCode for External Links

You can access all of the DFSORT books from:

Use [URL] BBCode for External Links