DATE() is not a constant, but rather a function that will return a different value each day.
You can see the object code that is produced using VLIST and examine it for optimizations. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Barry Rogen Sent: Thursday, July 16, 2009 8:39 AM To: U2 Users List Subject: [U2] Universe Retrieve Question: If you are doing a select statement and within the statement you have a eval phrase and this eval phrase contains all constants (ie, DATE() - 14), does Universe recalculate that constant value with each record iteration or is it smart enough to know that this is a constant value and therefore only calculates it once ? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [email protected] ----------------------------------------------------- We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner ---------------------------------------------------------------- P Before printing please think about your environmental responsibility 16/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
