Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Unanswered: Specifying Isolation level when building stored procedure

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    What version and platform are you on ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2003
    Posts
    50
    Db2 UDB v7.1 on Windows NT

  4. #4
    Join Date
    Jun 2003
    Posts
    50
    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

  5. #5
    Join Date
    Jan 2005
    Posts
    191
    Can you just let SPB do its thing, and do another BIND using the bind file and whatever other parameters you want?

    James Campbell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •