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
 

 

SYNCTOOL report had "STEP WAS EXECUTED - COND CODE 0020

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

New User


Joined: 28 Jan 2011
Posts: 2
Location: springfield,virginia

PostPosted: Tue Feb 01, 2011 7:37 pm    Post subject: SYNCTOOL report had "STEP WAS EXECUTED - COND CODE 0020
Reply with quote

I am using SYNCTOOL to Read in sorted file then put data to heading report foramt.
[2]Sorted input file: (DSN=TEST.DVL.USER.S01)
col 1-9 col 10-24 col 25-34
001111111AAAAAAA FFFFFFF A00111BBBx
002222222BBBBBBBBBB GGGGG B00222BBBB
003333333CCCCCCCC HHHHHH C00333BBBx
004444444DDDDDDDDDD IIIII D00444BBBx
005555555EEEEEEEE JJJJJJ E00555 BBBx
006666666FFFFFF LLLLLLLL C11166CCCO

col 1-9 ID-number x(9)
col10-24 Last name x(15)
col25--34 First name x(10)
col35-38 loc-id x(4)
col39-40 code x(2)
col41-44 office x(4)

[2]Ideally, I'd like to extract the first 3 byte of col41-43 office which has "BBB" type of records. I put all required records to heading format as below:
DATE: current date official use only TIME:current time
User report page 1

User Last name First name Loc-id code office
------------- ------------ ------------ ------- ----- -------
001111111 AAAAAAA FFFFFFF A001 11 BBBx
002222222 BBBBBBBBBB GGGGG B002 22 BBBB
003333333 CCCCCCCC HHHHHH C003 33 BBBx
004444444 DDDDDDDDDD IIIII D004 44 BBBx
005555555 EEEEEEEE JJJJJ E005 55 BBBx

[3] Please see my codes below:
Code:

//S1 EXEC PGM=SYNCTOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//INDD     DD DSN=TEST.DVL.USER.S01,DISP=SHR
//PRINT  DD SYSOUT=*
//USER     DD DSN=TEST.DVL.OUTPUT.S02,
//            DISP=(,CATLG,DELETE),
//            UNIT=SYSDA,SPACE=...
//TOOLIN   DD *
          SORT FROM(INDD) TO(USER) USING(AAA1)
          DISPLAY FROM(USER) LIST(PRINT) -
              TITLE ('USER REPORT                ') -
                  PAGE -
                  DATE(4MD/) -
                  TIME(24:) -
                  BLANK -
                   ON(1,9,CH)   HEADER ('USER-ID') -
                   ON(10,15,CH) HEADER ('LAST NAME') -
                   ON(25,10,CH) HEADER ('FIRST NAME') -
                   ON(35,4,CH)  HEADER ('LOC-ID') -
                   ON(39,2,CH)  HEADER ('CODE') -
                   ON(41,4,CH)  HEADER ('OFFICE')
/*
//AAA1CNTL DD *
          SORT FIELDS=(1,9,CH,A)
           INCLUDE COND=(41,3,CH,EQ,C'BBB')
/*
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Tue Feb 01, 2011 9:12 pm    Post subject: Reply to: ICETOOL report had "STEP WAS EXECUTED - COND
Reply with quote

Andy, it would probably be helpful if you would double-check your job to make sure you've accounted for all of the necessary DD statements (I updated your code to be syntactically correct) and then posted the output of your TOOLMSG and DFSMSG DD statements.
Back to top
View user's profile Send private message
andy chang

New User


Joined: 28 Jan 2011
Posts: 2
Location: springfield,virginia

PostPosted: Tue Feb 01, 2011 10:56 pm    Post subject: ICETOOL report had "STEP WAS EXECUTED - COND code 0020&
Reply with quote

Kevin:
Thank you for issue solutions.
I read SYNCTOOL DD statement menu. It seems I only need INDD/TOOLMSG/DFSMSG or PRINT/ USER DD statements for my query report. However, after job ran, I got below message "code 12".

SYT004I SYNCTOOL PROCESSING COMPLETED WITH RETURN CODE 12
[2]
//S1 EXEC PGM=SYNCTOOL
//INDD DD DSN=TEST.DVL.USER.S01,DISP=SHR
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//PRINT DD SYSOUT=*
//CBPREC DD DSN=TEST.DVL.OUTPUT.S02,
// DISP=(,CATLG,DELETE),
// UNIT=SYSDA,SPACE=(TRK,(9900,9900),RLSE)
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: Tue Feb 01, 2011 10:58 pm    Post subject:
Reply with quote

Hello,

There is more specific diagnostic information presented. You need to post this. . .
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Feb 01, 2011 11:18 pm    Post subject:
Reply with quote

This is SYNCSORT and NOT DFSORT

Topic moved to the correct forum
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 Splitting of single report to seperat... abdulrafi TSO/ISPF 3 Mon Mar 27, 2017 3:59 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts Easytrieve report shalem CA Products 4 Sun Feb 26, 2017 9:08 am


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