In the past I've used a construct of the following to get rid of
duplicates as a last resort.
delete from table1
where tid in

In microsoft's support:
http://support.microsoft.com/default.aspx?scid=kb;en-us;310070#XSLTH315012112212
0121120120
it demonstrates how to access the return value of a stored procedure
using executeScalar.  Let's presume that the proc needs parameters and

Gang,
We usually save the contentious arguments for Fridays ... but
maybe we should wait for Roy to come back from vacation before
discussing the question a client of mine recently asked:

Any idea of a suitable setting using ssh to connect
to Solaris boxen?

Hi Dudes,
    Having recently upgraded a Linux box to II2.6 I've just found
that only ingres can run the infodb command. Anybody else gets
greeted with:

Err, message says everything?
Logon as ingres, and run: 'upgradefe siege INGRES -uakis_dba'
Regards,
Artur Fajok

Call anyone spot the difference in the newsessionid value in these two
examples ?
#1 :
    create procedure MM_createSessionEntry

Can anyone tell me if there's an easy way to trace transactions that have
forced to a table level lock?
The errlog mentions that we've gone to table level but doesn't show the
offending sql. It would be really handy if there were some trace level.

The advantage of using the unique system maintained key is so you can
differentiate between otherwise duplicate records. Very useful if you have
thousands of rows being inserted and you dont want to go off to a secondary
table to increment a unique number for every row.

All,
An interesting debate from which two anecdotes spring to mind, that
illustrate where (I think) artificial keys can be a pain, but also a
godsend:

The header says it all really, I can't seem to find any reference in the
docs explaining how to do auto incrementing primary keys in tables in an
ingres DB.  I've gone with incrementing a biging value in a separate
table every time an entry gets added, but this seems like a ...

There are a lot of solutions given in this group but I think they are
not exactly what I need/want.
I have a Linuxserver (Ingres 2.6). A remote client can query the
databases on this server through a JDBC-connection.

Ingres r3 supports row-producing procedures.  The Ingres .NET Data
Provider reads the result set produced by that procedure just as any
result set produced by a query.
If the procedure is something like this:

Where are the sql files that are run whenever a sysmod is done ?
I want to add two secondary indices to ii_entities but don't want
sysmod's to remove them
Colin

I'm new to Ingres.
I have the following data in one table:
id              description_id         description
1               1                            desc1