Stored Procedures

Expand Stored procedures in the Query Console sidebar to browse procedures. Select a procedure to inspect its metadata and generate a CALL statement with placeholders for IN parameters. Replace placeholders with real values before execution.

Edit a procedure

For DB2 and AS/400 (DB400) connections, use the procedure actions menu and select Edit. The editor shows read-only metadata alongside editable DDL source. Modify the DDL and select Save; the procedure list refreshes after a successful save.

The Edit action is not available for other database types. If a save error occurs and AI is configured, use Explain to send the error to the Query Assistant.