|
|
Archives of the TeradataForum
Message Posted: Wed, 27 Jul 2011 @ 19:54:06 GMT
Subj: | | Re: Indented Bill of Material Query? |
|
From: | | Dieter Noeth |
John_Wight wrote:
| You need to add 'ON COMMIT PRESERVE ROWS at the end of the create volatile table;-) Something I get caught with every time!! | |
Aarghh, me too.
For my trainings it's a real table and i just added the VOLATILE for the cut&paste :-)
| Why engineering implemented the CREATE VOLATILE/GLOBAL temp tables with the default NOT to preserve rows has always been beyond me -
probably a dumb ANSI standard? | |
In Standard SQL/ANSI mode this default might be ok, because a transaction is open until you COMMIT it.
Dieter
| |