Re: First SQL UDF

From what I've learned, SQL doesn't like assumptions of any kind -- you gotta spell things right out for it. With UDFs, this works the other way, too -- if you want to pass a literal string to a UDF, you have to tell the UDF exactly what you're doing.

For example, if you've got a UDF that expects to be passed a one-character field, you'll get an error if you try:

select myUDF('A')

instead, you've got to use:

select myUDF(char('A',1))

(explicitly telling it that you're passing it one character). Otherwise, it'll tell you that the function isn't defined on the system (been there, done that ;-).


Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:

This worked! Never assume default sizes!

Create function CharOrder
(numb DEC(8,0))
Returns char(7)

. . .

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA 01376
413-863-4357 x444
mnaughton@xxxxxxxxxxxx