Sample user-defined functions

Some sample user-defined functions are provided with DB2®. You can use the functions in your applications just as you would use other user-defined functions, or as examples to help you define your own user-defined functions.

To use these functions in your applications: Use the functions only if installation job DSNTEJ2U, which prepares the functions for use, has been run. Because the external programs that implement the logic of the sample functions are written in C and C++, the installation job requires that your site has IBM® C/C++ for z/OS®. For information on installation job DSNTEJ2U, see DB2 Installation Guide.
If you want to use these functions as examples to help you define and implement your own user-defined functions: Data set prefix.SDSNSAMP contains the code for the sample functions.
The detailed descriptions of the functions include their external program names and specific names. The functions are in schema DSN8. The functions are defined to treat character or graphic string parameters, both input and output, as EBCDIC-encoded data.

ALTDATE
The ALTDATE function returns the current date in the specified format or converts a user-specified date from one format to another.
ALTTIME
The ALTTIME function returns the current time in the specified format or converts a user-specified time from one format to another.
CURRENCY
The CURRENCY function returns a value that is formatted as an amount with a user-specified currency symbol and, if specified, one of three symbols that indicate debit or credit.
DAYNAME
The DAYNAME function returns the name of the weekday on which a given date falls. The name is returned in English.
MONTHNAME
The MONTHNAME function returns the calendar name of the month in which a given date falls. The name is returned in English.
TABLE_LOCATION
The TABLE_LOCATION function searches for an object and returns the location name of the object after any alias chains have been resolved.
TABLE_NAME
The TABLE_NAME function searches for an object and returns the unqualified name of the object after any alias chains have been resolved.
TABLE_SCHEMA
The TABLE_SCHEMA function searches for an object and returns the schema name of the object after any synonyms or alias chains have been resolved.
WEATHER
The WEATHER function returns information from a TSO data set as a DB2 table. The TSO data set contains sample weather statistics for various cities in the United States. The statistics are returned to the client with a row for each city and a column for each statistic. The WEATHER function is provided primarily to help you design and implement table functions.

Parent topic: Additional information for DB2 SQL

Related concepts:

Job DSNTEJ2U

Related tasks:

Defining a user-defined function

Related reference:

User-defined function samples that ship with DB2