|
View previous topic :: View next topic
|
| Author |
Message |
rahul sijoriya
New User
.jpg)
Joined: 08 Jan 2007
Posts: 11
Location: hyderabad
|
|
|
|
Hello All,
I need help to merge two records from different file using same key..in below example key is "STATUS"
File 1 :
123456789STATUS
111111111STATUS
222222222STATUS
134567834STATUS
File2:
STATUSINITIAL
I want output:
123456789INITIAL
111111111INITIAL
222222222INITIAL
134567834INITIAL
Please help me to write JCL using ICETOOL. |
|
| Back to top |
|
 |
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
| Could you please post the product and version used in your shop? |
|
| Back to top |
|
|
rahul sijoriya
New User
Joined: 08 Jan 2007
Posts: 11
Location: hyderabad
|
|
|
|
| Please suggest what you mean by product and version? |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
| Product : DFSORT or SYNCSORT? |
|
| Back to top |
|
|
rahul sijoriya
New User
Joined: 08 Jan 2007
Posts: 11
Location: hyderabad
|
|
|
|
| I used to have PGM=SORT in my jcl |
|
| Back to top |
|
|
rahul sijoriya
New User
Joined: 08 Jan 2007
Posts: 11
Location: hyderabad
|
|
|
|
| Its DFSORT |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
Ok and the version is ?
Please execute this step and let us know the SYSOUT
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN DD *
OPTION COPY
/* |
|
|
| Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006
Posts: 1702
Location: Australia
|
|
|
|
Hi,
if there is only 1 record in File 2, create a SYMNAMES from it and pass it to Step2 and use OVERLAY.
Gerry |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
gcicchet,
Yes that is indeed "the" best solution but I am just trying to understand from TS his sort version if it would support SYMNAMES. |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
For someone who has been here 6 years, cannot use code tags, does not supply LRECL or RECFM, does not know what is meant by Product and Version, thinks ICETOOL can produce JCL (which it could but the requirement is actually with sort control cards which are not JCL), posts in the DFsort/ICETOOL part of the forum which obviously means that he is requiring help with that product so why title the post "Need help on ICETOOL"...
And why ICETOOL - it can probably be done with plain vanilla DFSort. |
|
| Back to top |
|
|
rahul sijoriya
New User
Joined: 08 Jan 2007
Posts: 11
Location: hyderabad
|
|
|
|
| Dear Nic, I never used this forum earlier. So not much aware about it ..I am sorry if I have done any mistake in my post.. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I am sorry if I have done any mistake in my post.. |
Not to worry - we were all new to forum etiquette once upon a time.
When you were asked to run:
| Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN DD *
OPTION COPY
/* |
it was to provide info we might need in order to help you. That execution will provide information about your version and release of the sort product. |
|
| Back to top |
|
|
rahul sijoriya
New User
Joined: 08 Jan 2007
Posts: 11
Location: hyderabad
|
|
|
|
I ran the ICEMAN posted in the chain.
And here is the Product and version. I believe this is what you guys are looking for.
| Code: |
**** SYNCSORT FOR Z/OS R 1.4 **** z/OS
|
|
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
Finally the cat is out of the bag .. God bless you 
FYI Syncsort queries needs to be posted on JCL forum and anyway you dont need to raise a new question again.
Probably some moderator who reads it will move there
And Please check the SYCNSORT manual for R 1.4 and check if supports "SYMNAMES"
If Symnames is not supported in R 1.4 Joinkeys is a better option |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I believe this is what you guys are looking for. |
Yup - that is what we were looking for.
Notice that your system is running Syncsort (rather than DFSORT).
For this particular question, it is not an issue. For others it can be. Syncsort and DFSORT are quite similar, but they are Not Exactly the same. They are competing products from diffetent vendors.
Also, different features (i.e. SYNMANES) became available at different times in various versions of each product.
And yes, i'll relocate this  |
|
| Back to top |
|
|
|
|
