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
|