VADELIA |
SADELIA |
WADELIA |
MADELIA |
|
(I/B) (C/S) |
(B) (S) |
(I/B) (C/S) |
(I) (C/S) |
Type
9.0 N
Description
Reserved word linked to the use of the CREATE_SQL instruction with the *BLOCK parameter.
This returns the number of rows inserted by the CREATE_SQL instruction.
For example
CREATE_SQL ITEM *BLOCK(100) ItemLst
IF *SQLROW_COUNT = &NBR_ELT(ItemLst)
* all the items from the list were inserted
…
ELSE
IF *SQLCODE = 0
* all the items were processed but some were not inserted
* because they cause a constraint violation (duplicate key usually)
…
ELSE
* items not inserted or insertion stopped due to a SQL error
…
END
END