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
 

 

Hardcoding Empty file using DFSORT or ICETOOl

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

New User


Joined: 06 Mar 2006
Posts: 76
Location: Chennai

PostPosted: Wed Jun 21, 2006 12:53 pm    Post subject: Hardcoding Empty file using DFSORT or ICETOOl
Reply with quote

Hi,

I am facing problem in hardcoding empty file( ie file without any records). I have requirement , i need to populate something into an empty file.

I am using ICETOOL or SORT to do so. But it is not working. Again the empty file is being getting created.

For eg:

Input: Empty file.

I expect output should be:

claims record count = 0
claims detail count - 0

only the above 2 records i need to write into output file. Is there any way to do using ICETOOL or DFSORT?

I tried with the following control card thats not working.

Code:

//TOOLIN   DD *
  COPY FROM(UT01) TO(UT11) USING(CT01)
/*
//CT01CNTL DD *
  SORT FIELDS=COPY
  OUTREC FIELDS=(C'claims record count = 0')
Back to top
View user's profile Send private message

IQofaGerbil

Active User


Joined: 05 May 2006
Posts: 183
Location: Scotland

PostPosted: Wed Jun 21, 2006 6:02 pm    Post subject: Re: Hardcoding Empty file using DFSORT or ICETOOl
Reply with quote

You could use

Code:

//S02SRT1  EXEC PGM=SORT                                         
//SYSOUT DD SYSOUT=*
//SORTIN   DD *                                                   
claims record count = 0
claims detail count - 0
//SYSIN    DD *                                                   
   SORT FIELDS=(COPY) 
//SORTOUT DD DSN=your.output.file,DISP=SHR
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: Wed Jun 21, 2006 8:28 pm    Post subject:
Reply with quote

Quote:
Is there any way to do using ICETOOL or DFSORT?

I tried with the following control card thats not working.


Yes, there are several ways to do it with DFSORT or DFSORT's ICETOOL, but you haven't given us enough information to tell you how to do it. Telling us it's not working doesn't give us any information since you didn't show your complete job or the error messages you received.

What RECFM and LRECL do you want for your output data set? IQ's job will work if you want RECFM=FB and LRECL=80 and can be adapted to other attributes, as can your own job. But you need to provide more details if you want more specific help.
Back to top
View user's profile Send private message
noorkh

New User


Joined: 06 Mar 2006
Posts: 76
Location: Chennai

PostPosted: Thu Jun 22, 2006 7:39 pm    Post subject: Re: Hardcoding Empty file using DFSORT or ICETOOl
Reply with quote

Hi Frank and IQ,

Thanks for your reply.

I got the answer from my colleague.

Once again thank you.
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 Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
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


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