Editing SQL

SQL source editing capabilities:

  • formatting
    Formatting options can be found at Preferences.
    SQL formatting options
    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.
    SQL formatting

  • 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
      SQL content assist for 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.json of the project.
      SQL content assist for database element

For information on using ARCAD tools, see How to use ARCAD integration with IBM i Modernization Engine for Lifecycle Integration