Unanswered: Procedure to get minimum set of records from each table
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.
if you are new - try to read the doc or look in sample directory where all samples of stored procedures are available
platform-db2 level ? your sample ?
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
If your db2-server runs on some kind of Unix, find the samples/sqlpl tree under the db2-installation-location. IBM gives a sample of a nested stored procedure in that place, for SQL PL.
These samples are also in the Knowledge-Centre for DB2 online.