MSCEWI2034

Multistatement SQL is not supported.

Severity
Low
Description
Multistatement SQL execution is not supported. The request was handled as a transaction.
Example Code
Input Code:
  replace procedure proc1()
  begin
    BEGIN REQUEST;
      SELECT* FROM TABLE1;
    END REQUEST;
  END;
Output Code:
  //MULTISTATEMENT SQL EXECUTION NOT SUPPORTED, REQUEST HANDLED AS TRANSACTION
  try
  {
    EXEC(`BEGIN`);
    EXEC(`SELECT * FROM PUBLIC.TABLE1`, []);
    EXEC(`COMMIT`);
  }
  catch(ERROR)
  {
    EXEC(`ROLLBACK`);
  }
Recommendations
No additional user actions are required.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI2033

MSCEWI2035

Last modified 1yr ago