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 by 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