DB2 SQL Editor
The DB2 SQL editor provided by RazorSQL has many features for SQL and SQL PL development. It allows users to edit, create, and drop DB2 procedures, functions, and triggers. Also included in the editor are the features listed below.
- SQL PL syntax highlighting
- SQL PL function lookup
- SQL syntax highlighting
- SQL function lookup
- Auto table lookup and completion
- Auto column lookup and completion
- Extensive find, replace, and find / replace in files functionality
- Bracket, parenthesis, and brace auto matching
- Support for parameterized queries
- SQL Formatter
- Execute, Execute Fetch All, and Execute Batch functions
- Multi-Tabular Display of Query Results
- Sortable Query Results
- Filterable Query Results
- Searchable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Query navigator for displaying a clickable display of queries in the editor
- Key Ahead functionality for one-click population of user-defined text
- Built-in and Custom User Templates
- Connection Keep-Alive
- Plugin API (Allows users to add custom functionality to RazorSQL)
The DB2 SQL editor will automatically configure DB2 specific syntax highlighting on connection to a DB2 database. This gives users the ability to do function lookup on DB2 built-in functions, etc.
