RE: SQL index authority

Excellent question! I don't know of a way to retrieve DFTRDBCOL. If there
truly is no way... I think there's a void there. IBM should provide some
special SQL register for it.

It could still work if you're willing to set the CURRENT_SCHEMA sql register
prior to invoking RUNSQLSTM. For example:

STRSQL
SET CURRENT SCHEMA myLib
F3
RUNSQLSTM SRCFILE(myLib/mySrcPf) SRCMBR(mySqlMbr) DFTRDBCOL(myLib)

And in the RUNSQLSTM source you'd invoke your SP as:

CALL grantIndexAuthority(CURRENT_SCHEMA, 'INDEXNAME');

Hope that helps.

Elvis

Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
October 16
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i, eServer
iSeries and the server affectionately known as the AS/400

-----Original Message-----
Subject: RE: SQL index authority

That's even better. The only issue is that I use DFTRDBCOL(libname) on
the RUNSQLSTM cmd so that I do not have to hardcode any lib names in my
SQL stmts in the source member. We have multiple data libs with the
same-named objs. Is there a way of retrieving this value so that I could
pass it to the stored proc? Thanks.