I am working on UDB V8.1.
I am facing the following problem :-
can't build SQL stored procs and UDFs from outside the development centre.
What are the steps needed for building SQL stored procs and UDFs ?
If I run a create procedure script from the command line it builds itself without me being able to use all the precompile and bind options.
I know that we can set the DB2 registry variable for prepopts but all the options for precompilation are not available.
In short I am trying to create a script which will allow me to specify individual stored procs and UDFs and let me specify their schema and also the qualifier of the objects that they use.