I am using Db2 9.5 LUW. Is there a way in DB2 stored procedure can run a .sql file? Like the following:
Code:
sql file: abc.sql
insert into tbl values ('ABC','Very Long Text here');
SP: SP_TEST
CREATE PROCEDURE SP_TEST()
language sql
BEGIN
--Read and run from C:\MyPath\abc.sql
END@
Comment