Re: SQL external UDF or proc: Ability to specify binding directory to locate external functions and procedures

Hi,

I don't believe we yet have a way to specify a binding directory for
locating external functions and procedures when creating SQL external
UDF's and procedures. If I'm wrong, please educate me.

For example, in RPG, we can use an H-spec or CTL-OPT spec with: BNDDIR(
'QC2LE' ), and then specify a prototype for the C language SLEEP function.

When creating an SQL external UDF or procedure, I'd like to be able to
specify:

PROGRAM TYPE SUB EXTERNAL NAME BNDDIR( 'QC2LE' ) EXTPROC( 'SLEEP' )

or

PROGRAM TYPE MAIN EXTERNAL NAME BNDDIR( 'MY_BNDDIR' ) EXTPGM( 'MY_PGM' )

...or something similar, like we can in RPG.

Unless I'm missing something, today, some of our alternatives include:
* Figure out where SLEEP actually resides and point the EXTERNAL NAME at
its location.
* Create a, for example, RPG wrapper specifying BNDDIR( 'QC2LE' ) plus a
prototype with EXTPROC( 'SLEEP' ), and then point the SQL external UDF or
procedure EXTERNAL NAME to the RPG wrapper program or procedure.

The ability to specify a binding directory and routine would make it
faster, and easier to create SQL external UDFs and procedure wrappers.

I'm wondering if there's significant interest in creating a RFE requesting
said ability from IBM.

Mike
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD