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.