var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is "Module" similar with Oracle's package ?
I'm a newbie in DB2 SQL/PL. I would like to know "module" is similar with Oracle's package ?
I want to group all store procedure, function into the module. Then, call it from program. If so, should I need to put the module name together with the procedure/ function name when call it ?
e.g. module name is "Test"; function name is "Isnumber". Then, call it "Test.Isnumber()".
Besides, anything I also need to create or build ? Should I need to generate DDL for such module ? Should I grant access right to each module for end user ?
Modules are somewhat similar to Oracle packages. In fact, packages are implemented as modules by DB2 when Oracle compatibility feature is enabled.
You'll find more details here: Modules - IBM DB2 9.7 for Linux, UNIX, and Windows
Thanks a lot.
Originally Posted by n_i