[cvsnt] sessionid as foreign key

bwhicks at aep.com bwhicks at aep.com
Thu Jul 19 21:18:50 BST 2007

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 sales@march-hare.com.

cvsnt-bounces at cvsnt.org wrote on 07/19/2007 03:11:04 PM:

> bwhicks at aep.com wrote:
> > So the function works as expected. The return value just seems to get 
> > before the next query happens (to insert something like taglog data). 
> > 
> I can only guess something getting lost in the ODBC driver... although 
> I've never heard of that happening before.

We ran some SQL statements through using ISQL, which is a command line 
tool that connects to databases using the ODBC driver. Check it out:

caft1.aepsc.com:/home/db2inst1>isql cvsdb001 db2inst2 password
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
SQL> insert into cvsuser.sessionlog (command, date, hostname, username, 
sessionid, virtrepos, physrepos, client) values ('tag', '2007-07-20 
20:40:21', 'x', 's007766', 'x', 'x', 'x', 'Kristi Test 2')
SQLRowCount returns 1
SQL> select identity_val_local() from cvsuser.sessionlog fetch first 1 row 
| 1                                |
| 68874                            |
SQLRowCount returns -1
1 rows fetched

So the ODBC driver is working, which points us back at cvsnt again. Any 


More information about the cvsnt mailing list
Download the latest CVSNT, TortosieCVS, WinCVS etc. for Windows 8 etc.
@CVSNT on Twitter   CVSNT on Facebook