I have been testing Ingres 2006 Release 2 for Solaris and have found
an interesting problem.  We have a large amount of ABF code and there
seems to be a problem using a parameter for a table name in a insert
statement, but not for other statements (like updates).  This sort of

The Topics Covered In This Book Are: Understanding the Oracle
Environment; Understanding the Oracle Instance; Understanding the
working of Oracle Instance; Understanding the Oracle Database; Oracle
9i Software Installation; Oracle 9i Database Design using DBCA;

Does anyone know how to trace the execution of dbms
procedures ? We would like to trace the queries in a procedure.
the PRINTQRY option in II_EMBED_SET gives only the name of the
procédure and the parameters passed (when the procedure is called by

Is there any good way, from a shell script, to run SQL commands against
Ingres (perhaps via ingres' terminal monitor), and to get a useful exit
status from the SQL statements back to the calling shell?
I realize I could use something like python with an ODBC interface, but 1)

As far as checking the exit status, either check '$?' for the terminal
monitor return code.
Or redirect the sql output to a temp file which can then be grep'ed for what
you're

Something simple would be to pipe the sql string to the sql util.
i.e. 'echo "sql commands;\\p\\g" | sql DB_NAME'
The double slash is not a typo, it's an escaped version of \p\g.
Andre

I want to separate rows by pages.
One row per page.
Do You know have can I check page size used by one row?

Let me explain my scenario and make some questions.
I'm working in a project that will develop a solution that needs
integration with a legacy system: An INGRES II 2.6 database in a AIX 4.3
server. Also it is strongly suggested that I use CA-ODBC 3.50 to access

    I am configuring a new installation of Ingres 2.6 on Solaris 10 zones and
    seeing some performance issues. In particular, I'm seeing some very slow
    createdb times which is unusual:
   Sun V890 (8 cpus @ 1.5 Ghz), 16 Gb RAM, Solaris 10 zoned):  22-70 seconds # Snail

(This was also posted at
     http://community.ingres.com/forums/viewtopic.php?t=758
so forgive the duplicate if you've seen it)
Server: W2k3/Ingres 9.0.4

Simple question however I think the answer might a bit trickier?
I want to count the number of times a tables has a select performed on
it.
Any ideas appreciated.

I'm running Ingres2006 on a64.lnx
My Data Access Server refuses to start. The errors in the log file are:
E_GC4805_NTWK_RQST_FAIL  Network request 'OPEN' failed with
error 0x0001FE02.

I'm very new to Ingres. I've installed ingress successfuly and created
a database with a table. I have a .NET application which accessed the
database with an ODBC connection to the database with the following
connection string

Welcome,
As topic says, I got few questions that rely concern me. First of all,
I have to say, that I am totally newbie at this issue and I haven't
been using earlier versions of Ingres neither.

I'm running Ingres2006 +p12125 on a64.lnx
Why is it that I cannot put an automatic partition on a  unique keyed
table?
As I understand it, the automatic partition is just there to scatter the