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.