Focal Point
[SOLVED] All records in hold file not printing

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/215105612

August 21, 2009, 11:19 AM
tinamshorty
[SOLVED] All records in hold file not printing
[SOLVED] I am having an issue with a HOLD file that I created not getting all the records to print.
-WRITE RUNTRAIL RMXLRPT READ 1904 RECORDS & FOUND 952 ,
MATCHES. NO FOCUS ERRORS 0 | RPT LINES= 952

I have 1904 records in the file and if I simply do a PRINT *, I am only getting 952 records back in the output. There are no WHERE statements, no BY statements, and no DEFINES.
I run several programs prior to this one in the same JCL with some MATCHES and JOINS before this HOLD file is created, but I have cleared all JOINS before running this program, so I know I don't have a JOIN in effect when this program runs.
Without printing the code here, does anyone have any clue what might be happening?
I am running this with JCL on an z/OS 1.10 mainframe operating system.

This message has been edited. Last edited by: Kerry,


FOCUS for Mainframe 7.2
Windows and IBM Z9 Mainframe processor
FOCUS, Excel


August 21, 2009, 11:37 AM
GinnyJakes
Is anything off-column? That is, does anything look funny? It may be that your master doesn't completely match the data. Or you might need an LRECL parameter on your allocation. Or there might be special characters in a text field that is messing it up.

Hope this gives you some ideas.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
August 21, 2009, 11:41 AM
tinamshorty
Ginny,
Thanks for the suggestions. I will double check the master to the data in the HOLD file again. Nothing looks funny, but not all of the fields have data in them for each record. This doesn't seem to affect it though since some of the records that have missing data are printing.


FOCUS for Mainframe 7.2
Windows and IBM Z9 Mainframe processor
FOCUS, Excel


August 21, 2009, 12:45 PM
dhagen
if Ginny's suggestion does not work, add:
 SET FIXRETRIEVE=OFF  
before the print *.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
August 21, 2009, 01:17 PM
tinamshorty
Solved! Ginny, you hit right on with the master file. I had one extra byte at the end of the master file description that is not in the file itself. Once I fixed the master, all the records came out!
Thanks! I wish I would have asked sooner! I've been driving myself crazy with it!


FOCUS for Mainframe 7.2
Windows and IBM Z9 Mainframe processor
FOCUS, Excel


August 21, 2009, 02:48 PM
GinnyJakes
You're welcome. I been doing this for 25 years and in fact spent an hour with a novice user doing the same thing. Having an offset master can certainly produce some unexpected results. Big Grin

Another thing you can do in this predicament is do a CHECK FILE (available in Dev Studio from the virtual master directory). It will give you the total length of the fields in the master. Check that against what you think the actual record length is. Just another debugging tool.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
August 24, 2009, 04:24 AM
Danny-SRL
quote:

I have 1904 records in the file and if I simply do a PRINT *, I am only getting 952 records back in the output.

Notice that you were gtting exactly half of what you expected. This could have meant that FOCUS was showing you every other record (which, in fact it was). Hence a problem with the master file overlapping 2 records.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

August 25, 2009, 07:27 AM
tinamshorty
Ah, nice to know the why behind the fix! Thanks! Smiler


FOCUS for Mainframe 7.2
Windows and IBM Z9 Mainframe processor
FOCUS, Excel