View previous topic :: View next topic
Author
Message
ranjan jha New User Joined: 13 May 2013Posts: 4 Location: india
In the below given code I'm getting proper header and proper trailer but data is missing. How can I use the OUTREC to desired output?
Code:
SORT FIELDS=(1,22,ZD,A)
OUTFIL FNAMES=TESTIN,LINES=45,
REMOVECC,NODETAIL,
HEADER2=(2:'ACCT NO',25:'NAME',50:'DATE: ',DATE,3/5:'AUTHOR:',
20:'RANJAN JHA'),
OUTREC=(2:1,21,24:29,19,80:X),
TRAILER1=(2:'SUMMARY FOR: ',DATE,3/,2:
'TOTAL VALUE OF FEE:',TOTAL=(16,5,ZD,EDIT=($I,IIT.TT)))
Back to top
Pandora-Box Global Moderator Joined: 07 Sep 2006Posts: 1592 Location: Andromeda Galaxy
Can you also show your input and expected output and the output you got within code tags?
Back to top
ranjan jha New User Joined: 13 May 2013Posts: 4 Location: india
input data
Code:
000001 201405890000000100000 MT101 < °
000002 201405890000000100001 0004199527034000500 40AD ð00000000
000003 201405890000000100002 0004199527034000500 40CD ð00000000
000004 201405890000000100003 0004199527034000500 41AD ð00000000
000005 201405890000000100004 0004199527034000500 09FM ð00000000
000006 201405890000000100005 0004199527034000500 41CD ð00000000
000007 201405890000000100006 0004199527034000500 09FM ð00000000
000008 201405890000000100007 0004199527034000526 Ø 40AD ð00000000
000009 201405890000000100008 0004199527034000526 40CD ð00000000
000010 201405890000000100009 0004199527034000526 41AD ð00000000
000011 201405890000000100010 0004199527034000526 09FM ð00000000
output coming
Code:
000001 ACCT NO NAME DATE: 04/29/14
000002
000003 AUTHOR: RANJAN JHA
000004 SUMMARY FOR: 04/29/14
000005
000006 TOTAL VALUE OF FEE:$5,601.30
output expected
Code:
000001 ACCT NO NAME DATE: 04/29/14
000002
000003 AUTHOR: RANJAN JHA
000002 201405890000000100001 0004199527034000500
000003 201405890000000100002 0004199527034000500
000004 201405890000000100003 0004199527034000500
000005 201405890000000100004 0004199527034000500
000006 201405890000000100005 0004199527034000500
000007 201405890000000100006 0004199527034000500
000008 201405890000000100007 0004199527034000526
000009 201405890000000100008 0004199527034000526
000010 201405890000000100009 0004199527034000526
000011 201405890000000100010 0004199527034000526
000012 201405890000000100011 0004199527034000526
000013 201405890000000100012 0004199527034000526
000014 201405890000000100013 0004199527034000526
000015 201405890000000100014 0004199527034000526
000004 SUMMARY FOR: 04/29/14
000005
000006 TOTAL VALUE OF FEE:$5,601.30
Back to top
Bill Woodger Moderator Emeritus Joined: 09 Mar 2011Posts: 7309 Location: Inside the Matrix
I suggest that you should understand what NODETAIL does before you use it.
Also, please don't use OUTFIL OUTREC, use OUTFIL BUILD instead. They are identical, but BUILD is much clearer (find references to OUTREC in the index for your manual, and then you'll see that it can mean completely different things). BUILD always means BUILD.
Back to top
ranjan jha New User Joined: 13 May 2013Posts: 4 Location: india
Thanks you Bill Woodger for your reply. now my sort is working.
Back to top
Please enable JavaScript!