logo

Connection

image040  Connect

image040  Edit connection data..
image041 Disconnect


File

image043 Open File
image045 Save File

Editor

Text Editing

image046 Format SQL code

image047 Schema Browser

image048 Fetch Limit

SELECT * FROM

 

Grid (Schema Browser)

http://dbedit2.sourceforge.net/images/add.png Insert

 

http://dbedit2.sourceforge.net/images/delete.png Delete

http://dbedit2.sourceforge.net/images/edit.png Edit

http://dbedit2.sourceforge.net/images/copy.png Duplicate

Lobs (Schema Browser)

image049 Export Lob..

image050 Copy Lob
image051 Paste Lob
image052 Import Lob..

Export (Schema Browser)

image053 Export Excel
image054 Export PDF
image055 Export Flat File
image056 Export INSERT statements

 

image057 Run
image058 Run Script

?

Help
About

SQL Reference

image040 Connect

Connects to the database.

image040 Edit connection data..

The connection manager is shown.

connectionpanelScreenshot.png

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.

image060

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.

image041 Disconnect

Disconnects from the database.

image043 Open File

Opens an SQL file in the editor.

image045 Save File

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.

Text Editing

(Right click)


Various text editing features are provided by OTVSyntaxTextArea.
Right click the editor to use them.

image061

image046 Format SQL Code

(Ctrl+Shift+F)


Formats basic SQL statements (DML and queries) to make them more readable.

image047 Schema Browser

(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.

image048 Fetch Limit

Sets the maximum number of rows returned by the executed query. The default is 2000.

SELECT * FROM..

(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.

http://dbedit2.sourceforge.net/images/add.png Insert

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.

http://dbedit2.sourceforge.net/images/delete.png Delete

Deletes all selected records in the grid.

http://dbedit2.sourceforge.net/images/edit.png Edit

Opens a form where values can be altered of the selected record.

http://dbedit2.sourceforge.net/images/copy.png Duplicate

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.

image049 Export Lob..

(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.

image050 Copy Lob

Copies one or more lobs into memory.

image051 Paste Lob

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.

image052 Import Lob..

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.

image053 Export Excel

Exports the grid to an Excel file and optionally opens it with the associated application.

image054 Export PDF

Exports the grid to a PDF file and optionally opens it with the associated application.

image055 Export Flat File

Exports the grid to a flat file and optionally copies it to the clipboard or saves and opens it with the associated application.

image056 Export INSERT statements

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.

image057 Run

(Ctrl+Enter) OR (F5)


Executes the SQL in the editor pane. The SQL can be a queryDML, 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.

image058 Run Script

Executes a series of statements in the editor pane. The statements should be semicolon separated.

Help

(F1)


You're looking at it.

About

When connected, this dialog shows some version information about the database and driver.