I have a .mas file of a Stored procedure having 2 varaibles of length of size A32671V (Both Usage & Actual).When i access this Stored Procedure through a fex file i get the following error (FOC336) THE SUM OF ALL FIELD LENGTHS EXCEEDS MAXIMUM reducing the field lengths in the Database is not possible as they are required. How can this be fixed so that i get the report outputs going??This message has been edited. Last edited by: Kerry,
7.6.4 Unix & Windows Excel,HTML,PDF,PPT,AHTML
March 23, 2009, 06:24 AM
GamP
As far as I know, the maximum length of all fields together in any data structure (ie master file) can not exceed 32 KB. So, what you want one master file to contains (over 64 KB of data) is just not possible. Lower the fieldlengths in the master, not in the database, and see what happens.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
March 24, 2009, 05:53 PM
Waz
WebFOCUS does not handle CLOB's very well
Depending on what you need to do, to could change the fields to TX type, not sure about having two though.
