RE: Specify null parameter for SQL UDF -- MIDRANGE-L

Subject: RE: Specify null parameter for SQL UDF
From: "Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 5 Apr 2006 14:23:52 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Glad to see you have it all working Peter.

Just a note on the SCRATCHPAD, as I've used it successfully in the past.
SCRATCHPAD is only allowed with PARAMETER STYLE DB2SQL or PARAMETER STYLE
DB2GENERAL and you're using GENERAL WITH NULLS.
Changing your existing functions to match one of these two parameter styles
would take some doing but may be worthwhile if you think performance will be
an issue.

Elvis

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Specify null parameter for SQL UDF , Peter Dow (ML)

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

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.