SPs and UDFs, yes. But the confusion is in referring in short-hand to the WLM address space. WLM has its own address space called "WLM." SPs and UDFs run in the WLM-managed SPAS address space arbitrarily named in the APPLENV definition.
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Wayne Bickerdike Sent: Monday, February 11, 2008 10:16 PM To: [email protected] Subject: Re: WLM for toddlers Actually the terminology for SPAs applies also to UDFs (user defined functions). The SQL DDL for a UDF includes the name of the external load module (8 char load module) and the WLM environment which in some of the IBM example code is something like WLMENV1. WLM starts up an address space to execute the SP or UDF. The WLM address space is configured with number of tasks with (NUMTCB) etc. A simple example is the DSN8.DAYNAME UDF. The DDL is shown below: CREATE FUNCTION DSN8.DAYNAME (VARCHAR(10) FOR SBCS DATA CCSID EBCDIC) RETURNS VARCHAR(9) FOR SBCS DATA CCSID EBCDIC SPECIFIC DSN8EUDNV EXTERNAL NAME 'DSN8EUDN' LANGUAGE C DETERMINISTIC PARAMETER STYLE DB2SQL FENCED CALLED ON NULL INPUT NO SQL NO EXTERNAL ACTION NO SCRATCHPAD NO FINAL CALL ALLOW PARALLEL NO DBINFO NO COLLID WLM ENVIRONMENT DB28WLM1 ASUTIME LIMIT 5 STAY RESIDENT NO PROGRAM TYPE SUB SECURITY DB2 STOP AFTER SYSTEM DEFAULT FAILURES INHERIT SPECIAL REGISTERS ; So at our shop we have a WLM address space called DB28WLM1. The external function is coded in C. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
