× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2019

sql function - routine not found when ACTGRP(*NEW)

does the activation group of a program matter when creating an SQL function?

I am getting a "routine not found with specified parameters" error when
using an SQL function, where the program was created with ACTGRP(*NEW).
When I CRTPGM pgmname ACTGRP(QILE), the sql function works.

CRTPGM PGM(utl0033MC) ACTGRP(*new)

select utl_currentUser( ) user
from sysibm/sysdummy1
Routine UTL0033MC in QGPL not found with specified parameters.

do this and the sql function works:
CRTPGM PGM(utl0033MC) ACTGRP(QILE)


CREATE OR REPLACE FUNCTION utl_currentUser ( )
RETURNS char(10)
language cl
external name qgpl/utl0033mc
parameter style SQL

PGM (&curUser &rtnNull &SqlState +
&function &specific &errmsg)

dcl &curUser *char 10
dcl &rtnNull *int 2
dcl &sqlstate *char 5
dcl &function *char 517
dcl &specific *char 130
dcl &errmsg *char 72

RTVJOBA CURUSER(&CURUSER)

endpgm

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.