Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Not enough filler clause left to declare database variable

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
chhabraravneet

New User


Joined: 04 Oct 2007
Posts: 49
Location: Mumbai

PostPosted: Wed Sep 21, 2011 1:44 pm    Post subject: Not enough filler clause left to declare database variable
Reply with quote

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?
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Wed Sep 21, 2011 2:26 pm    Post subject: Reply to: Not enough filler clause left to declare database
Reply with quote

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.
Back to top
View user's profile Send private message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Wed Sep 21, 2011 6:32 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Wed Sep 21, 2011 6:41 pm    Post subject: Reply to: Not enough filler clause left to declare database
Reply with quote

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 :-)
Back to top
View user's profile Send private message
chhabraravneet

New User


Joined: 04 Oct 2007
Posts: 49
Location: Mumbai

PostPosted: Sat Sep 24, 2011 2:25 am    Post subject:
Reply with quote

Thanks a lot for all your suggestions...
This was helpfull...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Can I traverse a STEM variable? chong.zhou CLIST & REXX 5 Wed May 31, 2017 3:54 pm
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Writing on to GSAM variable length rohanthengal JCL & VSAM 6 Fri Mar 03, 2017 7:46 pm
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us