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

* did you compile your module into a service program
* did you specify LANGUAGE as C and EXTERNAL NAME with the right case when
* 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


-----Original Message-----
[] 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

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 On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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