|
View previous topic :: View next topic
|
| Author |
Message |
keane
New User
Joined: 24 Jul 2006
Posts: 11
|
|
|
|
I need to write number of input records (count) into an output file. After searching this forum i got the following code.
//SYSIN DD *
SORT FILEDS=COPY
OUTFIL REMOVECC,
TRAILER1=(COUNT=(M11,LENGTH=9))
/*
But This is writing all the input records into output file along with count as trailer record. I just want one record output (only count) in the output file. |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| NODETAIL = Specifies that data records are not to be output for the reports produced for this OUTFIL group. |
|
| Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
|
|
Use NODETAIL in your control card.
| Code: |
OPTION COPY
OUTFIL NODETAIL,REMOVECC,
TRAILER1=('COUNT=',COUNT=(M11,LENGTH=09)) |
Thanks, |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Just for reference, it is also included in "DFSort Smart Tricks" paper now. |
|
| Back to top |
|
|
GaganGarg
Active User
Joined: 31 Mar 2010
Posts: 134
Location: India
|
|
|
|
Hi Anuj,
Can you please give the path for "DFSort Smart Tricks" paper that you mentioned so that i can read this?
Thanks |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
| Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
| Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
|
|
Nevermind,..
Dick Brenholtz's link is far more useful....
Thanks, |
|
| Back to top |
|
|
keane
New User
Joined: 24 Jul 2006
Posts: 11
|
|
|
|
All of you,
Thanks alot. It is working fine. |
|
| Back to top |
|
|
|
|
