MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Selective copy from sdsf to dataset
Goto page Previous  1, 2
 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF
View previous topic :: View next topic  
Author Message
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Thu Mar 27, 2014 7:00 am    Post subject: Reply with quote

I tried this in the EQQCYAIN code :

//SYSIN DD *
ACTION=LIST,RESOURCE=CPOPCOM,JOBNAME=JOB1,STATUS=E
/*

but it is not giving the step number and reason for error.
Back to top
View user's profile Send private message
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1

PostPosted: Thu Mar 27, 2014 1:16 pm    Post subject: Reply with quote

Why does what you tried not have the SELECT that was recommended?

Possibly there is something i am missing . . .
_________________
All the best,

di
Back to top
View user's profile Send private message
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Sun Mar 30, 2014 1:10 am    Post subject: Reply with quote

Hi...


1.I didnt understand how to use the SELECT in EQQYCAIN code.

2.When an abend occurs , is it possible to copy only the portion of sysdump (from sysdump till END of sysdump) from spool to dataset???
Back to top
View user's profile Send private message
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Sun Mar 30, 2014 11:19 pm    Post subject: Reply with quote

sorry..I actually meant that when an abend occurs,how to print from SYMPTOM DUMP till END OF SYMPTOM DUMP from spool to dataset???
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Mon Mar 31, 2014 11:05 am    Post subject: Reply with quote

apru wrote:
Hi...


1.I didnt understand how to use the SELECT in EQQYCAIN code.

2.When an abend occurs , is it possible to copy only the portion of sysdump (from sysdump till END of sysdump) from spool to dataset???


1.How about you look up the manual and read about it? Look under the section B

http://publib.boulder.ibm.com/tividd/td/TWS/SC32-1266-00/en_US/HTML/Eqqn1mst260.htm#wq1686

2. Why can't you allocate a dataset to sysdump DD and then you have all the contents you want.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Tue Apr 01, 2014 10:31 am    Post subject: Reply with quote

Thanks Kolusu

I was able to print the required contents to flat file. Smile...But I need some clarifications :-

1.Is it possible to filter both IEF142I message and the related IEF640I messages from spool to dataset together in case of JCL errors??

ie.Can we print the job code,jcl error(obtained from IEF142I message) and the reason for error(obtained from IEF640I message) in a single line in dataset??...

2.In case of IEFC605I messages,how can we print the line number appearing before the IEFC605I message to the dataset??
Back to top
View user's profile Send private message
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Tue Apr 01, 2014 12:00 pm    Post subject: Reply with quote

Sorry for not including the below topic in my previous query...

In the TWS automatic recovery statement ,Is it possible to pass any parameter?

Actually I have the following statement:

//*%OPC recover restart=n,addappl=appl1

*****************************************************

In the APPL1 application ,I have a job called JOB1 to copy contents from spool to dataset.
Is there any way to pass the jobname of the failed job as parameter to JOB1 ??
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Tue Apr 01, 2014 4:12 pm    Post subject: Reply with quote

apru wrote:
Thanks Kolusu

I was able to print the required contents to flat file. Smile...But I need some clarifications :-

1.Is it possible to filter both IEF142I message and the related IEF640I messages from spool to dataset together in case of JCL errors??

ie.Can we print the job code,jcl error(obtained from IEF142I message) and the reason for error(obtained from IEF640I message) in a single line in dataset??...

2.In case of IEFC605I messages,how can we print the line number appearing before the IEFC605I message to the dataset??


1. You need to modify the DFSORT job I gave initially.

2. I have no idea as to what you want. You need to show me an example of what you meant by LINE NUMBER?

apru wrote:
In the APPL1 application ,I have a job called JOB1 to copy contents from spool to dataset.
Is there any way to pass the jobname of the failed job as parameter to JOB1 ??


Why don't you schedule the job using OPC? Read upon the manuals and look up examples.

Finally I think you are honestly trying to re-invent the wheel and wasting your time.
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Wed Apr 02, 2014 6:54 am    Post subject: Reply with quote

Hi..

Actually I want to print the job code,jcl error(obtained from IEF142I message) and the reason for error(obtained from IEF640I message) in a single line in dataset.I tried the following code:

INREC IFTHEN=(WHEN=(21,7,CH,EQ,C'IEF452I',AND,12,7,CH,EQ,C'IEF640I'),
PARSE=(%01=(STARTAFT=C'IEF452I ',ENDBEFR=C' ',FIXLEN=8),
%02=(STARTAFT=C'- ',ENDBEFR=C'-',FIXLEN=11),
%03=(STARTAFT=C' ',FIXLEN=20),
%04=(STARTAFT=C'IEF640I ',FIXLEN=80)),
BUILD=(%01,C'#',%03,C'#',%04,133:X))

But I am not getting the required output with this code...Should we parse both the strings separately and then build them together???
Back to top
View user's profile Send private message
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Wed Apr 02, 2014 10:25 am    Post subject: Reply with quote

Hi

1.I did try EQQYCAIN utility with SELECT parm .but I was not able to get the required data alone..(jobname, stepname, errorcode, reason)

2.By line numbers in IEF605I message , what I meant is,

4 IEF605I INVALID OPERAND


In the above line, how is it possible to filter the line number (in this case 4 ) along with the reason???
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Wed Apr 02, 2014 11:38 am    Post subject: Reply with quote

apru,

Did you understand the DFSORT job I gave you? Initially your request to pull the information from IEF142I which has the information you wanted after the message.

Now for IEF605I message you want the data before and After the message, so you need to change it accordingly and you simply cannot use the same logic used for IEF142I.

Having said that what are you going to do with this information? You are simply spending time on something that is already available.

Kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Thu Apr 03, 2014 11:19 am    Post subject: Reply with quote

Hi

I did try the code to print the IEF452I and IEF640I messages in the same line.
But I am getting a syntax error.Can you please help me resolve the error??
This is the code snippet:
Code:

INREC IFTHEN=(WHEN=(21,7,CH,EQ,C'IEF452I'),
PARSE=(%01=(STARTAFT=C'IEF452I ',ENDBEFR=C' ',FIXLEN=8),
%02=(STARTAFT=C'- ',ENDBEFR=C'-',FIXLEN=11),
%03=(STARTAFT=C' ',FIXLEN=20)),
BUILD=(%01,C'#',%03,C'#')),
IFTHEN=(WHEN=12,7,CH,EQ,C'IEF640I'),
PARSE=(%04=(STARTAFT=C'IEF640I ',FIXLEN=80)),
BUILD=(22:%04))


REQUIRED OUTPUT:
Code:

  JOBNAME # JOB NOT RUN # JCL ERROR # EXCESSIVE NUMBER OF ........
Back to top
View user's profile Send private message
apru
Beginner


Joined: 15 Feb 2014
Posts: 25
Topics: 6

PostPosted: Thu Apr 03, 2014 11:20 am    Post subject: Reply with quote

Actually this data set is required for another program.That is the reason why I am filtering only selective data.. Sad
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Thu Apr 03, 2014 12:39 pm    Post subject: Reply with quote

apru wrote:
But I am getting a syntax error.Can you please help me resolve the error??


Apru,

Did you even try to look at the error in the sysout? bonk: It is quite self explanatory. DFSORT flags the first statement by position where it found the error with a $ symbol. You are missing an opening parenthesis for the 2nd IFTHEN. Please spend time to understand and debug instead of relying on someone to help you.

Code:

ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 10:27 ON THU
            OPTION COPY                                                       
            INREC IFTHEN=(WHEN=(21,7,CH,EQ,C'IEF452I'),                       
            PARSE=(%01=(STARTAFT=C'IEF452I ',ENDBEFR=C' ',FIXLEN=8),         
            %02=(STARTAFT=C'- ',ENDBEFR=C'-',FIXLEN=11),                     
            %03=(STARTAFT=C' ',FIXLEN=20)),                                   
            BUILD=(%01,C'#',%03,C'#')),                                       
            IFTHEN=(WHEN=12,7,CH,EQ,C'IEF640I'),                             
                         $                                                   
ICE007A F SYNTAX ERROR                                                       
            PARSE=(%04=(STARTAFT=C'IEF640I ',FIXLEN=80)),                     
            $                                                                 
ICE005A 0 BLANK NEEDED IN COLUMN 1 OR OPERATION NOT DEFINED CORRECTLY         
            BUILD=(22:%04))                                                   
            $                                                                 


Moreover you keep changing your requirements over and over. As I keep insisting on how this whole thing is sheer waste of time, your solution cannot cover all the scenarios. ex : For a JCL error you might have different codes like IEF648I or IEFC006I or some other code depending on what the error is. How are you going to account for all of those?

You are spending time on a trivial solution for about 20 days which can be used to do something more useful than this moot exercise.

Any way here are the updated control cards.

Code:

  INCLUDE COND=(02,7,CH,EQ,C'IEF142I',OR,                           
                12,7,CH,EQ,C'IEF648I',OR,                           
                12,8,CH,EQ,C'IEFC006I')                             
                                                                   
  INREC IFTHEN=(WHEN=(2,7,CH,EQ,C'IEF142I'),                       
        PARSE=(%01=(STARTAFT=C'IEF142I ',ENDBEFR=C' ',FIXLEN=8),   
               %02=(ENDBEFR=C' ',FIXLEN=8),                         
               %03=(STARTAFT=C'COND CODE ',FIXLEN=8)),             
  BUILD=(%01,C'#',%02,C'#',%03,JFY=(SHIFT=LEFT))),                 
  IFTHEN=(WHEN=(12,7,CH,EQ,C'IEF648I',OR,12,8,CH,EQ,C'IEFC006I'),   
        PARSE=(%04=(ABSPOS=3,ENDBEFR=C'IEF648I',ENDBEFR=C'IEFC006I',
                     FIXLEN=8),                                     
               %05=(FIXLEN=80)),                                   
  BUILD=(%04,UFF,M11,LENGTH=8,C'#',%05))     


apru wrote:
Actually this data set is required for another program.That is the reason why I am filtering only selective data..


If it is a program you can actually do a lot more to filter out the contents you need.

P.S. This will be my last post on this topic.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF All times are GMT - 5 Hours
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group