try the following:
export VAR=`sql iidbdb <<EOSQL | grep "^|" | grep -v col1 | sed -e
's/|//g'
SELECT count(*) from temp;\g

A lot of Chinese Websites translate this article to open an arguement.
What does everyone here think about?
******************************************************************************************************************************
Men Write Code from Mars, Women Write More ...

I hadn't checked up on the checkpointing this week, until today, when I found I have several journal files, from the last few days in my journal folder for the ERP application db. I also have a couple of days of checkpoint folders.
I run a nightly checkpoint with ckpdb +j -d ...

I have Ingres 2006 r2 Ingres Vision applications running on a RHEL 4 64
bits running against Ingres 2.6 sp5 on Tru64 machine (using Ingres Net +
installation password).
Before this scenario, Ingres Vision applications were running on the

Does anybody have any practical experience with Parallel Query
Execution and partitioning tables just wanted to know if we are aware
of any practical issues /drawbacks

Having solved my previous problem I am currently creating an SQLDA to use as
a descriptor when FETCHing data in ESQLC
I'm passing in a User Class object from OpenROAD as a handle, along with a
SELECT statement and creating an SQLDA based on the data types, lengths,

How did the IUA go? Nothing on www.iua.org.uk - indeed registrations are still being solicited!
Il mittente di questo messaggio|The sender address of this
non corrisponde ad un utente   |message is not related to a real
reale ma all'indirizzo fittizio|person but to a fake address of ...

Gang,

On a system like this:

&nbsp; OS:&nbsp;&nbsp;&nbsp;&nbsp; Redhat ES 5.2 64-bit x86_64
&nbsp; Ingres: II 9.1.1 (a64.lnx/103)NPTL
&nbsp; Patch:&nbsp; 12819

I'm getting quite a few of the messages below on a database
with a fresh SYSMOD.

Table info is

I see the sprint is getting some coverage at
http://www.techworld.com/applications/news/index.cfm?newsID=101969&pagtype=all.
It badly underplays the role of our mentors, but as the saying goes, any
publicity is good publicity!

Hello, I want to use Java to perform queries in my ingres database. Currently
there is an ODBC driver installed in the server but I would like to use JDBC
driver to connect directly with the database without using a JDBC/ODBC bridge.
Please can somebody tell me what do I need to ...

I'd like to express my thanks to Emma and all the guys from IngresCorp
who turned up for the sprint at the UKIUA. It was very generous for Emma
to pay for the event. Furthermore, it was really appreciated that so
many IngresCorp programmers gave up their time to help us all out. It

What can cause uncompression to fail?  The *.t00 data files all have
data in them.
E_DM942C_DMPP_ROW_UNCOMP  Uncompression of a row has failed.
Database mydb, table ii3b7 pp5-my_table, owner ingres, page 4753,

If anyone fancies dropping in on the Ingres and OpenROAD development sprints
over the weekend, you will be more than welcome.  We'll be at the Hilton
Metropole, with Ingres development in Hilton 15 & 16 and OpenROAD
development in Hilton 13 & 14.  Work will be commencing probably ...

Is there any reason why II_DATE_FORMAT doesn't work on ansidate or
timestamp data?
Is there an equivalent function?
Martin Bowes

I'm packaging ingres for my company - is there a location where ingres stores
vnode configuration information. I'm going to need to add databases during
installation at remote sites.
I can't find anything in the registry or any file that I can read.