Editing SQL
SQL source editing capabilities:
-
formatting
Formatting options can be found at Preferences.
Formatting supports both Embedded SQL formatting and Pure SQL formatting. Users can select Format Document to format the whole document or Format Selection to format the selected region after right clicking in the source file.
-
content assist
The content assist provides both SQL keyword and database element completion. Content assist can be triggered in editor window by typing ⌃/CTRL+SPACE.-
Content assist for SQL keyword
-
Content assist for database element
Before using content assist for database element, please refer to the documentation on how to set the SQL properties iniproj.json
of the project.
-
For information on using ARCAD tools, see How to use ARCAD integration with IBM i Modernization Engine for Lifecycle Integration