I am using FOCUS Version 7.3 for generating reports in Mainframe.
In one of reports, i am getting the following message and a RC=08 (FOC36335) THE LENGTH OF A FIELD OR A CONSTANT BEYOND LIMITS
Any pointers for solving the problem will be appreciated.
TIAThis message has been edited. Last edited by: geet,
August 28, 2008, 08:42 AM
PBrightwell
Check to see if you have a defined or computed field without a semicolon at the end or missing an ending quote mark.
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes
August 28, 2008, 02:50 PM
Kerry
Hi geet,
Has this issue been resolved? If not, it is suggested that you open a case with Information Builders' Customer Support Services for further assistance, as we will need to know much more details. To open a case, you may either call at 1-800-736-6130, or access online at InfoResponse.
Hope this helps. Many thanks for Pat's input too.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.
September 05, 2008, 04:03 AM
geet
Thank You for your pointers!!but the issue is still not solved..and very confused...This message has been edited. Last edited by: geet,
September 05, 2008, 06:25 AM
GamP
Geet,
Please post the offending code here (place it between the code brackets so its stays readable) in order for us to try and come up with a rreason and/or solution for you. We really can't do much with just the fact that you get this message.
Hope this helps in understanding my problem better.
The message i see the spool is as follows: DCB USED WITH FILE HOLDGUR IS DCB=(RECFM=FB,LRECL=00035,BLKSIZE=00700) OFFLINE... SAVED... (FOC36335) THE LENGTH OF A FIELD OR A CONSTANT BEYOND LIMITS IN TODAYI
--Geet
September 05, 2008, 09:36 AM
GinnyJakes
quote:
-SET &NAME_COR = IF &SV EQ 'N' THEN -'ALL' - ELSE '-SET &NAME_HOLD_CO = IF 'N' EQ 'N' THEN -'ALL' - ELSE '-SET &NAME_COMPANY = IF 'Y' EQ 'N' THEN -'ALL' - ELSE '-SET &NAME_STATE = IF 'Y' EQ 'N' THEN -'ALL' - ELSE '-SET &GUR_NO = 0;
I'm not sure what your problem is but this looks really strange. Can you tell us what you are trying to do here?
Also please update your profile signature with your product suite, release, and platform.
I think Ginny is right with her observation that it looks a bit strange. You should put your code between the code brackets to avoid losing information. Since you get the message that the file has been saved, the error occurs somewhere after saving the file. Most probable cause are the set statements that Ginny indicated. They should read:
-SET &NAME_COR = IF &SV EQ 'N' THEN 'ALL'
- ELSE '<COR';
-SET &NAME_HOLD_CO = IF 'N' EQ 'N' THEN 'ALL'
- ELSE '<NAME_HOLD_CO';
-SET &NAME_COMPANY = IF 'Y' EQ 'N' THEN 'ALL'
- ELSE '<NAME_COMPANY';
-SET &NAME_STATE = IF 'Y' EQ 'N' THEN 'ALL'
- ELSE '<NAME_STATE';
The biggest problem in your originalk code is that a DM continuation line must start with a '-' sign, followed by at least one space and then the rest of the statement. In your case the 'ALL' was immediately following the '-', possibly causing the error. If correcting this does not help, then place a -EXIT at a line follwing the SAVE, run it and see if it still errors out. If not, replace the -EXIT line to a place a little further in the code and run. Use this method until the error occurs and you have found the problem.
Hope this helps ....
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
September 05, 2008, 10:22 AM
GinnyJakes
quote:
IF 'N' EQ 'N'
That's not all. What I meant is that it looks like this code was pasted from an ECHO output. Ususally folks would say IF &VAR EQ 'N'...
Also his original code looks like he is trying to set a variable to be a full line of code with a -SET.
Thank You for all your suggestions/replies. As suggested by GamP, by placing -EXIT at various points, i have finally pin pointed the place where the error is generated: