Application to update a column in a table

General

Application to update a column in a table

Hi all,

I'm looking for a (desktop/web) application for users with no technical experiecne to update a column in a teradata table. I need a recurring function as there are multiple tables with same naming convention

Example:

Table 1: dbname.tbl_abc.cname1

Table2: dbname.tbl_bcdf.cname1

If the user selects abc and enters few parameters, they should be able to update cname1 in dbname.tbl_abc.cname1 

If the user selects bcdf and enters few parameters, they should be able to update cname1 in dbname.tbl_bcdf.cname1

Note: 1. Number of columns may vary from one table to another.

         2. Unique identifier can be different from one table to another. For first table the granularity is dbname.tbl_abc.id1, for second it               is dbname.tbl_bcdf.id1 and dbname.tbl_bcdf.id2

Any help will be appreciated.

Thanks,

Chin2