External function -- External program
On the External program tab, you can specify information about the program this external procedure uses.
- Specify the name of the program for which you are defining this function in the Program field.
- Select the schema in which the program exists from the schema list. If the schema is not listed, specify the name.
- Select the language in which the program is written from the Language list. Use program attribute uses
the language in which the program is written. However, if the program does not yet exist, Use program attribute
assumes the language is C.
- Select the type that the function returns. Depending on what type you select, you must also specify the length of the
return value in the Length field and the number of digits to the right of the decimal in the
Scale field or the CCSID type in the CCSID field.
- If the external program used by this function returns a large object type as a locator, select External program
returns value as a locator. This check box is only available when the Return value as locator check box on the
General tab is not checked and a large object has been selected on this tab. Similarly, if this box is checked,
the Return value as locator check box on the General tab will not be available.
If the external function is completely defined, click OK.
Or select:
General
Parameters
Note: The program for which a function is defined does not need to exist at the time the function is defined.