The database stub spreadsheet editor

You can edit the contents of a database stub by using the Edit Database Stub wizard. A spreadsheet editor is opened in which you can modify the stub. The editor contains information about how the spreadsheet is started and the spreadsheet format.

Spreadsheet editor

A temporary .xls file is created and the system default spreadsheet editor is started.
Note: The default spreadsheet editor can be overridden by explicitly associating a .xls editor under Applications Preferences. See Applications preferences.

Spreadsheet format

The spreadsheet can take two forms, which are based on the type of database information it represents:

Database table spreadsheet format

Each page represents a single table. The title of the page is the table name. The first row contains the column names and the format of the supported value in parenthesis. For example, the format of the value of the CTIME parameter is the TIMESTAMP, that is displayed along with the name in the column header as CTIME(TIMESTAMP) . The subsequent rows contain values of the parameter specified in the column header.

You can edit any value that you select in the spreadsheet. You can add a new column to the table by entering a new column name in the header cell and the database-type to be used for the column, and then by entering values for each row. You can enter the format of the value for the parameter name in parentheses. For example, NEW_COL (VARCHAR(20)).
Note: You cannot modify the column name or format of the value of an existing column.

If you select multiple tables for editing simultaneously, each table is opened in a separate page in the spreadsheet editor.

Database stored procedure spreadsheet format

The spreadsheet can contain the following pages:
  • Inbound parameters: The page contains the names of the inbound parameters on the first row. You can specify your own values on the second row.
  • Outbound parameters: The page contains the names of the outbound parameters and the result code on the first row. You can specify your own values on the second row. The default value of the result code is 0.
  • The pages are presented as Result Set 1, Result Set 2, and so on, if the stored procedure returns result sets. The first row contains the column names and subsequent rows contain the values.
  • A new result set can be added by adding a spreadsheet page, whose title is of the form Result Set <n>, where <n> is the new result set number.