The ScanSQL form
The ScanSQL program is a database tool developed for WorkZone administrators and technicians for normal operations and maintenance. The program works directly into the Oracle database and thereby also circumvents all business logic and data consistency checks defined in WorkZone. All changes made using the ScanSQL program will be made directly into the Oracle database and cannot be undone, including updates that might damage or invalidate the database.
If you are unsure of the consequences of an update, do not implement the update.
Prerequisite:
- Working ODBC connection to the Oracle database(s) you want to connect to.
- User account on Oracle database with Admin rights.
Starting ScanSQL program
To open the ScanSQL form: In Windows, press Start and type ScanSQL. You can also press ALT+R in windows to open the Run window and type ScanSQL.
When the ScanSQLform is opened for the first time, you must select the database you want to connect to and then connect to the database with a user account that has sufficient database privileges.
The SjBase form
The SjBase form is opened from the ScanSQL form > Sjbase.
Note: You can also use the Oracle SQL Developer tool, which is included in a standard WorkZone installation and available on the WorkZone server.