I have a database for monthly reporting which uses several lookup tables that are maintained by a key-user. These are tables with some 200 records each, mainly used to provide grouping-keys for reporting. I edit these tables with update/insert statements through command enter or by uploading complete files.
I really want the maintenance on these tables done by the key-user, preferably without her having to use SQL. For ORACLE I use a special tool which allows me to go directly in a table , edit a field and give a commit.
I know this request does make a potential mock-up of database integrity, but I have to accept this as the only workable solution in our company.
Does anyone know if this is possible with the standard toolset provided with DB2 UDB 7? (at the moment version 7.1)
(Control center, command center, etc) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com
I really want the maintenance on these tables done by the key-user, preferably without her having to use SQL. For ORACLE I use a special tool which allows me to go directly in a table , edit a field and give a commit.
I know this request does make a potential mock-up of database integrity, but I have to accept this as the only workable solution in our company.
Does anyone know if this is possible with the standard toolset provided with DB2 UDB 7? (at the moment version 7.1)
(Control center, command center, etc) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com