Checking for empty files

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

Moderators: Frank Yaeger, Moderator Group

Post Reply
meekhasingh
Member
Posts: 7
Joined: Mon Oct 20, 2008 2:07 pm
Location: India

Checking for empty files

Post by meekhasingh » Thu Oct 23, 2008 7:17 am

How do we check for empty files using sort card?

Thanks in advance
Meekha

User avatar
JACK
Member
Posts: 20
Joined: Mon Jan 30, 2006 6:18 am

DFSORT - ICETOOL - EMPTY FILE CHECK.

Post by JACK » Thu Oct 23, 2008 4:07 pm

Using ICETOOL, we can do this.

Code: Select all

//STEP1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=...
//TOOLIN DD *
COUNT FROM(IN) EMPTY
/*
This step return RC=12, if file IN is empty.

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

Post by Frank Yaeger » Thu Oct 23, 2008 8:23 pm

Meekha,

See the "Set RC=12 or RC=4 if file is empty, has more than n records,
etc" Smart DFSORT Trick at:

www.ibm.com/systems/support/storage/sof ... vs/tricks/
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