MIDRANGE-L » February 2013

re: Deterministic ...

Subject: re: Deterministic ...
From: Sue Romano <slromano@xxxxxxxxxx>
Date: Mon, 25 Feb 2013 15:26:09 -0600
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>

The DETERMINISTIC option doesn't get used for procedure calls.

message: 6
date: Mon, 25 Feb 2013 12:24:31 -0500
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject:

I know that deterministic is actually implemented for UDFs but does anyone

know if it actually does anything yet on stored procedures?

I'm at V7 latest TR etc.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com

Sue Romano
IBM i SQL Development

This thread ...

Deterministic ... , Jon Paris

<Possible follow-ups>
re: Deterministic ..., Sue Romano <=

Prev by Author: Re: How to relate performance of new models
Next by Author: RE: Windows 8, Explorer and single IFS files... slow? (try this)
Previous by thread: Deterministic ...
Next by thread: date math in SQL
Index(es):

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact