View previous topic :: View next topic
|
Author |
Message |
dimebag
New User
Joined: 29 Mar 2007 Posts: 7 Location: Mexico
|
|
|
|
Is there any way of adding the file name into the header of the sort?.
I need to generate reports from diverse files using the same control cards and I want to use the file name like a param like DATE or TIME into the header |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Do you want the sort input dataset name to appear in the "data"?
When you run the sort, you will get a "new" dsn for the sortout. Is this related to the "header" file name?
What type of report are you gong to produce with sort?
If you post an example of your input and what you'd like for output we may be able to offer suggestions. |
|
Back to top |
|
|
dimebag
New User
Joined: 29 Mar 2007 Posts: 7 Location: Mexico
|
|
|
|
I want the input data set name into the header of the sort output.
I have different files with the same layout and I want to process them all together to produce a single report and also want to identify the source of the records.
I have 3 files for input:
FILE1
AA01
AA03
FILE2
AA02
BB03
FILE3
BB01
BB03
CC01
and I want something like this:
Code: |
'FILE1'
AA04
'FILE2'
AA02
BB03
'FILE3'
BB04
CC01
---------------
TOTAL AA06
BB07
CC01
|
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You will most likely have better(?) success if you write a program to do this.
If you search in the forum (COBOL, i believe) you will find code that retrieves the current dsn for the file being read. If you concatenate your input files and retrieve the dsn for each read, you will be able to create the report you describe as well as manage the totals you need. You will need to get the dsn each read to know when the dsn changes so it can be put in the "header". |
|
Back to top |
|
|
|