Re: udf with imbedded SQL

Richard,

Thank you.

They REALLY need to fix up the SQL function error messages.

This:
SELECT CCUST, CPHON,
FAXA(CPHON) as FaxNumber,
FAXAREACODE(FAXA(CPHON)) as AreaCode,
FAXEXCHANGE(FAXA(CPHON)) as Exchange,
FAXNUMBER(FAXA(CPHON)) as Number,
FAXNEWAREA(FAXAREACODE(FAXA(CPHON)), FAXEXCHANGE(FAXA(CPHON)))
   as NewAreaCode
FROM ROB/RCMASH
SELECT statement run complete.
Resulted in this:
 Cust  Cust Phone       FAXNUMBER                       AREACODE  EXCHANGE
NUMBER  NEWAREACODE
 No
 9999  347-3100         93473100                          219       347
3100       260
71317  (219) 587-9116   912195879116                      219       587
9116       260
 4013  (616)555-1212    916165551212                      616       555
1212       616


Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    "Richard Theis"
                    <theis_richard@fr.i       To:     midrange-l@midrange.com
                    bm.com>                   cc:
                    Sent by:                  Fax to:
                    midrange-l-admin@mi       Subject:     Re: udf with 
imbedded SQL
                    drange.com


                    02/13/2002 04:05 AM
                    Please respond to
                    midrange-l






Rob,
Forget my previous append; It is clear that you are using the *SYS naming,
and ROB is in your *LIBL, as the others UDFs are found: the FAXNEWAREA
should be also.  It looks now more like a parameter mismatch.  Is it found
when using it with two CHAR(3) variables (not litterals) ?  You could try
to create it with VARCHAR in place of CHAR.

Best regards
Richard THEIS
AS/400 Education, France
  theis_richard@fr.ibm.com

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.