RE: ILEC and QWCRSSTS

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>
>