When a row is placed into the data set, using either the loadtable or insertrow statement, by default, that row's state is UNCHANGED. To set the row state differently, specify the _state constant in the argument list of the statement, assigning it the desired state. You can also use the putrow statement to change a row's state (note that only certain states are allowed, based on the current state—for more information on the putrow statement, see Forms Statements). You can specify _state as an integer literal or an integer variable.

For example, the following insertrow statement inserts a row into the table field and assigns it a NEW state:

You can specify any legal _state value except DELETED. The legal values and their corresponding states are:

0—UNDEFINED
1—NEW
2—UNCHANGED
3—CHANGED

If you specify an UNDEFINED state, do not specify values for any visible columns in the row, because, by definition, an UNDEFINED row is a row that is empty. If you try to do so, you receive a runtime warning but Ingres assigns the values to the visible columns. Ingres generates the warning because the existence of data in an UNDEFINED row can cause problems when you use _state to decide which type of database update to perform during an unloadtable or getrow. You can, however, assign values to hidden columns regardless of the state assigned to the row.