Archives of the TeradataForum
Message Posted: Fri, 09 Dec 2005 @ 16:44:33 GMT
Subj: | | Re: Qualify Clause in Delete Query |
|
From: | | Dieter Noeth |
Anomy.Anom wrote:
| Well, how ROWID can be enabled in V2R5.1 ? | |
Using dbscontrol set internal field 58 (ROWIDEnabled) to TRUE.
| What is the pros and cons if it is enabled ? | |
The rowid has been disabled, because the size changed in V2R5 (8 -> 10 bytes) and some customers used it in application and probably had
problems.
Pro: ROWID can be used, e.g. just for information or to remove duplicate rows
Con: ROWID can be used, e.g. to do Oracle-style programming
Dieter
|