SQL FUNCTIONS - DB2 z/OS V7

Ken Paris

SQL FUNCTIONS - DB2 z/OS V7
We've written a number of SQL functions but they've been limited to
manipulating/testing the input using other functions, such as

RETURN REPLACE(REPLACE(REPLACE(RTRIM(VALUE),'&','&'),'<','<'),'>','>')

We'd like to be able to write functions which execute a SELECT statement but
haven't figured out if that's possible in V7.

Does anyone know and, if it is possible, can someone provide an example.

Thanks

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm