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 Database Explorer view
- Sampling the contents of a database
- Dropping data objects from the Database 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
SQL Statement wizard (an empty 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