REXX with DB2-- need help
Posted: Thu Mar 10, 2011 12:52 pm
hi all,
requirement:
I have tables name in a PS. (that is the input, around 100 tb) need to take row count (ie select count(*) from tb)
need to save the output of the count in PS like
tb1 -- 26
tb2 -- 58
...
So how to connect rexx to DB2
my idea: In QMF we can save a queary as proc and call the proc in rexx. but i dont know how to call the proc in rexx and send the table name to proc
can someone help on this.
Thanks in advance.
requirement:
I have tables name in a PS. (that is the input, around 100 tb) need to take row count (ie select count(*) from tb)
need to save the output of the count in PS like
tb1 -- 26
tb2 -- 58
...
So how to connect rexx to DB2
my idea: In QMF we can save a queary as proc and call the proc in rexx. but i dont know how to call the proc in rexx and send the table name to proc
can someone help on this.
Thanks in advance.