Avoiding hard-coding libraries on CREATE, etc. statements

[cjkoontz]

With the SQL commands:

DROP FUNCTION
CREATE FUNCTION
DROP VIEW
CREATE VIEW

And the option to specify EXTERNAL objects --

Is there a way to specify a library for each (i.e., CREATE FUNCTION MYLIB/MYFUNC), without having to do it on the CREATE, etc. statements?

I see where that you can create an object, by default, in the CURRENT LIBRARY, if you don't specify the library on the CREATE statement.

But what about CREATE VIEW?

The IBM literature I've read seems to indicate that if you don't specify a library, then the first library assumed in the SUBSELECT is used.

Anyway around that?