The database stub edit spreadsheet

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: This default can be overridden by explicitly associating a xls editor under Applications Preferences (See Changing preferences and, specifically, Applications).

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 subsequent rows contain the respective values.

  • Any value that you select in the spreadsheet can be edited.
  • A new column can be added 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 entering values for each row.
    Note: The type name must be in parentheses. For example: NEW_COL (VARCHAR(20)).
  • An existing column's name or type cannot be modified.
Note: If you select to edit the contents of multiple tables for simultaneous editing, each table is on a separate page.

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 (result code is 0 by default)
  • Result Set 1, Result Set 2, and so on: The pages are present if the stored procedure returns result sets. The first row contains the column names and subsequent rows contain the respective 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.
Feedback