<< Click to Display Table of Contents >>
Database options
Set options for database and SQL function list.
Use Options dialog launched by selecting [File] > [Options] menu.
General
Detect join condition automatically |
Automatically detect join conditions between tables. |
Use table information cached in the local system |
Save in local cache the table information received from the database at fist connection and use table information on local cache from the next. Confirm when using table information cached in the local system: show confirm message box when use table information on local cache. |
Get table information automatically when connecting to database server |
Get table information whenever connect to database. |
SQL Function List
Set up SQL function list file for each database vendor |
Set SQL function list file for each database vendor. Database vendor: select a database vendor. SQL function list file: SQL function list file |
Note
SQL function list file for database is used with query wizard. If not set it, the function names provided by JDBC Driver will be used. but, function name sometimes may not accurate.
example on SQL function list file.
ASCII REPLACE
SUM MIN
USER DUMP
SYSDATE LAST_DAY NEXT_DAY
Each function is separated by blank character(Space or Tab).
The file have four lines and the first line includes string functions, the second line includes math functions, the third line includes system functions, and the fourth line includes time functions.