# adding a new field **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Adabas, Adabas-on-Linux, Adabas-Utilities-on-Open-Systems\ **Created:** [June 28, 2007, 6:24pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899 "2007-06-28T18:24:53Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Andrea](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Andrea](https://techcommunity.softwareag.com/u/Andrea)\ **Post date:** [June 28, 2007, 6:24pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/1 "2007-06-28T18:24:53Z")
I need to add a new field to an existing file. The specs state that it is a descriptor (D). I know to add a regular new field I would use ADADBM, but the book says to give it a descriptor status I need to use ADAINV. Do I add the new field using ADADBM then use ADAINV to make it a descriptor (D)? I don’t work with the database very often and the former DBA didn’t leave any notes on how to perform this task. Thank you. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [June 29, 2007, 1:39pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/2 "2007-06-29T13:39:57Z")
Yes, that’s exactly the sequence - ADADBM ADD\_FIELDS - ADAINV INVERT ---
**Author:** ![Andrea](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Andrea](https://techcommunity.softwareag.com/u/Andrea)\ **Post date:** [June 29, 2007, 9:44pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/3 "2007-06-29T21:44:54Z")
I thought so. Thanks for the quick reply. Andrea ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [July 3, 2007, 8:26pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/4 "2007-07-03T20:26:49Z")
If your new field is to be defined with NU or NC option, you can also add the field as descriptor without ADAINV, e.g.: adadbm db=33 add\_fields=21 1,xx,32,a,nu,de end\_of\_fields Wolfgang ---
**Author:** ![Andrea](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Andrea](https://techcommunity.softwareag.com/u/Andrea)\ **Post date:** [August 7, 2007, 12:10am UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/5 "2007-08-07T00:10:57Z")
We are about to make this change in our production environment. Do I have to have the file exclusively to add this field? Or, can I add the field while users are using the file? Thank you. ---
**Author:** ![Andrea](https://avatars.discourse-cdn.com/v4/letter/a/c37758/32.png) [@Andrea](https://techcommunity.softwareag.com/u/Andrea)\ **Post date:** [August 16, 2007, 5:38pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/6 "2007-08-16T17:38:16Z")
Does anybody know if I can make this change while the file is being used or do I need it exclusively? It is a 24/7 system so if I need it exclusively, I have to try to schedule a downtime. Thank you. ---
**Author:** ![yelena](https://avatars.discourse-cdn.com/v4/letter/y/7feea3/32.png) [@yelena](https://techcommunity.softwareag.com/u/yelena)\ **Post date:** [August 16, 2007, 8:23pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/7 "2007-08-16T20:23:20Z")
Andrea, I had exactly the same problem two days ago. I needed to add the field in Production and kept getting error messages from executing ADADBM with response code 3048 File / UserID not available at open time. I waited and did it later in the evening without any problems and without bringing system down. Thanks Yelena ---
**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\ **Post date:** [August 16, 2007, 9:35pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/8 "2007-08-16T21:35:35Z")
you would need the file exclusively while the utility runs, which is why Yelena was getting response code 48’s until the file was available to be locked. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 2:48pm UTC](https://techcommunity.softwareag.com/t/adding-a-new-field/74899/9 "2021-04-02T14:48:29Z")