• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
• Downloads
• Purchase

Download Buy

DB2 Maestro online Help

Extended methods

Use External method wizard to create a new one.  Set the new method Name and (if necessary) Specific name to provide a unique name for the instance of the method.

Language

This mandatory clause is used to specify the language interface convention to which the user-defined method body is written.

Parameter style

This clause is used to specify the conventions used for passing parameters to and returning the value from methods.

Data access

Indicates whether the method issues any SQL statements and, if so, what type.

Scratchpad

This optional clause may be used to specify whether a scratchpad is to be provided for an external method. It is strongly recommended that methods be re-entrant, so a scratchpad provides a means for the method to ″save state″ from one call to the next.

Final call

This optional clause specifies whether a final call is to be made to an external method. The purpose of such a final call is to enable the external method to free any system resources it has acquired. It can be useful in conjunction with the SCRATCHPAD keyword in situations where the external method acquires system resources such as memory and anchors them in the scratchpad.

The description of the other External method properties you can find in DB2 SQL Reference Volume 2.

The next wizard step allows you to specify parameters of the new external method. Use popup menu Add New Parameter... item to add a new parameter and set its properties.