iHOC Query Features

Multiple Database Configurations

iHOC Query has a robust set of features designed to help IT and Database professionals. One of the most attractive features of iHOC is its support of multiple database types and configurations. The screen shot below shows how simple it is to switch from one database to another:

The list above represents 4 different iSeries configurations, an SQL Server configuration, a MySQL Configuration, and an ODBC configuration. Changing connections from one database to the next is as simple as changing the selection in this box. There is no limit to the number of different configurations

SQL Execution

The intuitive user interface is at once pleasing and familiar, and primary operation couldn't be simpler! Select a database, enter your SQL, and press a button or a function key to execute. Results are displayed in the grid below and additional information is available in the status bar:

In the screen shot above you'll notice that the grid columns automatically expand to show the entire contents. No more manually resizing column widths! If you prefer to see more columns at one time, a click of a button will toggle this feature on and off. Once the data has been retrieved, iHOC really starts to shine.

Active Filtering

One of the most intriguing features of iHOC is the ability to apply data filters and column ordering locally once the data has been retrieved. This allows you to work with subsets of the retrieved data without altering the SQL and without a return trip to the database:

And the resulting display in iHOC:

Notice the view counter indicates that we are viewing a subset of the total records in the selection. Those records have not been deleted and can be made visible again, allowing you to apply another filter and compare results, etc.

Statistics

iHOC comes with a built-in statistics generator. Statistics can be easily displayed for any numeric field in the result grid:

Statistics are always applied to the currently visible rows, so statistics on subsets of data are easily achieved.

Data Export

iHOC allows the user to easily export either all rows or filtered rows. Supported formats include CSV, Tab Delimited, and Microsoft standard DataSet XML representation.

Additionally, results can be used to configure and generate MySQL style Dump Files including Drop Table, Create Table, and INSERT statements.

And the resulting Dump File:

The dump tool hs many options and can be easily used to transfer database structure from one platform to another, with or without data.

Standard External File Support

iHOC allows you to open and use .SQL files to execute queries. If you have already developed .SQL files in another program such as Operations Navigator, you should be able to use these queries in iHOC as well. Additionally, you can create and save .SQL files directly from iHOC.

Multiple Execution

iHOC will execute multiple query statements provided that each statement is terminated by a semi-colon. Additionally, the user may highlight and execute individual statements within a larger document or specify a starting point to begin execution.

Statement and Result Navigation

iHOC allows you to navigate previously executed statements and results. By using the familiar "Back" and "Forward" buttons, a user may recall previous statements and view their associated results. One may also navigate just the statements, leaving the current state of the results intact.

Database Explorer

iHOC provides a database explorer tool to allow you to easily see the Catalog Structure:

Explorer is currently only available for iSeries databases. Support for other database types is under development.