 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| setting up a Holdmaster | Login/Join |
| Platinum Member |
Hello I am trying to dummy up a holdmaster, because we cant seem to save it under MVS. When I use this master I get an "OPEN ERROR CODE 188" FILE=IAAPO066, SUFFIX=FIX, DATASET='PIA.ANSRTDEC' SEGNAME=SEG01, SEGTYPE=S01,$ FIELDNAME=POLICYNUMBER, ALIAS=E01, FORMAT=A10, $ FIELDNAME=BASICPLANCOD, ALIAS=E02, FORMAT=A5, $ FIELDNAME=BASICRATESCA, ALIAS=E03, FORMAT=A1, $ FIELDNAME=RISSUEAGE, ALIAS=E04, FORMAT=I3, $ FIELDNAME=CFCURAMOUNT, ALIAS=E05, FORMAT=P14.2, $ FIELDNAME=PERIOD, ALIAS=E06, FORMAT=MT, $ Any Help Dan IBM Main Frame: MVS, FIX, VSAM Windows SQL WF 7.7 | ||
|
| Expert |
To save a HOLD master, have you tried allocating a permanent PDS with DDNAME HOLDMAST? As far as I recall, it shouldn't be one of the PDS's that are allocated under DDNAME MASTER. In the case of this hand-tooled HOLD Master, have you tried allocating the file in your JCL or online session instead of via the DATASET parameter in the Master? Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
Also, you need ACTUALs in your master. 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 | |||
|
| Virtuoso |
if I create a fixed format and master my dataset says something like FILE=IAAPO066, SUFFIX=FIX, DATASET= dir/mytextfile.txt,$ SEGNAME=SEG01, SEGTYPE=S01,$
| |||||||
|
| Platinum Member |
Ok I set up the master like this. Now the fex is working but the output looks screwed up here is below. FILE=IAAPO066, SUFFIX=FIX, DATASET='PIA.ANSRTJAN' SEGNAME=SEG01, SEGTYPE=S0, $ GROUPNAME=POLICYNUMBER, ALIAS=E01, USAGE=A10, ACTUAL=A10, $ FIELDNAME=BASICPLANCOD, ALIAS=E02, USAGE=A5, ACTUAL=A5, $ FIELDNAME=BASICRATESCA, ALIAS=E03, USAGE=A1, ACTUAL=A1, $ FIELDNAME=RISSUEAGE, ALIAS=E04, USAGE=I3, ACTUAL=I3, $ FIELDNAME=CFCURAMOUNT, ALIAS=E05, USAGE=P14.2, ACTUAL=P6, $ FIELDNAME=PERIOD, ALIAS=E06, USAGE=MT, ACTUAL=MT, $ POLICYNUMBER BASICPLANCOD BASICRATESCA RISSUEAGE CFCURAMOUNT PERIOD 1 1 *** 1800000.00 MAR 1 1 *** 1800000.00 MAY 1 1 *** 2300000.00 JAN 1 1 *** 2100000.00 DEC 1 1 *** 3200000.00 JAN 1 1 *** 2100000.00 NOV IBM Main Frame: MVS, FIX, VSAM Windows SQL WF 7.7 | |||
|
| Virtuoso |
I would say that the format (actual and/or usage) of the 3th and 4th field are not correct. If I see *** I guess it is the field rissueage. try to enlarge it to I6 (usage) and see if that helps
| |||||||
|
| Expert |
The ACTUAL needs to be the exact number on disk. Usually for integer, these will be I2, I4, or I8. Use an editor with HEX ON to verify the length of this column. The FORMAT number is the number of digits you want to display. And your report seems to be missing a field. There are 5 in the report and 6 in the master. Also, if you know the true length of each row in the file, you can do a CHECK FILE to make sure that the length of the fields in the master match the true length of the row. 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 | |||
|
| Platinum Member |
Here is the hex of the file. Im not sure what to make of it. 0901819871 FPA1 1 .........pÍ.àÍ.gÞ.:÷.... FFFFFFFFFF44CDCF4444F4440001000029734718A17E0000 09018198710067110000100000080000975C4597E4A10001 Dan IBM Main Frame: MVS, FIX, VSAM Windows SQL WF 7.7 | |||
|
| Expert |
If you haven't figured out how to save the HOLD masters in a PDS, then after you run the focexec that creates the HOLD file, add ?FF hold-file-name to see the columns and their formats. Unfortunately, neither ?FF not ? HOLD provide the ACTUAL - they just provide the USAGE. Certain environmental variables will change what get put in the HOLD file - SET HOLDLIST=PRINTONLY for example. As well, the format of the HOLD file is important - I issue SET HOLDFORMAT=ALPHA at the top of all my programs to make ALPHA the default HOLD type. Or you can code the HOLD statement as ON TABLE HOLD AS H001 FORMAT ALPHA. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
OK, The hold file was originally created without FORMAT ALPHA so everything is aligned on a full word (8 bytes) or half word boundary (4 bytes). (You are making remember things long forgotten!!!!). Anyway, that adjusts the lengths in the ACTUAL. Remember that I said that the ACTUAL has to exactly match the data. So, here is another attempt at your master: FILE=IAAPO066, SUFFIX=FIX, DATASET='PIA.ANSRTJAN' SEGNAME=SEG01, SEGTYPE=S0, $ GROUPNAME=POLICYNUMBER, ALIAS=E01, USAGE=A10, ACTUAL=A12, $ FIELDNAME=BASICPLANCOD, ALIAS=E02, USAGE=A5, ACTUAL=A8, $ FIELDNAME=BASICRATESCA, ALIAS=E03, USAGE=A1, ACTUAL=A4, $ FIELDNAME=RISSUEAGE, ALIAS=E04, USAGE=I3, ACTUAL=I4, $ FIELDNAME=CFCURAMOUNT, ALIAS=E05, USAGE=P14.2, ACTUAL=P8, $ FIELDNAME=PERIOD, ALIAS=E06, USAGE=MT, ACTUAL=MT, $ Try that and see what happens. Also, whatever happened to the original master created when this file was created? It is obviously a FOCUS hold file. 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 | |||
|
| Platinum Member |
THanks I will try that and let you know. As far as the original. I cant seem to DYNAM ALLOC the hold master. I get no errors but when I check to see if the master is in the data set it is not there. Dan IBM Main Frame: MVS, FIX, VSAM Windows SQL WF 7.7 | |||
|
| Expert |
it is possible that HOLDMAST is already allocated to a temp pds. Issue a DYNAM FREE before the DYNAM ALLOC. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
Well I succeeded in get a MASTER made. Ginny's master config was right except the MT actual was DATE. The holdmaster attempt this time create the file but didn't dump any thing into it. Thanks Dan IBM Main Frame: MVS, FIX, VSAM Windows SQL WF 7.7 | |||
|
| Expert |
Good news! My hair was getting grayer by the minute.  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 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |