I am running some code where I have done a DYNAM ALLOC telling it FB and LRECL of 314 in an RPC. What I am getting instead is VB and LRECL of 318, however, when I look at the Dataset all I am seeing is 314. How can I get this to be the way I am defining it.
Here is the code. DYNAM ALLOC FILE MDCSYN DS WC.PROD.ADV.MDCSYN.TEMP - LRECL 314 RECFM FB SHR REU -RUN REMOTE DEST=EDADMPRD -REMOTE BEGIN SET HOLDLIST=PRINTONLY JOIN LEFT_OUTER MDCSYNTM.MDCSYNTM.CLM_NBR_ID IN MDCSYNTM TO UNIQUE WADVCLM.WADVCLM.CLM_KEY IN WADVCLM TAG J0 AS J0 END JOIN LEFT_OUTER J0.WADVCLM.POL_NBR_REN IN MDCSYNTM TO UNIQUE WPOLREN.T_POL_RE.POL_NBR_REN IN WPOLREN TAG J1 AS J1 END TABLE FILE MDCSYNTM PRINT MDCSYNTM.REC_TYP MDCSYNTM.FILL_1 COMPUTE TEMP/A8 = IF WPOLREN.POL_EFF_DATE EQ '00000000' THEN MDCSYNTM.POL_EFF_DATE ELSE DATECVT(WPOLREN.POL_EFF_DATE, 'YYMD', 'A8YYMD'); MDCSYNTM.CLM_NBR_ID MDCSYNTM.FILL_2 ON TABLE PCHOLD AS MDCSYN FORMAT ALPHA END -REMOTE ENDThis message has been edited. Last edited by: CraigR,
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)
September 21, 2010, 05:49 PM
Waz
So you DYNAM ALLOC to RECFM FB and LRECL 314, but it is allocates as VB and 318 ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 21, 2010, 06:09 PM
CraigR
Yes. I have an old version there that I am trying to replace with the new. It goes from the FB 314 to the VB 318
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)
September 21, 2010, 06:21 PM
Waz
Doesn't seem possible.
How did you find out that it had changed ?
I can only assume that it has something to do with the DYNAM command
The whole command can fit on one line, does that make a difference ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 22, 2010, 08:29 AM
CraigR
As impossible as it sounds, it did happen.
I found out it changed because I was trying to look at it and it warned me about data that may be dropped because of the variable block if I made changes to it. I then looked at its properties.
I copied a dataset that I had backed up earlier back into it and made sure it looked right (it did) and then ran the process again. Once again it had the wrong properties as I have noted.
I am also assuming it has something to do with the DYNAM command. I did try to put it all on one line to see if that would change anything. It didn't. I have it on two lines because the mainframe will cut it off at 80 characters if I don't do that.
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)
September 22, 2010, 05:47 PM
Waz
I think that you may have to put in a case with IBI on this one.
BY the way what type of DS is it PO or PDS ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
September 23, 2010, 03:45 AM
Tony A
Craig,
Going back a few years to my MVS days, this was often due to the fact that a DD statement existed in the JCL with the different attributes or the existing file was already allocated with those attributes. You can overcome the latter by deleting any existing file in an IEFBR14 step prior to your FOCUS process. If this is not batch but online, then you need to achieve the same thing using TSO DELETE (can't remember if this is the exact command you need as I haven't got my nineties Quick Reference card handy!).
DYNAM FREE and DYNAM ALLOC do not override the DDs in your JCL, however TSO FREE and TSO ALLOC used to. Whether this is still the case I cannot tell you as I do not have access to MVS/ZOS or whatever the current naming/version is!!
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
September 23, 2010, 12:56 PM
CraigR
I solved this problem by doing a local hold and then read it again with a save. We are suspecting that the problem may have had something to do with a line feed and carriage return (nothing to back this up)
Here is the code that I used instead.
DYNAM ALLOC FILE MDCSYN DS WC.PROD.ADV.MDCSYN.TEMP - LRECL 314 RECFM FB SHR REU -RUN REMOTE DEST=EDADMPRD -REMOTE BEGIN SET HOLDLIST=PRINTONLY JOIN LEFT_OUTER MDCSYNTM.MDCSYNTM.CLM_NBR_ID IN MDCSYNTM TO UNIQUE WADVCLM.WADVCLM.CLM_KEY IN WADVCLM TAG J0 AS J0 END JOIN LEFT_OUTER J0.WADVCLM.POL_NBR_REN IN MDCSYNTM TO UNIQUE WPOLREN.T_POL_RE.POL_NBR_REN IN WPOLREN TAG J1 AS J1 END TABLE FILE MDCSYNTM PRINT MDCSYNTM.REC_TYP MDCSYNTM.FILL_1 COMPUTE TEMP/A8 = IF WPOLREN.POL_EFF_DATE EQ '00000000' THEN MDCSYNTM.POL_EFF_DATE ELSE DATECVT(WPOLREN.POL_EFF_DATE, 'YYMD', 'A8YYMD'); MDCSYNTM.CLM_NBR_ID MDCSYNTM.FILL_2 ON TABLE PCHOLD AS SYNTMP END -REMOTE END -* TABLE FILE SYNTMP PRINT * ON TABLE SAVE AS MDCSYN END
WebFOCUS 7.6.10 Windows all output (Excel, HTML, PDF)