Products Downloads


French version


 

 

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

↑ Top of page


  • Aucune étiquette