Create RRNO Column

Create RRNO Column

This option specifies whether or not the X_UPID and X_RRNO columns should be added to the table when the file is built. If Create RRNO Column is selected, any existing identity column will be used instead of X_RRNO, as a second identity column cannot be added to the table. (Refer to Identity columns.)

If you load a file that does not have a primary key, and do not select Create RRNO Column, functionality will be limited. For further details, refer to Create RRNO Column in the LANSA Technical Reference Guide. To minimize functionality limitations, add a primary key or unique index and reload the table. Alternatively, select the Create RRNO Column option in the File Attributes for the file.

The X_RRNO value will be automatically incremented using a database-specific method.

You must be connected to the database with appropriate permissions on the table to allow the column(s) to be added.

Once the column(s) have been added to the table, they can only be removed manually.

Note that adding the RRNO column affects existing SQL syntax which does not explicitly specify column names. For example the INSERT statement:

INSERT TO MYTABLE VALUES('A', 'B', 2)

only works if a value is specified for all columns. After you add the RRNO column this syntax will not work anymore.

It is better programming practice to specify the names of the columns. In this way adding new columns to the table will not affect your code:

INSERT TO MYTABLE(COL1, COL2, COL3) VALUES('A', 'B', 2)

Also See

LANSA Files loaded as PC Other Files

4.10.3 IBM i RDMLX Other Files

Building a File with Create RRNO Column selected (Oracle-specific)

Removing X_UPID and X_RRNO Columns (Oracle-specific)

Ý 4.10.2 PC Other Files