Home Home Screenshots Download Documentation Contact Licensing

Documentation: Aqua Data Studio 4.7     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Informix
  VII. PostgreSQL
  VIII. MySQL
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser & Scripting 
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Options
  VI. Settings
  Query Window
  I. Basics
  II. Shortcut Keys
  III. Toolbar
  IV. Server Side Comments
  V. SQL Automation
  VI. Variable Binding
  VII. Results
  VIII. Save Results
  IX. Auto-completion
  X. SQL Formatter
  XI. Permissions
  XII. Parameterized
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool

  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
Server Side Comments Aqua Data Studio supports client side and server side comments. Prior to version 3.5 ADS treated all comments as client side comments. Client side comments are comments which ADS removes from an SQL statement before executing (or sending) them on to the server database. Server side comments are comments which are executed (sent) to the server with the SQL statement. The reason for server side comments is to support comments stored in stored procedures. When creating stored procedures that include comments, ADS needs to include the comments in the SQL statement that is executed on the server. ADS supports 3 types of comments:


1: Block Comment -> /* Block Comment */
2: Line Comment -> -- Line Comment
3: Line Comment -> // Line Comment

 Aqua Data Studio Server Side Comments
ADS comments are configurable ... since different databases support different types of comments. In the options dialog box, a user may select each type of comment to be a client or server side comment per database. You may view what statement & comments will be executed on the server with an "Execute Parse" on a statement/script before executing. Below is a list of databases, what comment types they support and the default value for each database.

BBSSC: Block Server Side Comment
SSSSC: Slash Slash Server Side Comment
DDSSC: Dash Dash Server Side Comment

DB2 - 7.x/8.x DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: FALSE FALSE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE TRUE


Informix 9.3 DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE TRUE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE TRUE


MS SQL Server 2000 DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE TRUE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE TRUE


MS SQL Server 7 DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE TRUE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE TRUE


MySQL DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE FALSE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE FALSE


Oracle 8i/9i DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE TRUE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE TRUE


Postgresql DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE FALSE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE FALSE


Sybase Anywhere DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE TRUE
SSSSC: { // }: TRUE TRUE
DDSSC: { -- }: TRUE TRUE


Sybase DB SUPPORT ADS DEFAULT
BBSSC { /* */ }: TRUE TRUE
SSSSC: { // }: FALSE FALSE
DDSSC: { -- }: TRUE TRUE

Home • Screenshots • Downloads • Documentation • Support • Licensing Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved