Connection
Edit connection data..
Disconnect
File
Editor
Grid (Schema Browser)
Duplicate
Lobs (Schema Browser)
Export Lob..
Connects to the database.
The
connection manager is shown.
You can connect to a database, add a
connection, edit, duplicate or delete it.
The first time, there is an example connection, click "Edit" to edit it.
The
connection settings are saved in the file
%USERPROFILE%\open_teradata_viewer.xml.
The correct driver is yet installed into the application.
The application can connect to a Teradata database using a JDBC driver.
Disconnects from the database.
Opens an SQL file in the editor.
Saves the contents of the editor to an SQL file; specifying the extension “htm” or “html” in the file name, the contents of the editor will be saved such as a Web page.
(Right
click)
Various text editing features are provided by OTVSyntaxTextArea.
Right click the editor to use them.
(Ctrl+Shift+F)
Formats basic SQL statements (DML and queries) to make them more readable.
(Alt+Enter)
The schema browser helps you select tables, views, columns, functions and procedures from the
database schema.
Once opened use the arrow keys or the mouse to select an
object, pressing enter or double clicking will result in showing the selected object in the editor pane.
To cancel press escape, press Alt+Enter or click
the schema browser icon.
Sets the maximum number of rows
returned by the executed query. The default is 2000.
(Ctrl+S)
"select * from " is probably the most frequently used piece of
syntax. Don't bother typing it over
and over, just press Ctrl+S.
Opens
a form where values can be entered
for the creation of a new record.
The record is
based on the result set of the last executed query.
Deletes all selected records
in the grid.
Opens
a form where values can be altered
of the selected record.
Opens a form where
values can be entered for the creation of a new
record.
All initial values
are based o the selected
record in the grid.
(Double click)
Exports a lob to a file and optionally opens it with
the associated application.
If the lob is in plain text, the contents are shown and it's also possible
to copy it to the clipboard. Multiple lobs
can also be exported in one go. To do so, select multiple lob cells, while
exporting, a destination
directory will be asked for and a column of that
table must be selected to
name the files.
Copies one or more lobs into memory.
Pastes one or more lobs from memory.
The number of selected lobs should
equal the number of copied lobs.
The order of insertion is maintained.
This function is useful for
database synchronization.
Imports a file into a lob.
For quick editing a lob: double click the lob, save and open it, do all necessary
adjustments, save the file,
click Import, the previously edited
file will be suggested, confirm.
Exports the grid to an Excel file and optionally opens it with the associated
application.
Exports the grid to a PDF file and optionally opens it with
the associated application.
Exports the grid to a flat file and optionally copies it to the clipboard or saves and opens it with the associated
application.
Converts the grid to insert statements
and optionally copies it to the clipboard or saves and opens it with the associated
application. Useful for database synchronization.
(Ctrl+Enter) OR (F5)
Executes the SQL in the editor pane. The SQL
can be a query, DML, a transaction
block, a call, basically anything.
If a piece of text is selected,
only that selection will be executed. This
is useful for executing a series of statements
one by one.
Executes a series of statements in the editor pane. The statements should be semicolon separated.
(F1)
You're looking at it.
When connected, this dialog shows
some version information about
the database and driver.