• My Cart
    0
    • Item Qty Sub-Item Qty Price
      Trading Partner License 0 0 0
      Basic Kit 0 0 0
      Extended Kit 0 0 0
      X12 Transaction 0 0 0
      SubTotal 0.00

DiUnite FAQs

Map Development

Q: How can I avoid receiving an error when I execute UPDATE or DELETE SQL statements using the SQLExec function?

A: The SQLExec function expects a returned value from a SQL query (as from a SELECT statement). DELETE and UPDATE statements don't return a value. To accomodate SQLExec's expectations, craft a stored procedure or a more complex SQL query that handles the DELETE or UPDATE and returns a value.

Sample DB2 Delete:

Select x_col From Old Table (
Delete From x_table
Where x_col = y )


Sample DB2 Update:

Select x_col From New Table (
Update x_table
Set x_col = y
Where z_col = z )


Sample Oracle Delete:

Delete From x_table
Where x_col = y
Returning x_col