Defining an INSERT Statement 

Use

You use an INSERT statement to add table values. The statement corresponds to an SQL INSERT statement.

Format of INSERT Statement

   <StatementName>

          <dbTableName action=”INSERT”>

              <table>realDbTableName</table>

              <access>

                 <col1>val1</col1>

                              <col2>val2</col2>

              </access>

              <access>

                 <col1>val11</col1>

                        </access>

          </dbTableName> 

   </StatementName>

Procedure

...

       1.      Enter the new column values in the <access> block.

The statement must have at least one <access> element.

       2.      Do not enter a <key> element.

Result

The corresponding SQL statement in the XML structure above is as follows:

“

INSERT INTO dbTableName  (col1, col2) VALUES(‘val1’, ‘val2’)

INSERT INTO dbTableName  (col1) VALUES(‘val11’)

“

The response document contains the following element as well as the number of inserted table rows, including 0.

<insert_count>count</insert_count>