Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How can I identify whther the file is empty or not

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
rambabu
Currently Banned

New User


Joined: 18 Apr 2005
Posts: 67

PostPosted: Mon Jun 13, 2005 2:48 pm    Post subject: How can I identify whther the file is empty or not
Reply with quote

how can i identify whther the file is empty or not?u tell me in both cases vsam and flat file?
Back to top
View user's profile Send private message

ideas

New User


Joined: 25 May 2005
Posts: 53
Location: India

PostPosted: Mon Jun 13, 2005 3:01 pm    Post subject:
Reply with quote

use IDCAMS for this.
Back to top
View user's profile Send private message
Sangita

New User


Joined: 02 Jun 2005
Posts: 17

PostPosted: Mon Jun 13, 2005 4:21 pm    Post subject: Re: vsam file empty?
Reply with quote

Hi Ram,

You can use IDCAMS for the VSAM files or you check in the
DSLIST (3.4 OPT) ,%USED will be 0 for empty files.

Regards,
Sangita
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Jun 13, 2005 9:16 pm    Post subject:
Reply with quote

You could use DFSORT's ICETOOL to do that as described in this Smart DFSORT Trick:

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst03.html#t10
Back to top
View user's profile Send private message
ideas

New User


Joined: 25 May 2005
Posts: 53
Location: India

PostPosted: Wed Jun 15, 2005 6:27 pm    Post subject:
Reply with quote

Hi Frank & Ram,

this is the outline..how IDCAMS can be used:

Step 1: copy the file to a temp file using IDCAMS utility
If file empty this step may throw a RC 08,
Set MAXCC = 04, if it greater than 00.

Step 2: Check the condition, if the RC of previous step is NOT equal to 00, bypass the step.

Thanks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Formatting VB File Learncoholic DFSORT/ICETOOL 3 Mon Mar 20, 2017 12:29 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us