SQL source editing capabilities:
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.
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 in
iproj.jsonof the project.
For information on using ARCAD tools, see How to use ARCAD integration with IBM i Modernization Engine for Lifecycle Integration