Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to firstname.lastname@example.org.
cvsnt-bounces at cvsnt.org wrote on 07/18/2007 05:23:32 PM: > It gets the session id from a 'select identity_val_local()' appended to > the session insert string (the whole string is something like 'begin > atomic; insert into xxxxx; select identity_val_local(); end'). > > I can't think of a reason why that would suddenly stop working if it > worked before unless there's a way to switch that functionality off > globally. Our DB2 admin (Kristi) submitted a query using the above info and had success. Here's the full text of her results: Insert Into cvsuser.SessionLog (Command, Date, Hostname, Username, SessionId, VirtRepos, PhysRepos, Client) Values ('tag','2007-07-20 20:40:21', 'P3038356.aepsc.com','s188253','7a5b469e7ab524f0','/usr/local/cvs/caf','/usr/local/cvs/caf', 'Kristi Test') DB20000I The SQL command completed successfully. db2 select identity_val_local() from cvsuser.sessionlog fetch first 1 row only 1 ------ 68855. db2 select id, client from cvsuser.sessionlog where id = 68855 ID CLIENT ----- ----------- 68855 Kristi Test So the function works as expected. The return value just seems to get lost before the next query happens (to insert something like taglog data). Thanks for your help, Tony... Brian