Use

You should use a non-standard insert operation when you want to create a new record on a database table, and you do not need to update each attribute. Attributes not specified in the parameter to a non-standard insert are set to null values on the database.

Non-standard insert operations are more efficient than standard inserts, because there is less I/O to the database. It is the responsibility of the application designer to decide whether the improved efficiency is worth the extra complexity of having more operations on your entities.

You might choose to use a non-standard insert where you know the database can perform the operation significantly more efficiently or where the operation will be used by a very high volume transaction.

Non-standard insert operations take a single input parameter - a structure defining the attributes to be inserted. Each attribute of this structure must match some entity attribute by name and type.