G. Features Introduced in Ingres 9.0 (Ingres 2006) : Changes to Existing Features : VDBA Enhancements : Visual SQL
 
Share this page                  
Visual SQL
The new stand-alone executable (vdbasql) for Visual SQL displays the following window.
This window allows all the functionality of the previous SQL/Test window in VDBA, but has the following additional toolbar controls:
New combo-boxes for choosing a node, server class, and impersonated user. (The equivalent function is provided in VDBA through the branch chosen in the nodes tree when launching an SQL/Test window.)
A Commit button that allows you to directly commit the current transaction without the need to type commit in the query area.
An Options button that provides access to the properties of the SQL Test control. (This is equivalent to the SQL/Test Preferences in previous VDBA releases, plus the session timeout parameter that was global to VDBA.)
In addition, the status bar now provides the autocommit state of the transaction.