IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Date and Time Display in SYNCSORT


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA

PostPosted: Thu Jul 25, 2013 5:55 pm
Reply with quote

Hi All ,

Code:
//SORT  EXEC PGM=SORT,REGION=5000K                     
//SYSPRINT DD  SYSOUT=*                                 
//SYSOUT   DD  SYSOUT=*                                 
//SORTIN   DD  DISP=SHR,DSN=SMF DATASET WITH TYPE 15 RECORDS
//SORTOUT  DD  DISP=(NEW,PASS),DSN=&&TEMP,             
//             SPACE=(CYL,(50,20),RLSE),DCB=*.SORTIN   
//SYSIN    DD   *                                       
   SORT FIELDS=COPY                                     
   INCLUDE COND=(6,1,BI,EQ,15,&,69,5,CH,EQ,             
                 C'WELLS')                             
/*                                                     
//JS020    EXEC PGM=ICETOOL                             
//TOOLMSG  DD SYSOUT=*                                 
//DFSMSG   DD SYSOUT=*                                 
//SMF15    DD DSN=&&TEMP,DISP=(OLD,DELETE,DELETE)       
//SMF15RPT DD SYSOUT=*                                 
//SYSOUT   DD SYSOUT=*                                 
//TOOLIN   DD *                                         
  DISPLAY FROM(SMF15) LIST(SMF15RPT) -                 
  TITLE('SMF TYPE-15 RECORDS') DATE(4MD/) -             
  HEADER('DATE') ON(11,4,DT1,E'9999/99/99') -           
  HEADER('CREATION TIME') ON(49,4,TM1,E'99:99:99') -   
  HEADER('SYS') ON(15,4,CH) -                           
  HEADER('JOBNAME') ON(19,8,CH) -                       
  HEADER('DATASETNAME') ON(69,44,CH)                   
/*                               


ibmmainframes.com/viewtopic.php?t=61181&postdays=0&postorder=asc&start=0
This is regardign one requirement which I have posted months back in forum and got good responses ..its about to fetch creation time of a datset from SMF record typ 15.. I got the above code by vasanthZ

Please refer the link I pasted if you need more details ..
Here my question is about the second step in above code
That code is intend to use DFSORT but I have limitations to use SYNCSORT only . Can some one please let me know how I would convert that above DFSORT to equavalent SYNCSORT code to achive the same results....

Thanks Much in Advance !!!
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Thu Jul 25, 2013 6:59 pm
Reply with quote

Possible solution updated here
ibmmainframes.com/viewtopic.php?t=61181&start=15
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Jul 25, 2013 7:02 pm
Reply with quote

What limitations are imposed when you run the code 'as is' - in other words, do you get some error, what is it?
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Thu Jul 25, 2013 7:04 pm
Reply with quote

What happened when you tried executing the above code?
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA

PostPosted: Thu Jul 25, 2013 7:05 pm
Reply with quote

Thanks Vasanthz ..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
No new posts Need to convert date format DFSORT/ICETOOL 20
Search our Forums:

Back to Top