 |
 |
Archives of the TeradataForum
Message Posted: Thu, 05 Aug 2011 @ 01:03:40 GMT
| Subj: | | Re: Indented Bill of Material Query? |
| |
| From: | | Geoffrey Rommel |
| | Wait, could it be that in other db's, DML is not COMMIT'ed until the COMMIT is reached? Then the rows would be available until the end of
the "transaction". | |
That's right, Frank -- that's what I was trying to say (cryptically perhaps) in my reply. In other words:
ANSI mode:
create volatile table VT1 ... on commit discard rows;
insert into VT1 ...;
/* Now VT1 has the rows you inserted, and you can select, update, or delete
them. */
commit;
/* Now VT1 is empty -- ready for the next transaction. */
Teradata mode:
create volatile table VT1 ...;
[implicit commit]
insert into VT1 ...;
[implicit commit]
/* This is the end of a transaction, so VT1 will have rows only if you
specified
ON COMMIT PRESERVE ROWS. */
| |
