With the present change, the default setting has been changed to OFF, restoring the behavior from earlier versions.įor EXECUTE IMMEDIATE, the new syntax is:ĮXECUTE營MMEDIATE燵爀xecute-option燷爏tring-expression For this reason, the WITH RESULT SET clause was introduced (see Engineering issue 339798), allowing users to indicate that no result set would be generated. This change in behavior has caused compatibility problems for customers moving from prior releases. A side-effect of this change was that procedures that contained an EXECUTE IMMEDIATE statement were marked as returning a result set, even if no result set was returned. This problem has now been fixed.Īs of 9.0.0, the EXECUTE IMMEDIATE statement supports returning a result set. ![]() ![]() ![]() As a result, querying Notes tables with a column named that was a keyword, would have failed. ![]() When Remote Data Access was used to query information from a Lotus Notes database, the column names in queries sent to the Lotus Notes ODBC driver were not always quoted.
0 Comments
Leave a Reply. |