Hi,

I am building a stored procedure through stored procedure builder. It creates it associated package. when i look at that package in the control centre, it is telling me its created with isolation level of cursor stability and cursor blocking of unambigous cursors. How can i specify when building a stored procedure, its package gets an isolation level of uncommitted read.

Thanks,
Dave

What version and platform are you on ?

Db2 UDB v7.1 on Windows NT

Do i have to specify it at the sql level within the stored procedure or can i just specify it when compiling/build the stored procedure

Can you just let SPB do its thing, and do another BIND using the bind file and whatever other parameters you want?

James Campbell