Step1. Generally in OPEN SQL select query the required fields are mentioned without commas, but with the new OPEN SQL select query the fields can be maintained with commas as separator but this is not only sufficient. Here we receive a syntax error.
Step2. With the new open sql statement when fields are separated by comas then the host variable(target data object), here WA should be mentioned as @WA. Now there is no syntax error.
Step3. The O/P is as below:
-----------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment