Using VALUES INTO instead of SELECT INTO and SQL cursor in Dynamic SQL Queries in SQLRPGLE (AS400)
-Using VALUES INTO instead of SELECT INTO and SQL cursor in Dynamic SQL Queries in SQLRPGLE (AS400)
-dynamic SQL support of VALUES INTO
-Since the SELECT INTO statement could not be dynamically prepared, therefore the only way to assign the results of a dynamic SQL query to the variables was through the use of dynamic SQL cursor.
-The VALUES INTO support enables the simple execution of a dynamic SQL query without the coding overhead of using an SQL cursor.
On this page of the site you can watch the video online Using VALUES INTO instead of SELECT INTO and SQL cursor in Dynamic SQL Queries in SQLRPGLE (AS400) with a duration of hours minute second in good quality, which was uploaded by the user AS400 and SQL Tricks 08 January 2023, share the link with friends and acquaintances, this video has already been watched 1,431 times on youtube and it was liked by 16 viewers. Enjoy your viewing!
