User Defined Functions in Mainframe Enviornment

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

singlal - 19 Jan 2006 16:30 GMT

Hi,

I am writting some user defined functions in out development mainframe
environment. How does these functions get migrated over to production?
What all is involved? Is it just that DBA should run the UDF SQL in
production?

Thanks,
Lalit

Reply to this Message

Brian Tkatch - 19 Jan 2006 20:44 GMT

If it is a FUNCTION, the source can be compiled on the server.

If it is a PROCEDURE, if there is a C compiler on the production
server, it can be compiled on the server. If there is not, look at the
CLP commands GET ROUTINE and PUT ROUTINE in the Command Reference.

B.

Reply to this Message

Serge Rielau - 20 Jan 2006 01:00 GMT

> Hi,
>
> I am writting some user defined functions in out development mainframe
> environment. How does these functions get migrated over to production?
> What all is involved? Is it just that DBA should run the UDF SQL in
> production?

I think an SQL UDF can be simply created by running the DDL on the zoS
system. I'm no DB2 zOS expert though.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message