How to view stored routine code with JetBrains DataGrip

Article for: Toad for IBM DB2

In this article I will show you how to view stored procedure/function definition using DataGrip tool.

In toolbar navigate to View -> Tool Windows -> Database or press Alt + 1 key combination.

Fig.1. Database in View menu

In opened explorer expand [your database], [your schema] and routines branch. Find interesting procedure/function, than right click on it and select SQL Scripts.

Fig. 2. SQL Scripts options

In SQL Scripts select one of the following:

  • Source Editor - to open trigger code with all properties statements in editor
  • SQL Generator… - to open SQL Generator window, which allows generate different types of SQL (e.g. routine definition)

Fig. 3. SQL Generator window and options

  • Request and Copy Original DDL - to copy only routine DDL statement without additional statements (only CREATE PROCEDURE / CREATE FUNCTION)
  • Generate DDL to Clipboard - to copy routine DDL statement with additional statements (like exec sp_addextendedproperty in SQL Server)
  • Generate DDL to Console - to open routine DDL statement with additional statements in database console
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.