I have a scenario as I need to read a table (consists only one column with 1000 records) as a procedure1 & to pass that value to another procedure2. On that second procedure it should accept the value (table name) from procedure1 & I need to query some set of records from all the tables. I can do this as a program. Thing is that I need to do all these as db2 procedures itself. As, I am new to these procedures unable to figure it out.
Sample snippet of code will be appreciated.
Kindly help me. Thanks in advance
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!