 |
 |
Archives of the TeradataForum
Message Posted: Wed, 31 Jul 2002 @ 20:55:02 GMT
| Subj: | | Re: Volatile table & VB |
| |
| From: | | Margaret Westlake |
If you can see the volatile table, but it has no rows in it, it is not because you are disconnecting and reconnecting, but rather you are
forgetting the ON COMMIT PRESERVE ROWS line in your volatile table creation. If you forget that, you'll insert and then delete your rows
immediately. We had a VB app that had that problem at my client site and it took us forever to remember/find that. The default to delete
the rows is I believe an ANSI standard and not Teradata specific, but stupid (in my humble opinion).
Margaret
| |
