SQL-EDITOR

Editing and modifying an ON-LINE table

In the current use of DB2, it is noticeable that the existing application program does not cover all the requirements as regards data manipulation. Consultation, correction, test deck entries have not always been programed in the application programs. When such an operation presents itself, the only solution is to use ARIDBS on ISQL, which are very useful, but not very user-friendly.

The SQL-EDITOR software allows you to edit, ON-LINE, the contents of a table, by keying in only its name (no command is necessary).

The contents of the table are represented in the form of a spread sheet.
All the conventional functions of an editor are available for the user if he has display and modification authorizations.
SQL-EDITOR is very useful when setting up a test deck, as it enables one value in a column to be modified by simply keying in on the screen.
The implementation of a trace program allows you to list all the operations carried out on your base through SQL-EDITOR. You can retrieve the author of the updates, as well as the values before and after modifications.


SQL-EDITOR proposes a first screen. Just give the SQL signature and the name of the table to be edited.


zoom
 


zoom


SQL-EDITOR presents the contents of the table in the form of a spread sheet.


zoom


The area on the left allows you to suppress, add, recopy one or several rows.
Row or column intersection gives a display area which you can modify.
A function key enables you to record your modifications. All modifications on the table can be made without any command.