I would like to create an SQL table function, written in SQL_PL that does the following:
Receive a code as a parameter
Look that code up in a table that contains an SQL select statement string
Execute that SQL and return the results as the table returned
Is that possible in SQL PL? If it is I can't work out how.
If it isn't then I know I can write an External SQL Table Function and implement it in SQLRPGLE.
Receive a code as a parameter
Look that code up in a table that contains an SQL select statement string
Execute that SQL and return the results as the table returned
Is that possible in SQL PL? If it is I can't work out how.
If it isn't then I know I can write an External SQL Table Function and implement it in SQLRPGLE.
Comment