Versions Compared

Old Version 1

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version Current

changes.mady.by.user user-eb51a

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Building a Table with Create RRNO Column selected

For Oracle, in addition to having permission to alter the table, you require permission to create a sequence and a trigger as the table owner.
Anchor_Ref97964346_Ref97964346

Removing X_UPID and X_RRNO Columns

For Oracle, if you remove the columns, you should also remove the trigger and the sequence. Use the Oracle data dictionary views DBA_TRIGGERS and DBA_SEQUENCES (or USER_TRIGGERS and USER_SEQUENCES when you are logged on as the table owner) to find the trigger and sequence to be dropped. (The object names will contain the LANSA table name.)


See Also

...

Create RRNO Column
&<img src="../resources/images/opentoc-dark.png" title="Open Contents List" border="0"&>