We're using an old OpenRoad3.5 application with an Ingres 2.6 database
hosted on a solaris 2.6 server. This is a "legacy" system that "they"
just don't want to get rid of.
The Sun server is now coming to the end of it's useful life and support,

Hello Zhiliang,
You wrote...

it with copy.in

I wish to parse out an Ingres data copy (with sql db_name <  copy.out

wonder could someone advice what's the delimiter and line breaks used
in such Ingres copy

I'm running II 9.1.1 (a64.lnx/103)NPTL + patch13001 on Red Hat
Enterprise Linux Server release 5 (Tikanga).
About once a week my servers freeze up and new connections stall in
Mutex: DCB iidbdb

I need to reproduce a problem that is occurring in a database.  I
think that stray control characters are being added to a varchar
column.
Can anyone tell me how to insert control characters using terminal

We have an Ingres installation on a Digital Unix 4.0, with 2 drives:
Disk A: /local/ingres
Disk B: /local/ingres/data
Lately Disk B went bad.  I created "/local/ingres/data" on Disk A and

We're thinking about porting a quite complex ABF application to GUI.
I know ther was a CA tool called TransForge for moving ABF app to OpenRoad.
Is it supported by the Ingres Corporation ? Is there similar tool for other
GUI platforms (for example Java) ?

My Boss ask me how to create a Backup site for Ingres Database, I looked
at Ingres Documentation and the only solution that I can found was use
ingres replicator to whole the database.
I ask you guys. There are other ways to do that ?

I'm testing Ingres 2006 r2 sp1 (9.1.1 (a64.lnx/103)NPTL) and I have a
problem with report writer. In ABF application I call report and in
param section I have a variable a_zarizeni:
call report(name=:report_name, param='a_zarizeni="T"')

Good morning
I have a script which was supposed to retrieve a list of an Ingres
user's groups from iidbdb (which it does), with the default group
first (which it now doesn't).  The list of Ingres user groups comes

I've loaded Ingres Database (linux version) on Ubuntu Hardy 8.04, and
i've compiled the PHP Driver 2.0.0 ingres.so module, when I start
apache and ingstart and load a php page with phpinfo() it shows the
ingres information. I can tried some of the example code and I am able

Has anyone ever used datahandlers in ESQLC to select LONG VARCHAR columns
and pass their values back to OpenROAD ?
I am setting the sqltype to -46 and length to 0 and attaching a datahandler
routine - Get_Handle

I still get problems on PM
1. is it true that pmload could only load config.dat(or some file
specified) ? But just only one file? If i want to load another file
similar to config.dat and make both loaded, is there any way?