MSCEWI2034

Multistatement SQL is not supported.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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.

• If you need more support, you can email us at [e-mail]