|
|
|
|
|
This is a technical parameter that specifies how your queries interact with other transactions being run on your database server. This parameter is relevant only if you are querying a database that is being updated at the same time you are running queries. Committed Read (the default) means you see only rows that have been committed. UnCommitted Read means you see rows even if they have not been committed.
This parameter is mainly useful for DB2. With Committed Read a query will take "read locks" and can hang while running against a table which is being updated. In this type of environment, it is recommended that Uncommitted Read is used.
Uncommitted Read is not available on all databases, and if that is the case Uncommitted Read will be ignored if specified.
This option gives the maximum columns in a table or query. The default is 500. You may wish to increase this number if you deal with tables that have a large number of columns.
This specfies the maximum number of tables that you can have in the Query Builder. The default is 30. You may wish to increase this number if you build queries with a large number of tables.
Warning:
These parameters affects how much memory AQT uses for holding table and column information:
If you increase these values, AQT can use a lot more memory. Do not increase these settings without good reason.
If you change these settings, AQT will reinitialise a number of memory areas. A number of functions in AQT may then not work properly until you stop and restart AQT.
When this option is specified, AQT will automatically terminate a database connection if you have not used it for the specified period. Your system administrator may ask you to set this option, as it will prevent unused connections from holding resources on your database server.
You specify the disconnect period in minutes. Setting the period to zero will disable this feature (sessions will not time out).
If you change this option during an AQT session, the value will come into effect immediately except when changing it from zero to a non-zero amount (this will only come into effect the next time you sign onto a database).
If AQT terminates your connection, you can reestablish it by (from the Database Explorer window) going File > Reconnect to <database>.
This is a technical issue that is discussed more fully in Running Code-Blocks in Sybase and SQL Server. This option is not saved between AQT sessions.
With this selected (the default), all SQL statements will be committed as soon as they have been run. If this option is set off, AQT will enter Transaction mode as soon as you have signed on to a database; changes will only be committed once you explicitly do a Commit.
By default, when AQT gets an error fetching your data from the database, it will stop. In some circumstances you might wish it to ignore such errors and continue getting data from the database. This is useful if you have some bad data in a row (such as an invalid timestamp) that is preventing a table from being displayed.
When this options is specified, AQT will add the following clause to the end all Select statements run against a DB2 server. This applies for DB2/UDB, DB2 z/OS and DB2/400:
Fetch First x Rows Only Optimize For x Rows
where x is:
If this option is not selected, the DB2 ODBC Driver will add its own Fetch First x Rows Only Optimize For x Rows clause. The value used for x will be a very high value, irrespective of what AQT has told it (via ODBC) about the number of rows to fetch.
When AQT adds this clause, it is mixed sentence case (as above); when the DB2 ODBC Driver adds this clause it is in upper case. This helps you determine (If you are running a trace or system monitor) whether it is AQT or the ODBC Driver which has added this clause.
Specifying this option can significantly improve performance when running against DB2 z/OS.
This clause will not be added if:
When this option is specified, AQT will issue a set rowcount command to limit the query results to the correct number of rows. This can give a significant performance improvement when accessing large tables. It is recommended that this option is selected. For more detail on this see Rowcount for SQL Server and Sybase.
For Sybase, this option will only work if the Sybase ODBC Datasource has been configured to have Select Method of 1-Direct.
AQT will not use Set Rowcount if you have specified Enable Get More Rows feature.
When this is specified, AQT will add a Limit x clause to the end all Select statements run against either a PostgreSQL or MySQL database (x is as describe above). This is useful if you are accessing large tables ij either of these databases.
AQT will not do this if:
It is recommended that this option is selected. You should only de-select this in special circumstances, such as using the DB2 z/OS Resource Limit Facility.
This option will have no effect if you specify Use SQLExecDirect.
A technical description of this parameter is as follows. AQT runs a query by doing a Prepare then an Execute. The Prepare sends the query to the database for parsing; the Execute actually runs the query. To minimize the interaction with the database, many ODBC Drivers do not pass the Prepare to the database, but wait till the Execute is done; it then passes both the Prepare and Execute to the database in one interaction. This is known as Deferred Prepare. However, there are some occasions when you actually want the Prepare to be sent to the database; in order to do this one needs to disable Deferred Prepare. Functions which this applies to are:
We have sometimes found that Oracle gives an error when your SQL contains carriage-return + linefeed as your newline character. To deal with this, AQT replaces all occurrences of carriage-return + linefeed in your SQL with a linefeed.
This option is on be default. If you do not want AQT to do this replacement, de-select this option.
Use this option if you need to switch on an ODBC Trace. ONLY do this if requested by Support at Cardett Associates to diagnose a problem. The ODBC trace is written by the Microsoft ODBC Driver Manager (not by AQT).
\sql.log even though you specified it as c:\sql.log. The Microsoft ODBC Driver Manager is responsible for this (so don't report it to us as a problem! :))Make sure you switch the ODBC Trace off after you have finished with it, or AQT will run very slow!
This is a technical option that should only be used on advice from Cardett Associates.
By default, AQT runs a query by issuing the following ODBC calls: SQLPrepare then SQLExec. If this option is selected, AQT will use an alternate method, which is to run an SQLExecDirect only. For most databases, both methods work equally well, except:
SQLExecDirect cannot be used if your SQL contains a parameter marker. AQT will check your query for parameter markers - if it finds one it will use SQLPrepare/SQLExec rather than SQLExecDirect.
When this option is in effect, Safe Update Mode will not be in effect. We plan on removing this limitation in future releases of AQT.
This is a technical option that should only be used on advice from Cardett Associates. It can be useful if you're having trouble displaying some data, in particular, invalid timestamps (which can happen in Oracle).
When fetching data from your database, AQT maps your database columns to variables of a similar type on your PC; for instance numeric columns are mapped to numeric fields on your PC, timestamp columns are mapped to the PC date/time structure. If your database has invalid data in a column, the ODBC Driver will not be able to deliver the data to the AQT and you will not be able to display your data.
By setting this option, AQT will map all database columns to strings in AQT; this provides a more reliable way of displaying your data, however AQT will not be able to format the numeric and timestamp columns.
This is a technical option that should only be used on advice from Cardett Associates. This gets the data from the database one value at a time, rather than one row at a time (which is the way AQT normally works). In some rare cases this can be a more reliable way of displaying your data, though it will be slower.