Some actions that are normally available when you are working
in an active connection are not available when you are working offline.
You can use saved connection information to:
- View the objects in a database (for example, schemas, tables,
views, or stored procedures)
- View database object properties
- Create and view an overview diagram
- Create objects
in a data development project
There are some actions that are not available when you are working
with an offline connection:
- Filtering or refreshing the Data Source Explorer view
- Sampling the contents of a database
- Dropping data objects from the Data Source Explorer
- Extracting,
loading, or editing data
- Running routines
- Deploying routines
to the same server
- Running SQL statements from the SQL builder or the SQL editor
- Generating
a complete return table definition for table user-defined functions
by using the New User-Defined Function wizard (an empty definition
is generated)
- Generating
a complete iterator declaration for SQLJ stored procedures by using
the New Stored Procedure wizard (no iteration declaration is generated)
- Viewing
Actual Cost or Visual Explain information from the New Stored Procedure
wizard or the New User-Defined Function wizard when you are creating
some types of routines
- Viewing
Visual Explain information from an SQL statement