In my replication setup I want to do the replication from multiple
remotes to one master node.
 I have defined all the remote’s target type as "peer-topeer"
because each one of them will  be the source of replication.

Ingres SPARC SOLARIS Version II 2.6/0305 (su9.us5/00)
Anyone ever tried putting a case statement into a where clause
e.g.
s.date_of_arrival  =  case when w.start_date = ' ' then

Is it possible that it's compressed ?
File extensions are not always what they seem.
Try '$file ingres-3.0.2-105-pc-linux-i386.tar'
Andre

Thanks to all who replied to my request. Unfortunately, I still cant
the blasted thing to return a results set.
I have tried variations of both Peter and Karl & Betty's suggestions
with no luck.

Thanks to all who replied to my request. Unfortunately, I still cant
the blasted thing to return a results set.
I have tried variations of both Peter and Karl & Betty's suggestions
with no luck.

In a DBP I am trying to use the comparitor 'like' after declaring the
local variables as :
select col_nam1 into loc_var1
from table ;

Ingres 2.6 03/05 9889  (rs4.us5/00)  Aix 5.2
Environment is Multi (5) dbms servers, OS threads, shared cache.
We had a problem today with a one of the dbms servers, it appears that
the server had problems dealing with a large SQL query the following

FYI.
Eclipse Foundation and Sybase Announce Approval of Eclipse Data Tools
Platform Project
http://www.eclipse.org/org/press-release/20050829dtp.htm

I would like to hear some comments from other ingres administrators
about best practices on user authentication and access control when
connecting to ingres databases from:
-Intranet applications (openroad images as clients)

Hoping someone can help?
I am trying to pass a global temporary table AND several variables to a
DB Procedure. I can happily pass a table on its own and as many
variables as I like on their own but NOT together. Im sure this is just

Is there a limit to the number of data locations for Ingres 2.0?  I
currently have an installation that has 15 data locations.  I would
like to add 8 additional locations to this installation.  I have
managed to procure 2 additional RAID sets and want to get my DB spread

I have this... any use?
WSDD:   cd %D; /bin/tar cf - . | /bin/compress > %A    
and then for rollforwards...
WRDD:   cd %D; if [ -n "`/bin/file %A | fgrep compressed`" ] ; then

having

Just a quickie -
Anyone know if there's a syntax for calling a stored proc without having
to name the individual parameters ?
i.e. exeStr = "execute procedure someUserCreatedMethod(4,'frog',23,234)"

I have two tables
tab_a  id(int)
tab_b  id(int)
and I try the following select which returns an error: