So many things that could have gone wrong and so little information
provided.... 

* did you compile your module into a service program
* did you specify LANGUAGE as C and EXTERNAL NAME with the right case when
running CREATE FUNCTION
* do your return variable data types match
* is your service program in the library list when you run the SELECT
* what are the "lower level messages" you see

Elvis

-----Original Message-----
From: c400-l-bounces+ebudimlic=centerfieldtechnology.com@xxxxxxxxxxxx
[mailto:c400-l-bounces+ebudimlic=centerfieldtechnology.com@xxxxxxxxxxxx] On
Behalf Of Stephen More
Sent: Wednesday, October 05, 2005 12:35 PM
To: C programming iSeries / AS400
Subject: Re: [C400-L] ILEC and QWCRSSTS

Thank you. This helps me out a great deal.

I have changed this main into a module, it compiles and runs fine when
called.

Now I am trying to go 1 step further, and create a user defined function
that calls this module. I was able to create the UDF but when I execute the
sql ( 'select cpu() from sysibm/sysdummy1 ) I get:

'Query cannot be run. See lower level messages.'

My joblog does not show anything out of the ordinary.

Is there a problem with calling APIs from SQL ?

-Steve More


On 10/4/05, Scott Klement <c400-l@xxxxxxxxxxxxxxxx> wrote:
>
>
>
> Here's a trivial example:
>
>
> <snip><snip>
>

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].