1) I want to get a space between the seond date which is 06-JAN-10 and the count 000000450.
2) When in the sort card i use COUNT=(M11,LENGTH=9), it is giving me +1 of the record count, for example: if the record count is 499, it gives 450. And if i use COUNT-1=(M11,LENGTH=9), it is giving me -1 of the record count, for example: if the record count is 499 it gives me 498.
2) When in the sort card i use COUNT=(M11,LENGTH=9), it is giving me +1 of the record count, for example: if the record count is 499, it gives 450. And if i use COUNT-1=(M11,LENGTH=9), it is giving me -1 of the record count, for example: if the record count is 499 it gives me 498.
This I don't believe....Remember count will give count of all records including last record(here record with date etc in your case)....
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
2) When in the sort card i use COUNT=(M11,LENGTH=9), it is giving me +1 of the record count, for example: if the record count is 499, it gives 450. And if i use COUNT-1=(M11,LENGTH=9), it is giving me -1 of the record count, for example: if the record count is 499 it gives me 498.
Huh? COUNT will give you the count of the data records. The generated trailer record is NOT included in the count. If you have 499 input records, COUNT will give you 499 and COUNT-1 will give you 498.
If you need more help with this, show the //SYSOUT messages you received, and explain what it is you actually want for the count (number of data records, number of data records + 1, or what?).