Create an SQL function

[bvining@xxxxxxxxxxxx]

Dave,

You most likely have a mis-match between the arguments being passed to
the function and the signature of the function.  I suggest you carefully
review the SQL Reference sections Function Resolution and Promotion of
Data Types.  I have seen similar problems in the past where the function
declared fixed length character strings but the function was actually
being passed variable length character strings.  This would cause a
not found situation.

Bruce Vining

>
>I am attempting to create an SQL function.  I can create the function but
>whenever I try to use it, I get the error "SQL0204 - RTVDOW in *LIBL type *N
>not found.".
>
>I tried creating the function in QGPL and ensured that QGPL was in my
>library list, but still get the same error.
>
>The SQL manuals do not have any examples on creating functions using RPGLE
>(which is what I'm using). Any ideas?
>
>Thanks,
>Dave
>


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---