 |
 |
Archives of the TeradataForum
Message Posted: Sat, 08 Mar 2003 @ 09:59:12 GMT
| Subj: | | Re: Sequence # |
| |
| From: | | Dieter Nöth |
Anomy Anom wrote:
| | Thanks for the workaround. | |
| | However I have a need to identify with in a batch of rows the order in which they were applied. | |
| | Another thing about using timestamp, because even with timstamp(6) at least 5 or 6 statements appear to have the same
fractional time when doing bulk ins/upd/del... | |
Bulk insert using BTEQ? Then the trigger should work.
Btw, there's a maximum of 2 significant digits for a current_timestamp, so the last for digits of a current_timestamp(6) are
always 0.
Dieter
| |
