Home      Mainframe Forum      Mainfarme Tutorials      IBM Manuals      Mainframe Interview Questions      Mainframe Books      IT News     SiteMap     Downloads


     
 
MAINFRAME - TIP OF THE DAY : programming pearls - The fastest algorithm can frequently be replaced by one that is almost as fast and much easier to understand.

Google
 
Web mainframegurukul.com

Welcome to the mainframegurukul forums.

You are currently viewing our mainframe forums as a guest which gives you limited access to view most discussions, articles. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support at admin@mainframegurukul.com


Is there an IEB utility or some trick in JCL to examine. . .

 
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> JCL
  View previous topic :: View next topic  
Author Message
seagreg
Member


Joined: 25 Jan 2007
Posts: 4
Location: USA

PostPosted: Fri Jan 26, 2007 1:14 am    Post subject: Is there an IEB utility or some trick in JCL to examine. . . Reply with quote

the Create-Date of a GDG file?

I have routines that create MONTHLY files based on actually reading the file contents by using the sort/copy & include statements to filter by date, ex:

SORT FIELDS=COPY
INCLUDE COND=(73,3,CH,EQ,C'DEC',76,4,CH,EQ,'2007')

BUT THIS REQUIRES READING ALL GDGs in order to build a given monthly file. . .

Is there a utility or some "JCL trick" that will allow me to read the System Info of a GDG member in order to pull the file in for inclusion/sorting or skipping to the next gdg if the file shouldn't be included? This would save a ton of processing time by not having to read every record in every gdg member in order to build a current monthly file for that gdg family.

An ISPF command like DSL on a filename & "S" by a given file will net you the Info I'm speaking of trying to get to (LRECL/LBLK/Create-Date, etc)

Thanks for shedding a little light into my dim-dim world!!! Idea
_________________
"Charter member of Vast-Right-Wing-Conspiracy"
Back to top
View user's profile Send private message

acevedo
Member


Joined: 21 Mar 2007
Posts: 12

PostPosted: Tue Apr 03, 2007 11:23 am    Post subject: Reply with quote

you could try something like...

Code:
//*==================================================
//LISTCAT  EXEC PGM=IDCAMS,COND=(0,LT)               
//SYSIN    DD *                                     
 LISTCAT ENT(YOURGDG.HERE) ALL                       
//SYSOUT   DD SYSOUT=*                               
//SYSPRINT DD SYSOUT=*                               

or write a small rexx to do the job...

maybe your 'systemers' could give you a better approach...
Back to top
View user's profile Send private message
Veera
Moderator


Joined: 22 Feb 2006
Posts: 111

PostPosted: Thu Apr 05, 2007 8:29 pm    Post subject: Reply with quote

seagreg,

What ever you have asked can be acheived using the REXX, i mean validatuing the creat date and then sorting based on your condition. But may take some time
for coming up with code...but i am sure it can be done.

Well if you are really looking for code and if its fine in REXX let us know ..we will try to getback to you.

acevedo -> LISTCAST will just give you info reg the all gen's and limit
and other parameters like AIX, INDEX, PATH ENTRIES PROCESSED,
but getting the file creat datea and procesing can be done using rexx.


Thanks,
Veera.
Back to top
View user's profile Send private message
acevedo
Member


Joined: 21 Mar 2007
Posts: 12

PostPosted: Wed Apr 11, 2007 11:14 am    Post subject: Reply with quote

Veera wrote:
seagreg,
acevedo -> LISTCAST will just give you info reg the all gen's and limit
and other parameters like AIX, INDEX, PATH ENTRIES PROCESSED,
but getting the file creat datea and procesing can be done using rexx.


that's why I said: or write a small rexx to do the job...

Wink
Back to top
View user's profile Send private message
Veera
Moderator


Joined: 22 Feb 2006
Posts: 111

PostPosted: Thu Apr 12, 2007 1:37 am    Post subject: Reply with quote

acevedo ->

Yes i accept what you said is correct. Using REXX it can be done.My Intention of quoting reg the LISTCAT was i taught there is a way to
hadnle using it nothing else Smile

Well seagreg,

Here is the code for acheving what you have asked for using REXX.

Before that few points to be noted , as i made few assimptions and coded
the REXX routine.

1. I took curr-year and curr-date as refrence.

2. When ever the file-year and file-date are less than the curr-year and
curr-date i have displayed CALL SORT ROUTINE FOR THE FILE else the
file will be skipped.

3. SO what ever process you want to do after selecting the file can be
done using a function/routine where the display CALL SORT ROUTINE
FOR THE FILE is presnet.

Do get back to us if in case of any queries.

Code:


/**************************REXX***************************************/         
/*  THIS ROUTINE WILL CHECK THE FILE CREATION DATE AND COMPARES      */         
/*  WITH THE CURRENT DATE AND THEN VALIDATES WHETHER THE FILE        */         
/*  HAS TO BE PICKED FOR THE FURTHER PROCESSING.                     */         
/*********************************************************************/         
GDGBASE='ABCD.TEST.LIST.*' -> HERE I/P THE GDG BASE FILE                                           
FCCYYDDD = 0                                                                   
FILEYEAR = 0                                                                   
FILEDATE = 0                                                                   
CURRDATE = 0                                                                   
CURRYEAR = 0                                                                   
DSN      = ' '                                                                 
FNAME    = ' '                                                                 
ADDRESS ISPEXEC "LMDINIT LISTID(LISTID) LEVEL("GDGBASE")"                       
ADDRESS ISPEXEC "LMDLIST LISTID("LISTID") OPTION(LIST) DATASET(DSN)"           
RC_LMDLIST = RC                                                                 
DO WHILE(RC_LMDLIST = 0)                                                       
   SAY 'DSN : ' DSN                                                             
   FNAME = DSN                                                                 
CURRDATE = DATE('DAYS')                                                         
CURRYEAR = SUBSTR(DATE('STANDARD'),1,4)                                         
DSNINFO  = LISTDSI("'"FNAME"'")                                                 
   DO                                                                           
      IF  DSNINFO == 0 THEN                                                     
            SAY ' DATASET CREATED DATE ' SYSCREATE                             
      ELSE                                                                     
            NOP                                                                 
   END                                                                         
            FCCYYDDD = SYSCREATE                                               
            FILEYEAR = SUBSTR(FCCYYDDD, 1,4)                                   
            FILEDATE = SUBSTR(FCCYYDDD, 6,3)                                   
            SAY ' DATASET CREATED YEAR ' FILEYEAR                               
            SAY ' DATASER CREATED DATE ' FILEDATE                               
            SAY ' CURENT YEAR          ' CURRYEAR                               
            SAY ' CURRENT DATE         ' CURRDATE                               
      IF FILEYEAR <= CURRYEAR & FILEDATE <= CURRDATE THEN                       
          SAY ' CALL SORT ROUTINE FOR THE FILE '                               
      ELSE                                                                     
          SAY ' CALL SORT ROUTINE SKIPPED      '                               
ADDRESS ISPEXEC "LMDLIST LISTID("LISTID") OPTION(LIST) DATASET(DSN)"           
RC_LMDLIST = RC                                                                 
END                                                                             
ADDRESS ISPEXEC "LMDFREE LISTID("LISTID")"                                     



Thanks,
Veera.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> JCL All times are GMT + 5 Hours
Page 1 of 1



 
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

Related topics
 Topics   Replies   Author   Views   Last Post 
No new posts Trying to delete/define a VSAm, but VSAM is in use 10 Dr_Halo 1842 Sat Mar 21, 2009 8:14 am
Anuj Dhawan View latest post
No new posts Hi while trying to copy a flat file to KSDS VSAM file , an e 1 SUBARNA ROY 3831 Sat Jun 21, 2008 2:29 pm
MikeJ024 View latest post
No new posts How to find out the record length using tso command? 4 bsriram 9119 Fri Oct 26, 2007 12:17 am
varun View latest post
No new posts VSAM 1 goalchi27 3268 Wed Mar 21, 2007 6:35 pm
muraligaru1 View latest post
No new posts Verify command. 3 arrbee 2890 Thu Mar 09, 2006 7:48 pm
arrbee View latest post
 



This widget requires Flash Player 9 or better








Go to top of the page
 

Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  DB2 INTERVIEW QUESTIONS ||  COBOL INTERVIEW QUESTIONS  ||  JCL INTERVIEW QUESTIONS ||  JCL2 INTERVIEW QUESTIONS ||  VSAM INTERVIEW QUESTIONS ||  CICS INTERVIEW QUESTIONS  ||  Online tutorials ||  Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap  ||  Expeditor Tutorial  ||  FILE-AID Tutorial  ||  Changeman Tutorial  ||  COBOL   ||  DB2   ||  JCL  ||  CICS  ||  VSAM  ||  DB2 Interview Questions ( 110 )   || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1 ;|| Mainframe Forum - Tutorials  || Mainframe Tutorials

Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Powered by phpBB