delete application group field

[Michel de Kraker]

Hi all

i accidently created a new field in an application group. Is it possible to remove this field from the application group?

Thx.

Michel.

[Justin Derrick]

I don't think CMOD has that functionality, although it appears that DB2 now supports 'alter table <table> drop column <column>' commands.

If it's a small group, consider exporting and re-importing into a new AG.  If it's a large AG, consider tweaking the database tables manually...  But that's not something that's either documented or supported -- so consider it at your own risk.

-JD.

[Michel de Kraker]

Ok thx JD

What i did:

copy AG (D111) to new name (D111.NEW) and delete field
update AG (D111) to new name (D111.15072013)
update D111.NEW back to D111 (so this has the original name. this was mandatory because supplying systems depend on that name)

updated the foldermappings offcourse to search data in D111.15072013 and D111.
Regards,

Michel.