Generating a data definition statement for user defined functions
Use this notebook to re-create user defined
functions by generating the SQL statements
necessary to duplicate the user defined function
environment. The data definition language
(DDL) statements generated are for the selected
user defined function and related privileges
defined at the current server.
You can use this notebook to:
- Extract the DDL for an object before changes
are made. You then have a copy available
for fallback purposes.
- Extract a user defined function environment
to move your DB2 objects to another DB2 subsystem.
Generate the DDL to create a duplicate environment
that can be used in another subsystem.
Authorities
and privileges
To generate a DDL statement:
-
Open the Generate DDL window.
- From the Objects page select which objects
and dependent objects that you want generated.
The available choices include the User defined function and the privileges associated with the user
defined function. If you clear the check
boxes of certain objects, other related objects
become unavailable (including some on the
Options page). You must choose at least one
object.
- Optional: From the Options page select one
or more options to change the statement from
the default state. You can:
- In the Overrides group, select one or more of the check boxes
to alter the schema name or owner.
- A schema is a logical grouping for user-defined
functions. When an object of this type is
created, it is assigned to one schema which
is determined by the name of the object.
Two different schemas can each contain a
function with the same name that have the
same data types for all of their corresponding
data types. However, a schema must not contain
two functions with the same name that have
the same data types for all of their corresponding
data types. Therefore, to create a duplicate
user defined function, you need to change
the schema name.
- The owner field is an 8 character authorization
ID of the owner of the function.
- In the Options group, specify new values for the generated
DDL. Available fields depend on the selections
from the Objects page.
- Specify a release of DB2 for OS/390 for which
you want the generated DDL to be used.
- Specify how often you want to commit the
statements.
- Specify the default handling to be used.
You can specify to use the defaults
as defined
in the original user defined function,
or
remove any defaults in the new user
defined
function definition wherever possible.
- From the Output page, designate the file
(mainframe or workstation) that will contain
your new DDL statement. You can define a
separate data set or file for the report
and the generated statements. You must designate
at least one output file name or data set
name to generate the DDL.
- In the Output report to data set field and Output DDL to data set field, type an identifier of 1 to 44 characters
that identifies a cataloged name for a data set defined in the OS/390 system and used by
the DB2 for OS/390 subsystem.
- In the Output report to file field and Output DDL to file field, type a file name that will be saved
on your workstation. You can also click the
push button to open a Save As window to
select a file name.
- Click OK to generate the selected object.
Related information
Data sets