Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!psuvax1!wuarchive!uunet!mhinfo!bishop
From: bishop@mhinfo.UUCP (Deborah Bishop)
Newsgroups: comp.databases
Subject: Ingres (Ultrix/SQL) questions
Summary: Ingres ABF and data conversion questions
Keywords: INGRES
Message-ID: <16@mhinfo.UUCP>
Date: 18 Feb 91 04:02:14 GMT
Reply-To: bishop@mhinfo.UUCP (Deborah Bishop)
Distribution: usa
Organization: Mile-High Information Services, Inc.
Lines: 33

We are developing an inventory management system using Ultrix/SQL    
(aka Ingres) and ABF, and could use some help with the following:

1. Since only applications built by the DBA are shareable, we have all
been signing on as the DBA to do our development.  When we try to COMPILE 
and GO to test our work, Ingres compiles ALL modules under development
- even though they do not reference each other.  If one programmer's module
fails, we cannot run the others.  Obviously, there must be a smarter way
to develop in a multi-programmer shop.  Will the -u switch help?  Will the
modules still be shareable?
2.  When we actually go to build an image (using ABFIMAGE), we consistently 
run into unresolved references.  We resolve this by opening the 'offending' 
OSQ and rewriting it.  (We change nothing in the file).  Doing this a few times
fixes the problem.  Any ideas what might be causing this problem?
3.  To perform a 'get next record' operation we use a form = select record
where key > :key order by key.  Now I know that using a singleton select in
this way would cause most sql implementations to bomb, but it works.  We
are worried that we're employing a substandard technique, taking advantage
of a hole(?) (albeit a convenient one) in Ingres, and wonder if anyone has 
a smarter (safer) approach.
4.  We use the -s flag on our reports.  This removes all messages except
'Ingres Report Writer...blah, blah'.  Does anyone know how to get rid of
this message?
5.  The system we are rebuilding currently runs on a DG using INFOS files.
We are considering using the Ingres Export product to read the INFOS files
into a format that we can use to load into Ingres on Ultrix.  Does anyone
have any insight into this?  Like, will it work?

-- 
		Deborah Bishop	(uunet!mhinfo!bishop)
		Mile High Information Services  Suite 3400
		9101 E. Kenyon   Denver  CO  	80237
		303) 721-0851