Re: Error ICE007A on ICETOOL OMIT sentence
On Mon, 8 Feb 2016 01:37:02 -0600, Hilario Garcia wrote: >Hello, > >On book "Application Programmer Guide" appear the text: > >"You can specify either an INCLUDE statement or an OMIT statement in the same >DFSORT run, but not both". > >I read that before, but this is not really truth. Dfsort run correctly if I >write an INCLUDE and an OMIT like this examples: > >INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') >OMITCOND=(239,3,CH,EQ,C'JOB') > >Too work correctly with this syntax: > >INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') >OMITCOND=(239,3,CH,EQ,C'JOB',OR,239,3,CH,EQ,C'SYS') > >But didn't work this syntax: > >INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') >OMITCOND=(239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'SYS') > >I will try to put all the logic on INCLUDE statement. > >Thanks in advance > >Kind regards. > >Hilario > Also, for analyzing SMF type 30 records, the OP will want to take notice that a z/OS Version/Release change and possibly interim maintenance may impact the starting-location of the IDENTIFICATION SECTION (IBM field name SMF30IOF) -- this would change the offset-location for at least the OMIT. As well, a JES configuration change to 7-digit job numbers will impact the data-string found as SMF30JNM. I have personally observed this situation multiple times in the past few years, with new-release z/OS V2R1 and z/OS V1R13 (maintenance), as I recall. Scott Barry SBBWorks, Inc. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Error ICE007A on ICETOOL OMIT sentence
>>> I read that before, but this is not really truth. Dfsort run correctly if I write an INCLUDE and an OMIT like this examples: Hilario, As Bill woodger kindly pointed out, you should pay attention to your sysout messages and if you look closely you will find this ICE002I 0 DUPLICATE OR CONFLICTING OMIT STATEMENT Since you had the INCLUDE cond as the first statment, the second OMIT statement is discarded. The text between the words "conflicting" and "statement" is variable, so DFSORT will fill out what it considers as duplicate and fill that variable text. So what you thought as working is not what DFSORT did. So please follow the manual and it is correctly documented the way DFSORT processed your control cards. Thanks, Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 02/08/2016 12:37:02 AM: > From: Hilario Garcia > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 02/08/2016 12:37 AM > Subject: Re: Error ICE007A on ICETOOL OMIT sentence > Sent by: IBM Mainframe Discussion List > > Hello, > > On book "Application Programmer Guide" appear the text: > > "You can specify either an INCLUDE statement or an OMIT statement in the same > DFSORT run, but not both". > > I read that before, but this is not really truth. Dfsort run > correctly if I write an INCLUDE and an OMIT like this examples: > > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > OMITCOND=(239,3,CH,EQ,C'JOB') > > Too work correctly with this syntax: > > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > OMITCOND=(239,3,CH,EQ,C'JOB',OR,239,3,CH,EQ,C'SYS') > > But didn't work this syntax: > > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > OMITCOND=(239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'SYS') > > I will try to put all the logic on INCLUDE statement. > > Thanks in advance > > Kind regards. > > Hilario > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Error ICE007A on ICETOOL OMIT sentence
You have unintentionally confused "the step runs to the end" with "run correctly". If I put in your three sets of Control Cards, in the SYSOUT output for each I get "ICE002I 0 DUPLICATE OR CONFLICTING OMIT STATEMENT". That's an informational message, and it doesn't explicitly tell you what it has done, but it has discarded the line. When the line being discarded has a continuation, the next line is not good syntax, so you get told that. You have two cases: complete Control Card discarded because you are not allowed to do that; partial Control Card discarded because you are not allowed to do that. DFSORT is correct, your Control Cards (when no syntax error) do not do what you think, but what DFSORT tells you they do. On Monday, 8 February 2016 07:37:12 UTC, Hilario Garcia wrote: > Hello, > > On book "Application Programmer Guide" appear the text: > > "You can specify either an INCLUDE statement or an OMIT statement in the same > DFSORT run, but not both". > > I read that before, but this is not really truth. Dfsort run correctly if I > write an INCLUDE and an OMIT like this examples: > > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > OMITCOND=(239,3,CH,EQ,C'JOB') > > Too work correctly with this syntax: > > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > OMITCOND=(239,3,CH,EQ,C'JOB',OR,239,3,CH,EQ,C'SYS') > > But didn't work this syntax: > > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > OMITCOND=(239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'SYS') > > I will try to put all the logic on INCLUDE statement. > > Thanks in advance > > Kind regards. > > Hilario > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Error ICE007A on ICETOOL OMIT sentence
Hello, On book "Application Programmer Guide" appear the text: "You can specify either an INCLUDE statement or an OMIT statement in the same DFSORT run, but not both". I read that before, but this is not really truth. Dfsort run correctly if I write an INCLUDE and an OMIT like this examples: INCLUDE COND=(6,1,CH,EQ,X'1E',AND, 178,1,CH,EQ,X'05') OMITCOND=(239,3,CH,EQ,C'JOB') Too work correctly with this syntax: INCLUDE COND=(6,1,CH,EQ,X'1E',AND, 178,1,CH,EQ,X'05') OMITCOND=(239,3,CH,EQ,C'JOB',OR,239,3,CH,EQ,C'SYS') But didn't work this syntax: INCLUDE COND=(6,1,CH,EQ,X'1E',AND, 178,1,CH,EQ,X'05') OMITCOND=(239,3,CH,EQ,C'JOB',OR, 239,3,CH,EQ,C'SYS') I will try to put all the logic on INCLUDE statement. Thanks in advance Kind regards. Hilario -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Error ICE007A on ICETOOL OMIT sentence
Hilario, As Bill pointed out you cannot have both INCLUDE and OMIT COND in the same step. If you want both you need to move one of them to OUTFIL. Check this link which illustrates the processing order for record handling, exits, statements, and options. Use this diagram with the text following it to understand the order DFSORT uses to run your job. http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA60/1.5.4 Elardus Engelbrecht has shown a way to add the exclude list to your include cards and here is another way of doing it. You would also need VLSCMP not VLSHRT(as it is used for SORTING) for the include/omit to cond to work as there can be short records //VLSHCNTL DD * OPTION VLSCMP INCLUDE COND=((006,1,BI,EQ,30,AND, $ TYPE-30 178,1,CH,EQ,X'05'),AND, $ SUB-TYPE (239,3,SS,NE,C'IBM,JOB,AUT,SYS')) $ EXCLUDE LIST //* Further if you have questions please let me know Thanks, Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 02/05/2016 06:13:33 AM: > From: Hilario Garcia > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 02/05/2016 06:13 AM > Subject: Error ICE007A on ICETOOL OMIT sentence > Sent by: IBM Mainframe Discussion List > > Hello, > > I need to omit records with some users that are located on SMF type > 30 records. > > The code that I have is: > > //STEP0010EXEC PGM=ICETOOL > //TOOLMSGDD SYSOUT=* > //DFSMSG DD SYSOUT=* > //VLSHCNTL DD * > OPTION COPY,VLSHRT > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > ** > ** OMIT RECORDS > ** > OMITCOND=(239,3,CH,EQ,C'IBM',OR, > 239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'AUT',OR, > 239,3,CH,EQ,C'AUT',OR, > > 239,3,CH,EQ,C'SYS') > > I always receive the error ICE007A on all the OMIT but not in the > first. If I put in the same line two OMIT it works only on the first > line but not in the rest and the error is always ICE007A. I have try > so much examples but allways I receive the error. > > Some additional info: > > ** >OMITCOND=(239,3,CH,EQ,C'IBM',OR,239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'SYS') > $ > ICE007A 0 SYNTAX ERROR > ICE146I 0 END OF STATEMENTS FROM VLSHCNTL - PARAMETER LIST STATEMENTS FOLLOW > DEBUG NOABEND,ESTAE > > - > >OMITCOND=(239,3,CH,EQ,C'IBM',OR, > 239,3,CH,EQ,C'JOB',OR, > $ > ICE007A 0 SYNTAX ERROR > 239,3,CH,EQ,C'SYS',OR, > $ > ICE007A 0 SYNTAX ERROR > 239,3,CH,EQ,C'AUT',OR, > $ > . > > > I read the DFSORT manual but I follow the code restriction or I thik so. > > May anybody help me ? > > Thanks in advance. > > Hilario > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Error ICE007A on ICETOOL OMIT sentence
Hilario Garcia wrote: >//STEP0010EXEC PGM=ICETOOL >//TOOLMSGDD SYSOUT=* >//DFSMSG DD SYSOUT=* >//VLSHCNTL DD * > OPTION COPY,VLSHRT > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') >** >** OMIT RECORDS >** > OMITCOND=(239,3,CH,EQ,C'IBM',OR, > 239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'AUT',OR, > 239,3,CH,EQ,C'AUT',OR, > > 239,3,CH,EQ,C'SYS') What about this one? INCLUDE COND=(6,1,CH,EQ,X'1E',AND,178,1,CH,EQ,X'05',AND, (239,3,CH,NE,C'IBM',OR, 239,3,CH,NE,C'JOB',OR, 239,3,CH,NE,C'AUT',OR, ... 239,3,CH,NE,C'SYS')) Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: Error ICE007A on ICETOOL OMIT sentence
Did you look at the syntax diagram for continuing control cards in DFSORT? What did it say? https://www-304.ibm.com/support/knowledgecenter/SSLTBW_2.1.0/com.ibm.zos.v2r1.icea100/ice2ca_Continuation_lines.htm?lang=en Or Tiny URL http://tinyurl.com/jce63eh Check the control statements for syntax errors. Some of the more common syntax errors are: Unbalanced parenthesis Missing comma Embedded blank Invalid format type Invalid operator Invalid constant Continuation of DFSPARM PARM options using the continuation column. Symbol used where it is not allowed Parsed field (%nnn, %nn or %n) used where it is not allowed. Lizette > -Original Message- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Hilario Garcia > Sent: Friday, February 05, 2016 6:14 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Error ICE007A on ICETOOL OMIT sentence > > Hello, > > I need to omit records with some users that are located on SMF type 30 > records. > > The code that I have is: > > //STEP0010EXEC PGM=ICETOOL > //TOOLMSGDD SYSOUT=* > //DFSMSG DD SYSOUT=* > //VLSHCNTL DD * > OPTION COPY,VLSHRT > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > ** > ** OMIT RECORDS > ** > OMITCOND=(239,3,CH,EQ,C'IBM',OR, > 239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'AUT',OR, > 239,3,CH,EQ,C'AUT',OR, > > 239,3,CH,EQ,C'SYS') > > I always receive the error ICE007A on all the OMIT but not in the first. If I > put in the same line two OMIT it works only on the first line but not in the > rest and the error is always ICE007A. I have try so much examples but allways > I receive the error. > > Some additional info: > > ** >OMITCOND=(239,3,CH,EQ,C'IBM',OR,239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'SYS') > $ > ICE007A 0 SYNTAX ERROR > ICE146I 0 END OF STATEMENTS FROM VLSHCNTL - PARAMETER LIST STATEMENTS FOLLOW > DEBUG NOABEND,ESTAE > > -- > --- > >OMITCOND=(239,3,CH,EQ,C'IBM',OR, > 239,3,CH,EQ,C'JOB',OR, > $ > ICE007A 0 SYNTAX ERROR > 239,3,CH,EQ,C'SYS',OR, > $ > ICE007A 0 SYNTAX ERROR > 239,3,CH,EQ,C'AUT',OR, > $ > . > > > I read the DFSORT manual but I follow the code restriction or I thik so. > > May anybody help me ? > > Thanks in advance. > > Hilario -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Error ICE007A on ICETOOL OMIT sentence
From the DFSORT Application Programming Guide description of INCLUDE: "You can specify either an INCLUDE statement or an OMIT statement in the same DFSORT run, but not both" -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Error ICE007A on ICETOOL OMIT sentence
You can't have both INCLUDE and OMIT in the same step. You'll need to work your omissions into the INCLUDE or your inclusions into the OMIT. On Friday, 5 February 2016 13:13:41 UTC, Hilario Garcia wrote: > Hello, > > I need to omit records with some users that are located on SMF type 30 > records. > > The code that I have is: > > //STEP0010EXEC PGM=ICETOOL > //TOOLMSGDD SYSOUT=* > //DFSMSG DD SYSOUT=* > //VLSHCNTL DD * > OPTION COPY,VLSHRT > INCLUDE COND=(6,1,CH,EQ,X'1E',AND, > 178,1,CH,EQ,X'05') > ** > ** OMIT RECORDS > ** > OMITCOND=(239,3,CH,EQ,C'IBM',OR, > 239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'AUT',OR, > 239,3,CH,EQ,C'AUT',OR, > > 239,3,CH,EQ,C'SYS') > > I always receive the error ICE007A on all the OMIT but not in the first. If I > put in the same line two OMIT it works only on the first line but not in the > rest and the error is always ICE007A. I have try so much examples but allways > I receive the error. > > Some additional info: > > ** >OMITCOND=(239,3,CH,EQ,C'IBM',OR,239,3,CH,EQ,C'JOB',OR, > 239,3,CH,EQ,C'SYS') > $ > ICE007A 0 SYNTAX ERROR > ICE146I 0 END OF STATEMENTS FROM VLSHCNTL - PARAMETER LIST STATEMENTS FOLLOW > DEBUG NOABEND,ESTAE > > - > >OMITCOND=(239,3,CH,EQ,C'IBM',OR, > 239,3,CH,EQ,C'JOB',OR, > $ > ICE007A 0 SYNTAX ERROR > 239,3,CH,EQ,C'SYS',OR, > $ > ICE007A 0 SYNTAX ERROR > 239,3,CH,EQ,C'AUT',OR, > $ > . > > > I read the DFSORT manual but I follow the code restriction or I thik so. > > May anybody help me ? > > Thanks in advance. > > Hilario > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Error ICE007A on ICETOOL OMIT sentence
Hello, I need to omit records with some users that are located on SMF type 30 records. The code that I have is: //STEP0010EXEC PGM=ICETOOL //TOOLMSGDD SYSOUT=* //DFSMSG DD SYSOUT=* //VLSHCNTL DD * OPTION COPY,VLSHRT INCLUDE COND=(6,1,CH,EQ,X'1E',AND, 178,1,CH,EQ,X'05') ** ** OMIT RECORDS ** OMITCOND=(239,3,CH,EQ,C'IBM',OR, 239,3,CH,EQ,C'JOB',OR, 239,3,CH,EQ,C'AUT',OR, 239,3,CH,EQ,C'AUT',OR, 239,3,CH,EQ,C'SYS') I always receive the error ICE007A on all the OMIT but not in the first. If I put in the same line two OMIT it works only on the first line but not in the rest and the error is always ICE007A. I have try so much examples but allways I receive the error. Some additional info: ** OMITCOND=(239,3,CH,EQ,C'IBM',OR,239,3,CH,EQ,C'JOB',OR, 239,3,CH,EQ,C'SYS') $ ICE007A 0 SYNTAX ERROR ICE146I 0 END OF STATEMENTS FROM VLSHCNTL - PARAMETER LIST STATEMENTS FOLLOW DEBUG NOABEND,ESTAE - OMITCOND=(239,3,CH,EQ,C'IBM',OR, 239,3,CH,EQ,C'JOB',OR, $ ICE007A 0 SYNTAX ERROR 239,3,CH,EQ,C'SYS',OR, $ ICE007A 0 SYNTAX ERROR 239,3,CH,EQ,C'AUT',OR, $ . I read the DFSORT manual but I follow the code restriction or I thik so. May anybody help me ? Thanks in advance. Hilario -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN