DB_INSERT handleIdent_Int, rowIdent, retCodeIdent_Int [ORAHINT hintIdent_Str] DBS_INSERT dbObjIdent, rowIdent, retCodeIdent_Int [TRANS transHandle_Int] [ORAHINT hintIdent_Str]
DB_INSERT handleIdent_Int, structIdent, retCodeIdent_Int [ORAHINT hintIdent_Str] DBS_INSERT dbObjIdent, structIdent, retCodeIdent_Int [TRANS transHandle_Int] [ORAHINT hintIdent_Str]
|handleIdent_Int||in||Identifier (handle) of Int type of the connection with a table (DB_CONNECT).|
|rowIdent||in||One structure row identifier (row to insert).|
|structIdent||in||Identifier of a whole structure (rows to insert).|
|retCodeIdent_Int||out||Return value of Int type - action success.|
|transHandle_Int||in||Identifier of the Connection to the database.|
|hintIdent_Str||in||Expression of String type that defines Oracle SQL hint.
It is used as an instruction for the performance optimizer of SQL
command. The value is used without the opening and
terminating characters /*+ <orahint>
The example is mentioned here.
For D2000 v5.00: an disadvantage of the action DBS_INSERT
is in speed. Each DBS_INSERT call results in necessity
to open and close the database in DBManager - it can be a
time-consuming operation and it is a comparatively nonstandard method
in term of databases.
The need to open and close the database may be avoided in the scope of transaction processing so that the command is followed by the parameter
For D2000 v6.00 and higher: DBManager optimization (connection recycling, predefined connections) causes, that the action DBS_INSERT is executes as quick as the action DB_INSERT and as moreover there is saved a time required for execution of the action DB_CONNECT to open the database.