In IDMS how to insert a new field if no filler left.

Madhusmita Swain · New User Joined: 24 Aug 2007 Posts: 2 Location: Bangalore

In one of the IDMS records, there is no filler left. if I have to add one more field. What can be done to increase the space in an already existing database entity?

dick scherrer · Posted: Mon Sep 17, 2007 8:42 pm

Hello Madhusmita Swain and welcome to the forums,

To add a new column to a table (with no remaining filler just makes it possibly more work) your first task will be to perform an impact analysis. You need to identify everywhere this table is used (both as a database and as an unloaded sequential file).

I'd suggest you talk with your DBAs for guidance on how structure changes are handled on your system.

Madhusmita Swain · New User Joined: 24 Aug 2007 Posts: 2 Location: Bangalore

Thanks Dick !!! For your suggestion.

dick scherrer · Posted: Wed Sep 19, 2007 8:30 pm

You're welcome