Reg:DFSORT

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
abhishek.pradhan
Member
Posts: 11
Joined: Wed Nov 08, 2006 4:57 pm

Reg:DFSORT

Post by abhishek.pradhan » Wed Nov 08, 2006 5:06 pm

Hi,

The Senerio is:

I have a flat file of 400 record length and has 1000 record.
from the 13th col. th date and time starts. The date format is DD.MM.YYYY and time format is HH:MM:SS.

Now I want the Date and time in YYYYMMDD and HHMMSS format respectively, also the data present in the rest of the coloums (say col1 to col 12 and col 31st to 400)

please help me to wirte a SORT card for this..

its very urgent..

Regards
Abhishek

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Wed Nov 08, 2006 9:55 pm

Here's a DFSORT job that will do what you asked for:

Code: Select all

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file (FB/400)
//SORTOUT DD DSN=...  output file (FB/400)
//SYSIN    DD    *
   OPTION COPY
   INREC FIELDS=(1,12,
     19,4,16,2,13,2,23,2,26,2,29,2,
     31,370)
/*
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others