Joined: 24 Mar 2010 Posts: 3 Topics: 1 Location: DC
Posted: Thu Mar 25, 2010 4:09 pm Post subject: Syncsort report using multiple input files
Hi All,
I am trying to generate a report using DFSORT/SYNCSORT in one sort step but having problems to get it all in one step. The other alternative is to write Easytrieve or COBOL but that will take lot of lines code.
I am pretty much sure that this possible using DFSORT and need an expert assistance to accomplish the same.
INPUT files
1) 4 inputs files with record length 80 bytes. Say one for VSAM records, second for DB2 records, 3rd for match records, 4th for mismatch records
OUTOUT report (80 Byte) will contain
1 Create a report header
2 Print whatever is input file 3 to output (in below example missing data is being reported)
3 Get the count of all the input files and put a trailer report of TOTAL COUNT SUMMARY
For example[code:1:cf20bae6a6]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
*
*
* M I S S I N G
*
* D A T A
* R E P O R T
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Thu Mar 25, 2010 4:24 pm Post subject: Re: DFSORT report using multiple input files
Navino wrote:
Hi All,
I am trying to generate a report using DFSORT/SYNCSORT in one sort step but having problems to get it all in one step.
We do not have ICETOOL/ICEMAN in our current TSO environment neither do we have authorization to install one. So please do not give any suggestion related to these. It will be of no use to me.
Thanks you!
Navino,
ICEMAN and ICETOOL are part of DFSORT. If you don't need a solution using them , then you will NOT be provided a solution with DFSORT. _________________ Kolusu
www.linkedin.com/in/kolusu
Joined: 24 Mar 2010 Posts: 3 Topics: 1 Location: DC
Posted: Thu Mar 25, 2010 4:40 pm Post subject:
Thanks Kolusu for your concern!
Currently we use the version
V=IBM P=DFSORT UTILITY R=V1R14 I=DFSORT.
I am not sure if ICEMAN or is ICETOOL is a part of the package. But when try to take help using TSO qw command for ICETOOL or ICEMAN, it does not shows me any product.
When I use help using TSO QW DFSORT, I can see that they have mentioned ICEMAN once for EXEC, I do not see ICETOOL at all.
You will need to guide me cause I do not see much help on the TSO.
Also I am not sure if SORT in used in exec, does it try to find the best fit in the backend say it may use DFSORT or SYNSORT or ICEMAN, or is it the syntax in DD statements which it tries to use to identify the utility.
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Thu Mar 25, 2010 4:58 pm Post subject:
Navino wrote:
But when try to take help using TSO qw command for ICETOOL or ICEMAN, it does not shows me any product. mentioned ICEMAN once for EXEC, I do not see ICETOOL at all.
You will need to guide me cause I do not see much help on the TSO.
QW is NOT a standard TSO utility/command. It is a third party software from Chicago-soft and this third party tools never keep up with the latest info from DFSORT.
Quote:
Currently we use the version
V=IBM P=DFSORT UTILITY R=V1R14 I=DFSORT.
Where did you pick this information? From QW ?
Run the following job and show me the entire sysout so that we can determine which level of DFSORT functions you have available and accordingly provide the solution.
Joined: 24 Mar 2010 Posts: 3 Topics: 1 Location: DC
Posted: Fri Mar 26, 2010 8:39 am Post subject:
Yes, I picked the information using help QW.
Ran the job as you said and the sysout is
Code:
___________________________________
SYNCSORT FOR Z/OS 1.3.2.1N U.S. PATENTS: 4210961, 5117495 (C) 2007 SYNCSORT INC. DATE=2010/085 TIME=09.05.44
zNALC 1.11.0 SYNCSORT LICENSED FOR CPU SERIAL NUMBER XXXXX, MODEL 2097 707 LICENSE/PRODUCT EXPIRATION DATE: 09 MAY 2010
SYSIN :
SORT FIELDS=COPY
END
WER276B SYSDIAG= 2661021, 13719006, 13719006, 12541650
WER164B 6,896K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 20K BYTES RESERVE REQUESTED, 424K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=F ; LRECL= 80; BLKSIZE= 80
WER110I SORTOUT : RECFM=F ; LRECL= 80; BLKSIZE= 80
WER410B 5,868K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
WER410B 0 BYTES RESERVE REQUESTED, 308K BYTES USED
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
WER416B BSAM WAS USED FOR SORTIN
WER416B BSAM WAS USED FOR SORTOUT
WER054I RCD IN 1, OUT 1
WER169I RELEASE 1.3 BATCH 0477 TPF LEVEL 2.1
WER052I END SYNCSORT - VTSGSIN,SORT001,,DIAG=EA00,6046,C280,00CE,A27E,4CCB,8288,8464
______________________________________________________________
The only way to distinguish the file is: what ever dataset is in the 3rd DD of
SORTIN should be printed to output. All the processing has already been done in earlier
steps to identify the VSAM/DB2/Matched/New records files etc.
______________________________________________________________
Just a little more back ground:I was able to achieve the output report in minimum 6 steps
earlier. One step to get the header printed in the file. 4 steps to get the counts from the input
files to output file in Mod, CATLG. Final step to merge the header/3rd file and the trailer
counts.
Later I read one of your article that the 4 steps can to get counts can be done
in one step by putting an identifier in the DD statements and using INREC/OVERLAY.
But the report was getting created in horizontal fashion.
Example
VSAM DB2 Match New rec
00000000 90000000 9000000 00000001
My requirements were to put it in vertical manner. I read the DFSORT manual for new features
and was astonished to see so many new features for reporting.
I tried wortking on it and was lost because I could not figure out
how to use BuILD instead of OVERLAY as overlay works only for columns.
One thing is for sure: that all what I am trying to do, can be done on one step alone.
It is just basic reporting functionality: Create Header,put data and create trailer.
Thanks you for your patience to read the back ground!
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Fri Mar 26, 2010 10:32 am Post subject:
Navino,
Your Error messages indicate you are using syncsort. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
Quote:
Just a little more back ground:I was able to achieve the output report in minimum 6 steps earlier. One step to get the header printed in the file. 4 steps to get the counts from the input files to output file in Mod, CATLG. Final step to merge the header/3rd file and the trailer counts.
Btw just for your info it can be done is just 2 steps. 1 step to create header to distinguish records and 1 step to perform all you wanted _________________ Kolusu
www.linkedin.com/in/kolusu
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
