Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Syncsort - icetool with a control card

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Fri Aug 28, 2009 7:23 pm    Post subject: Syncsort - icetool with a control card
Reply with quote

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
View user's profile Send private message

t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Fri Aug 28, 2009 7:23 pm    Post subject:
Reply with quote

I/P file is FB-255 and O/P file is FB-80.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Fri Aug 28, 2009 9:49 pm    Post subject:
Reply with quote

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
View user's profile Send private message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Fri Aug 28, 2009 10:23 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Fri Aug 28, 2009 10:28 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Fri Aug 28, 2009 10:29 pm    Post subject:
Reply with quote

Because you are not using DFSORT'S ICETOOL but you are using SYNCTOOL of SYNCSORT
Back to top
View user's profile Send private message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Fri Aug 28, 2009 11:07 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 28, 2009 11:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Mon Aug 31, 2009 1:15 pm    Post subject:
Reply with quote

Quote:
unfortunately am not getting dfsmsg everytime.
I wonder why icon_rolleyes.gif . Can you post the unedited RUN JCL here along with the DFSMSG output?
Back to top
View user's profile Send private message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Mon Aug 31, 2009 7:31 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Mon Aug 31, 2009 7:58 pm    Post subject:
Reply with quote

Quote:
Is that correct ?
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
View user's profile Send private message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Mon Aug 31, 2009 8:03 pm    Post subject:
Reply with quote

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
View user's profile Send private message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Mon Aug 31, 2009 8:13 pm    Post subject:
Reply with quote

Hi Arun, Hope you got it in the attachments now, the release.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Mon Aug 31, 2009 10:38 pm    Post subject:
Reply with quote

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
View user's profile Send private message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Tue Sep 01, 2009 5:07 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Mon Sep 07, 2009 2:05 pm    Post subject:
Reply with quote

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. icon_smile.gif
Back to top
View user's profile Send private message
t5590ag

Active User


Joined: 21 May 2009
Posts: 139
Location: United States

PostPosted: Mon Sep 07, 2009 2:38 pm    Post subject:
Reply with quote

yep..anyways..thanks for help Arun.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Tue Sep 08, 2009 8:26 pm    Post subject:
Reply with quote

t5590ag,

You're welcome. icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 6 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us