Wednesday, December 09, 2015

NSSQL Tip #5 - Insert into a relative table

By default insertion in a Relative tabel is done at the end of the table. If there is no room left at the end of the table,  a “table-full” message is issued.

To avoid this, the ANYWHERE-option of the insert-statement must be used. With this option rows can be inserted in any available area.

Alternatively it is possible to assign a value to the SYSKEY. In that case the ANYWHERE option is not needed.

No comments: