View previous topic :: View next topic
|
Author |
Message |
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
Hi,
My I/P file is-
Code: |
****** **************
000100 AAAA
000110 AAAA1 1111
000200 BBBB1
000210 BBBB2
000300 CCCC1 1111
000400 DDDD1
000500 FFFF1
****** ************** |
In my O/P file I want
AAAA
i.e. the only duplicate record based on first 4 characters AND havin AAAA in first 4 positions.
Am trying to use ICETOOL-
Code: |
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,4,CH) USING(CTL1) FIRSTDUP
/*
//CTL1CNTL DD *
SORT FIELDS=COPY
INCLUDE COND=(1,4,CH,EQ,C'AAAA') |
[code]
but my O/P file is empty. Pls let me know what have I missed.I need to use ICETOOL/SYNCTOOL only with the USING clause.If there is any link I can refer, a PDF or something on ICETOOL.
Whats the diffrnc btw ICETOOL and SYNCTOOL? |
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
I/P file is FB-255 and O/P file is FB-80. |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
t5590ag,
I get 1 record aaaa in the output when I run the same job. All I added is the output lenth to be 80 bytes. If you say it is not giving you the desired results , you need to show us the complete TOOLMSG and DFSMSG error messages
Code: |
//STEP0100 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//SORTIN DD *
AAAA
AAAA1 1111
BBBB1
BBBB2
CCCC1 1111
DDDD1
FFFF1
//SORTOUT DD SYSOUT=*
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,4,CH) USING(CTL1) FIRSTDUP
//CTL1CNTL DD *
SORT FIELDS=COPY
INCLUDE COND=(1,4,CH,EQ,C'AAAA')
OUTFIL FNAMES=SORTOUT,BUILD=(1,80)
/* |
|
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
hi kolusu,this is the toolmsg.
COMMAND INPUT ===> SCROLL ===> CSR
********************************* TOP OF DATA *********************************
SYT000I SYNCTOOL RELEASE 1.6.0 - COPYRIGHT 2007 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED
SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 0
and unfortunately am not getting dfsmsg everytime. I used the above as suggested by you, not working.I tried synctool as well, can it be a system compatibility problem? |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
t5590ag,
The job works fine with DFSORT. From your error messages it is evident that you are using SYNCSORT . Frank and I are DFSORT developers. DFSORT and Syncsort are competitive products. We are happy to answer questions on DFSORT and DFSORT's ICETOOL, but we don't answer questions on Syncsort. |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Because you are not using DFSORT'S ICETOOL but you are using SYNCTOOL of SYNCSORT |
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
hi all, I am using icetool only but am getting same messages as above again which you say is cos am using syncsort.
Whenever I use the 'using' clause am getting empty file otherwise simple 'select from to' card works fine. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Which release of Syncsort is being used?
If you do not know, run any sort and the release/level is available in the informational output. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
unfortunately am not getting dfsmsg everytime. |
I wonder why . Can you post the unedited RUN JCL here along with the DFSMSG output? |
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
Dick,
If you see my above posts, this is the toolmsg-
Code: |
SYT000I SYNCTOOL RELEASE 1.6.0 - COPYRIGHT 2007 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS "STOP"
SYT002I "TOOLIN" INTERFACE BEING USED
SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 0
|
I understand you are talking about release- 1.6.0 it is.
Is that correct ? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
No. It's NOT. What you have shown is the SYNCTOOL release not the Syncsort release. It'll be present in your DFSMSG output. |
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
hi arun,
JCL, and Sysouts are attached, here is the O/P when I dont use USING-
Code: |
****** *****************
000001 AAAA
000002 BBBB1
****** ***************** |
It works. Pls note I get syncsort msgs in my dfsmsg again.
But when I say USING CTL1 my JCL-
the change is here-
Code: |
000912 //*DISCARD DD SYSOUT=*
001000 //TOOLIN DD *
001050 SELECT FROM(SORTIN) TO(SORTOUT) ON(1,4,CH) USING(CTL1) FIRSTDUP
001110 //CTL1CNTL DD *
001130 SORT FIELDS=COPY
001140 INCLUDE COND=(1,4,CH,EQ,C'AAAA')
001141 OUTFIL FNAMES=SORTOUT,BUILD=(1,80)
001150 /*
001800 //* |
Rest is same. I dont understand, am getting a DFSMSG today with the same JCL,so that seems fine.Check sysout attached. Still getrting syncsort out thr in spool.
I/P is-
Code: |
000100 AAAA
000110 AAAA1 1111
000200 BBBB1
000210 BBBB2
000300 CCCC1 1111
000400 DDDD1
000500 FFFF1 |
|
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
Hi Arun, Hope you got it in the attachments now, the release. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
t5590ag,
I am away from office now. It's always better to post jcl/output messages using "Code" tags rather than attaching them as not everybody can access attachments.
BTW, can you remove the "SORT FIELDS=COPY" from your CTL1 card and try submitting the same job? |
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
Hi Arun, that was gr8..!
It worked.
I used this-
Code: |
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,4,CH) USING(CTL1) FIRST -
DISCARD(DISCARD)
//CTL1CNTL DD *
INCLUDE COND=(1,4,CH,EQ,C'AAAA')
//*SORT FIELDS=COPY
//*OUTFIL FNAMES=SORTOUT,BUILD=(1,80) |
O/P is -
Code: |
****** **********
000001 AAAA |
That is fine now. Thanks for that.
Now if I change my card-
Code: |
//TOOLIN DD *
SELECT FROM(SORTIN) TO(SORTOUT) ON(1,4,CH) USING(CTL1) FIRST -
DISCARD(DISCARD)
//CTL1CNTL DD *
INCLUDE COND=(1,4,CH,EQ,C'AAAA')
SORT FIELDS=COPY
//*OUTFIL FNAMES=SORTOUT,BUILD=(1,80) |
Uncommented the SORT FIELDS sttmnt. O/P is-
Code: |
000001 ÷ Ù2h " 0 " 0 " 0 " 0 " 0 " 0 " 0 " 0
000002 ÷ Ù2h " 0 " 0 " 0 " 0 " 0 " 0 " 0 " 0 |
Y does it look like this now ? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
Hi Arun, that was gr8..!
It worked. |
Hello,
I was away for a few days and could n't check the posts here. I have come across the same situation many times, but removing the 'SORT FIELDS=COPY' always worked for me and I see it worked for you as well. |
|
Back to top |
|
|
t5590ag
Active User
Joined: 21 May 2009 Posts: 139 Location: United States
|
|
|
|
yep..anyways..thanks for help Arun. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
t5590ag,
You're welcome. |
|
Back to top |
|
|
|