I am using Data Studio 188.8.131.52. I am creating SQL Stored procedures for use with DB2 Web Query. How do I compile/deploy a stored procedure to use System naming.
Basically I am trying to find a method whereby I do not have to hard code the library name in the SQL statement i.e. SELECT * FROM mylib.mytable. I would like to use SELECT * FROM *LIBL.mytable or SELECT * FROM mytable.