Compiling User Defined Functions/Procedures in Workbench (Big SQL)

DB2 requires an ending delimiter when compiling user defined functions or stored procedures from the command line.

Workbench does not have this requirement.

To compile a procedure or function, there is no need to use a delimiter such as the default '@'.

1) Write the code without an ending delimiter and choose 'Execute as single Batch' (CTRL+F5)

 

Screen_Shot_2015-08-19_at_12.22.48_PM.png

OR

Change the current query options to Query kind: SP/Function:

Query_kind.png

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk