editing data directly without SQL

[blom0344]

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

 

[desiindian]

Hi,

You could use command center. After writing a sql query, the result set can be changed and committed.

 

[blom0344]

I just ran a select script in command center using runtime client from a remote PC (version 7.1) . In the output I can set the cursor anywhere, but I can not change any data.
Is the functionality you mention something not supported by version 7.1 , only on version 7.2? T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[stoggers]

Hi,

In Command Centre enter you select in the 'Interactive' tab and the results will be displayed in tabular format on the 'Query Results' tab.

Regards,

Stoggers.

 

[blom0344]

Hello Stoggers,

I know the output of the query is being displayed, my concern is whether you can EDIT this without having to resort to SQL . Take a tool as TOAD, which lets you directly edit data in situ in the table itself. (But then for ORACLE)..... T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[stoggers]

Hi,

I have requently updated fields in the 'Query Results' grid display and committed them to the database.

With regard to the original problem, it may be possible to isolate the users from SQL by using a view or a stored procedure and then just let them edit the grid display.

If you wnat something more sophisticated then IBM does offer the 'Table Editor' which is almost an application generator. However, it is, I believe, a chargeable option. There is a time-limited download from IBM.COM if you are interested.

Regards,

Stoggers

 

[blom0344]

Hello Stoggers,

Aah, now this is starting to become interesting. I'll check the IBM site right away. Thanks. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[ummadhira]

It might be too late to answer this question. But I know you can use AQT(Advance query tool) like TOAD which you can get from

http://WWW.QUERYTOOLS.COM.

Tks
Uma

 

[blom0344]

Thanks ummadhira ,

I bought AQT for 50$ some years ago to evaluate its use. For the money it is quite a nice tool, but unlike TOAD you cannot use the datagrid to manually edit the contents of tables. This is the type of action I am looking for to isolate my user from having to run update SQL statements at this table. Quest software has Quest central for DB2 as the equivalent of their TOAD product, but it is also limited in this respect.........
The URL you suggest seems to no longer exist........ T. Blom
Information analyst
tbl@shimano-eu.com

 

[rbizley]

Try the tool called WinSQL. It works with DB2 and allows you to edit tables without having to code the statement. Find it here :

http://www.indus-soft.com/winsql/