Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    2

    Unanswered: Problems with identity_val_local()

    Hi to all!

    I am trying to insert a row in a table and then call the identity_val_local() function to get the last value of the identity column. However, the function returns null but a row is inserted. All this happens in the body of a stored procedure.
    There are some before insert and after insert triggers on that table but they have no impact on the identity column. Is is possible that these triggers are the reason why identity_val_local() returns null? Or maybe some other thing is going wrong?

    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    From the limited information provided, I'm unable to say ..

    I would recommend you reading the manual about the function in question ... There are a number of ifs and buts ..

    http://publib.boulder.ibm.com/infoce...n/r0004231.htm

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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