Informix IDS - Database Specific Support

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the Informix IDS RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for an Informix IDS database. The first column list the structure and the object types. The actions column lists all actions that are associated with the object types and the last column shows all viewers that appear when selecting an object in the tree.

The screenshots illustrates the visual representation of the objects tree.

Object Type Actions Viewers Databases Create Database Databases Catalog Export Database, Drop Database, Rename Database   Tables Import Table Data, Create Table References, Tables Table Export Table, Import Table Data, Create Trigger, Alter Table, Create Index, Drop Table, Empty Table, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator1, Columns, DDL, Data, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers Columns   Columns Column   Column Indexes   Indexes Index Disable Index, Drop Index, Enable Index, Rename Index Columns, Index Triggers   Triggers Trigger Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor, Info SystemTables   SystemTables SystemTable Script: SELECT Columns, Data, Info, Row Count Views   Views View Create Trigger, Drop View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, DDL, Data, Indexes, Info, Row Count Triggers   Triggers Trigger Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor, Info Synonyms   Synonyms Synonym   Info Indexes   Indexes Index Disable Index, Drop Index, Enable Index, Rename Index Columns, Index Triggers   Triggers Trigger Disable Trigger, Drop Trigger, Enable Trigger Trigger Editor, Info Procedures Create Procedure Procedures Procedure Drop Procedure, Script: CALL Procedure Editor, Columns, Info SystemProcedures   System Procedures SystemProcedure   Columns, Info, Procedure Columns, Source Functions2 Create Function Functions Function Drop Function, Script: CALL Function Editor, Columns, Info SystemFunctions2   System Functions SystemFunction   Columns, Info, Source Sequences2 Create Sequence Sequences Sequence Drop Sequence, Rename Sequence Info DataTypes2   Collection Types, Distinct Types, Opaque Types Users   Users User   Info Roles   Roles Role Drop Role Info DBA   DBA ServerInfo   Server Info Sessions   Sessions Session   Disk I/O, Info, Locks Spaces   Chunks, Size, Spaces Space   Chunks, Info 1) DbVisualizer Personal 2) Version 9.0 and later

---