dbTalk Databases Forums  

Re: SQL PL Modules

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Re: SQL PL Modules in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Serge Rielau
 
Posts: n/a

Default Re: SQL PL Modules - 04-06-2011 , 05:02 AM






Correct.

Only PUBLISHed routines/types/variables are visible outside the module.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW, IBM Toronto Lab
Blog: tinyurl.com/SQLTips4DB2
Wiki: tinyurl.com/Oracle2DB2Wiki
Twitter: srielau

Reply With Quote
  #2  
Old   
Lennart Jonsson
 
Posts: n/a

Default Re: SQL PL Modules - 04-08-2011 , 01:24 PM






On 04/06/2011 07:31 AM, Lennart Jonsson wrote:
[...]
Quote:
I only posess an express-c 9.7 and it appears as if modules (or
something else) are not included there

[...]$ db2 "call mod1.modfun1()"
SQL8004N A valid license key was not found for the requested function.

It's System-defined modules such as DBMS_OUTPUT.PUT_LINE that's not
supported:

http://publib.boulder.ibm.com/infoce.../c0053670.html


/Lennart

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.