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

Hardcoding Empty file using DFSORT or ICETOOl


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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
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 Developer


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

PostPosted: Wed Jun 21, 2006 8:28 pm
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top