 |
 |
Archives of the TeradataForum
Message Posted: Mon, 19 May 2003 @ 16:07:43 GMT
| Subj: | | Re: Problem in Macro |
| |
| From: | | Dieter N�th |
Anomy Anom wrote:
| | I have a problem in macro that I am storing current_timestamp(0) in to database in different queries but I am getting same timestamp
for every query. Any body know how fix that I want to get timestamp which time that query executed. | |
You can't fix it, because a macro is optimized like a multistatement: The current_timestap is resolved only *once* (when the first
step is dipatched?), so even if the first query runs for 10 minutes, the second quer uses the same timestamp.
If you want different timestamps, use a bteq batch or a stored procedure.
Dieter
| |
