>I need to programatically change the structure of a table which is part of a database of dbc. I am doing an update to an application and need to add a field while retaining the data in that table.

ALTER TABLE.

Better yet, look into StoneField Tools (www.stonefield.com) for a long term management solution.