Not enough filler clause left to declare database variable

chhabraravneet · New User Joined: 04 Oct 2007 Posts: 49 Location: Mumbai

Hi,

Can anyone please suggest me something on the below issue?

I have declared a field in MFS, named "Deductible" of length X(6).

The input output copybook variables are:
PYI-DED X(6).
PYO-DED X(6).

Now i have a global database copybook,where i have to declare the database variable:
PYDB-DED X(6).

But in the database copybook i do not have enough FILLER clause left to declare a variable of length X(6). I have FILLER left only X(4).

I first thought to make the declaration as COMP-3, but this is not working. Can anybody please suggest something on this?

Bill Woodger · Posted: Wed Sep 21, 2011 2:26 pm

I think you'll need to talk to your technical support people or whoever looks after MFS.

Someone should have picked this up long before you actually ran out of space. Even if you shoe-horn six bytes into four bytes now, the next person along is going to be left dangling in the wind, and it might be you. Get it done properly now, with a locally-suggested solution from someone who knows the stuff if your requirement is "urgent". Make sure your boss knows about the problem. There should have been some procedure so that this did not get in the way of schedules, so now someone has to make a new one.

Ed Goodman · Active Member Joined: 08 Jun 2011 Posts: 556 Location: USA

You will need to ask the database admins to increase the size of the segment. Chances are there is a process in place already to do this.

Also, keep in mind that the MFS field and the database field are completely separate. One is where a user types something into a screen, the other is where you store a value.

I don't know what you mean when you said "this is not working". Chances are, the database fields are supposed to be defined by the same folks that maintain the databases. You have to keep the database copybooks and the database definitions in sync for the most part.

Bill Woodger · Posted: Wed Sep 21, 2011 6:41 pm

I meant a procedure to do it (at some convenient time evaluated by the amount of FILLER remaining) before running out of space, not a procedure to do it at all :-)

chhabraravneet · New User Joined: 04 Oct 2007 Posts: 49 Location: Mumbai

Thanks a lot for all your suggestions...
This was helpfull...