HDTenEightyP/NetNews huggingface dataset:
From: alewalle@anl433.uucp (ames lewallen)
Newsgroups: comp.databases
Subject: Re: Help!-searching FOXPRO string fields
Date: 13 Nov 92 01:56:38 GMT
Distribution: na
X-Newsreader: Tin 1.1 PL5

John,

There's a lot of ways to do this, but the easiest way would be to do your
search with the clause being:

   'address' $ fieldname

This should do the trick for you.

jim


 (JBC103@psuvm.psu.edu) wrote:
: We are currently evaluating FOXPRO (for DOS-I don't think windows version is
: out yet).  One problem we're having is searching alphanumeric (string) fields.
: We want to be able to match part of the field, ie. if the field contains
: the words "Student address list" we may want to search for every record with
: the word "address".  In Paradox, we would search for "..address..", but we
: haven't been able to find a similar function in Foxpro.  Any help would be
: appreciated.
: 
: 
:  John Carnicella
Newsgroups: comp.databases
From: news@massey.ac.nz (USENET News System)
Subject: Significant digits & rounding
Organization: DSIR, Palmerston North, New Zealand
Date: Fri, 13 Nov 92 01:46:51 GMT

This post is primarily for those who understand ARev. This is because ARev 
allows naughty manipulations of numbers such as treating them as strings.

I need to take a value and set it to some number of significant digits.

  e.g. 123450  ->  120000 for 2 sigdig
       0.0230  ->  0.023      "

Has something done or know of an algorithm for performing this type of 
function? I could probably nut it out eventually, but would appreciate it if 
someone else has done all the hard work!

I have already got a general rounding function in plcae, but again, if 
someone knows a nice little alorithm for rounding, then I'd love to know 
it...

Thanks in advance

David Apimerika
Xref: sparky comp.databases:7830 comp.databases.oracle:2196 comp.databases.ingres:1884
From: grant@erich.triumf.ca (Peter A. Grant)
Newsgroups: comp.databases,comp.databases.oracle,comp.databases.ingres
Subject: Re:  I heard a Rumor about Oracle 7 and Forms
Date: 13 Nov 1992 13:09 PST
Organization: TRIUMF: Tri-University Meson Facility
Distribution: world
NNTP-Posting-Host: erich.triumf.ca
News-Software: VAX/VMS VNEWS 1.41    

In article <1992Nov13.184731.21707@cs.rochester.edu>, zhang@cs.rochester.edu (Zhang Ju) writes...
> 
>I heard a rumor which goes that the delay of ORACLE 7 is because of its
>incompatibility with Forms 3. So Oracle 7 is actually waiting for Forms 4.
>...


That's the first I've heard of that rumor!  From all that I've seen or 
heard ORACLE7 supports SQL*Forms 2.3 and 3.0.  It's being released before
Forms 4.0 is even out in beta (GUI - text mode it is already I believe).

I think that rumor is completely false...


Peter Grant           ////////  ///////  ////////  //    //  //    //  ////////
grant@reg.triumf.ca     //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia

                  Chairperson, Vancouver Oracle Users Group
From: pgleason@ncratl.AtlantaGA.NCR.COM (Pat Gleason)
Newsgroups: comp.databases
Subject: Dbase IV Bug Lists
Date: 13 Nov 92 02:52:33 GMT
Organization: NCR Engineering and Manufacturing Atlanta -- Atlanta, GA

Can anyone email me any bug reports for Dbase IV 1.1 and DBase IV 1.5 ??

I am specifically looking for information on index corruption (MDX)
when performing multi-user operations on a Novell LAN. 

Thanks in advance.
-- 
==============================================================================
Pat Gleason                       | "And the men who hold high places must be 
pgleason@ncratl.atlantaga.ncr.com | the ones who start, to mold a new reality, 
     LOUD MUSIC = GOOD CODE       | closer to the heart..."  RUSH 
Newsgroups: comp.databases
From: lenzen@galaxy.fernuni-hagen.de (Frank Lenzen)
Subject: STILL LOOKING FOR EXPRESS-TOOLS
Organization: FernUniversitaet Hagen
X-Newsreader: Tin 1.1 PL5
Date: Mon, 9 Nov 1992 08:26:12 GMT


Information on EXPRESS tools wanted!

If you have any tools which are related to the upcoming ISO standard 
EXPRESS (e.g. parser, constraint checker, databases, EXPRESS-G tools, 
EXPRESS-G to EXPRESS translator and vice versa, etc.), we would be very 
happy to hear from you. 

We are using EXPRESS very intensively in our work on modelling the 
domain of CAD objects in electronic design. Furthermore, we are planning 
to establish a tutorial on EXPRESS in a European  context, and our 
interest is  
(1)	to give an overview on existing EXPRESS tools,
(2)	to demonstrate EXPRESS tools, and 
(3)	to provide some good tools to support the participants' 
first practical steps in modelling with EXPRESS. 

If you can provide some information on available EXPRESS tools (either 
about tools which have been implemented by yourself or about tools which 
you are using), please contact us at the following address:





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ FernUniversitaet Hagen   +  Frank Lenzen                   +
+ Praktische Informatik I  +                                 +
+ Feithstr. 140            +                                 +
+ W - 5800 Hagen 1         +  EMail: lenzen@fernuni-hagen.de +
+ Germany                  +  Fax-No. :  +49.2331.987.314    +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
From: lindsey@tincup.enet.dec.com (Randy Lindsey)
Newsgroups: comp.databases
Subject: Re: FoxPro Mail Merge Files - Help
Date: 12 Nov 92 00:17:02 GMT
Article-I.D.: nntpd2.1992Nov12.001802.610
Distribution: usa
Organization: Colorado Software Solutions, Inc.


In article <1992Nov10.170253.29641@mksol.dseg.ti.com>, kylscott@mksol.dseg.ti.com (kyl w scott) writes...
>I need help generating a Microsoft Word for Windows mail merge file
>from Foxpro.  Any other word processors would be greatly appreciated
>also.

Maybe this is wrong or not helpful, but doesn't Word for Windows support
XBase DBF files?  If so, just write one of those.  Or does it...?
Newsgroups: comp.databases.ingres
From: IIC2132@isluga.puc.cl (AyudantesIIC2132)
Subject: NEED SQL for PC
Organization: Pontificia Universidad Catolica de Chile
X-Newsreader: Tin 1.1 PL5
Date: Fri, 13 Nov 1992 15:40:48 GMT

    I want to get some SQL for PC. If somebody know how to do it, please
let me know.

Albert Bae
From: pavlov@niktow.canisius.edu (Greg Pavlov)
Newsgroups: comp.databases.ingres
Subject: Re: ingres 6.4 and ultrix 4.3
Date: 12 Nov 92 07:30:46 GMT
Organization: Canisius College, Buffalo NY. 14208

In article <01GQZI29JDTK0007FR@ruulet.let.ruu.nl>, Angela.M.Wubbels@let.ruu.nl writes:
> I have heard rumours that ingres 6.4 has problems with ultrix 4.3.
> Does anyone know something more about this?
> 
  INGRES 6.4 is not certified to run under ULTRIX 4.3 .  But our sales person
  told us that it will be, in the December-January time frame.


  greg pavlov
  pavlov@fstrf.org
Newsgroups: comp.databases.ingres
From: DELFT UNIV OF TECHNOLOGY/COMP CENTRE +31 15 784821 <Jan.vanSetten@RC.TUDelft.NL>
Subject: Re: Need info on Vigraf
Organization: National Radio Astronomy Observatory
Date: Thu, 5 Nov 1992 08:40:09 GMT

On Nov 5 1992 Brian GUAN asked:

>  Has anyone use Vigraf before ?  I need to know what it does, as well as
>  the price for the product on HP 9000/700.
>
>  Also, if you do know of any product that can help me plot Bar Chart, Pie
>  Chart, Line Chart etc. on screen (HP graphic terminal, PC, or X) as well
>  as to printer (HP LaserJet, ploters, DeskJet), and can be directly
>  integrated into an Ingres Application, please do tell.
>

I'm told by Ingres representatives that VIGRAPH will be removed from
Ingres in 1993 and be succeeded by the graphical pakkage 'Grafsman'
(if I'm spelling it well). Grafsman would be platform transparant.
So make inquiries at your local Ingres Headquarter.

Jan.

>----------------------------------------------------------------------<
 A. van Setten                   | post to:  Post Office Box 354
 Delft University of Technology  |           2600 AJ DELFT
 Computing Centre                |           The Netherlands
 Campus Ingres Support           | ship to:  Julianalaan 134
 Phone   :  +31 (0)15-78 4821    |           2628 BL DELFT
   "     :  +31 (0)15-78 5012    |           The Netherlands
 Fax     :  +31 15-78 3787       | visitors: Michiel de Ruyterweg 10-12
 E-mail  :                       | RC-
     Jan.vanSetten@RC.TUDelft.NL | Helpdesk: Info@RC.TUDelft.NL
>----------------------------------------------------------------------<

Newsgroups: comp.databases.ingres
From: thomasl@mtl.mit.edu (Thomas J Lohman)
Subject: Re: QUEL and SQL in C.
Organization: MIT Microsystems Technology Laboratories
Date: Tue, 10 Nov 1992 02:39:10 GMT

I am curious if anyone can answer this question for me.
I was told by someone that Ingres used to translate all their
ESQL into the EQUEL equivalent at runtime.  I guess this means
that if you wrote an SQL application that eventually the QUEL
package would be used.  This led people way back when not to 
transfer our software to ESQL.

My question is, how are things done today?  Is it more efficient
to have things in ESQL or EQUEL, or does it make a difference?

Perhaps someone who is an expert on the low level optimization which
takes place can help me...

thanks,


--tom


Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: ABFimage question
Organization: 
Distribution: usa
Date: Wed, 11 Nov 1992 22:11:41 GMT

In article <1992Nov10.190946.24603@westford.ccur.com>, 
macdonal@westford.ccur.com (Steve MacDonald) writes:
> I have a question regarding abfimage creation. When I attempt to create an
> executable of my main menu selection, I get the following compilation messages.
> 
> abfimage eco main_menu -f
> Concurrent INGRES APPLICATION/IMAGE -- Copyright(c) 1988,1989 Ingres Corporation
> Compiling update_eco_data.osq
> No errors
>         ...
> mv: /user/ingres_db/ingres/eco/main_menu/update_eco_data.o and /user/ingres_db/i
> ngres/eco/main_menu/update_eco_data.obj are identical
> Compiling main_menu.osq
> No errors
> ...
> The text is clear as mud regarding the error messages. Now when I manually
> compile each application, they compile fine. Has anybody had any previous
> experience with this problem?

It sounds like something in ING_ABFDIR has gone haywire.  Whatever the
problem is, you can usually fix it by simply removing everything from
the ING_ABFDIR directory for this application 
(/user/ingres_db/ingres/eco/main_menu/*.o and *.obj).  Of course, then
ABF will have to recompile everything from scratch again, too.

When ABF compiles your code, it puts all the output from various
compilers (4GL to SC; SC to C; C to object code) in a subdirectory of
ING_ABFDIR.  The "abfimage" command does calls to system() to run OS
commands for it, and in this case it's doing a UNIX "mv" command.  This
isn't working for some reason, but it'll take someone with more UNIX
knowledge than I to figure out why not.  You could "cd" to the directory
and do "ls -i update_eco_data*" to find out if there's something funny
about the inodes.

(Aside: you should really use "imageapp", as "abfimage" is obsolete).  

Usually you don't mess with this directory, but when things like this go
wrong, I always just flush the files there and try again.

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.

Newsgroups: comp.databases.ingres
From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
Subject: Re: Ingres Advisor 
Organization: 
Date: Thu, 12 Nov 1992 20:47:11 GMT

In article <ASH.92Nov12100700@ulysses.mr.ams.com>, ash@ulysses.mr.ams.com 
(Alan Harder) writes:
> 
> I have had some good experiences with Advisor lately that I'd like to
> share...
> 
> All in all, a good job done on this by Ingres.

I second the motion.  Internet access and TSConnect are terrific
features for those of us who are lucky enough to be on the Internet.  

Thanks, guys!

--Mark Jaeger				internet: cs_mj@gsbvax.uchicago.edu
Graduate School of Business		yellnet:  (312) 702-0328
University of Chicago			faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.

Newsgroups: comp.databases.ingres
From: cbh@opus.mlb.semi.harris.com (Cherie Slasor)
Subject: Insert in ESQL/C
Date: Wed, 11 Nov 1992 13:25:03 GMT
Organization: Harris Semiconductor, Melbourne FL

I was wondering if anyone could help me with a problem I'm having with
ESQL using C.  I've used ESQL for a long time but had never tried doing
an insert with it.  That's what I'm trying to do now and it isn't 
inserting the data into the database.  The syntax I'm using is:

EXEC SQL INSERT INTO table_name (
			field_1,
			field_2,
			field_3
		   )
		   values (
			:variable_1,
			:variable_2,
			:variable_3
		   );

I can't find anything in the manuals that gives the exact syntax for an
insert in ESQL so I'm assuming it's the same as for SQL.  When I run the
debugger I find that it's definitely connecting to the database, because
it retrieves the correct data in all the right places.  The variables
are all being defined correctly.  The program runs very happily and never
crashes or gives an error message or anything.  The SQLCA error codes
seem to say that everything worked:

(dbx) p sqlca
sqlca = {
        sqlcaid = "SQLCA   "
        sqlcabc = 136
        sqlcode = 0
        sqlerrm = {
                sqlerrml = 0
                sqlerrmc = "                                                                      "
        }
        sqlerrp = ""
        sqlerrd = (0, 0, 1, 0, 0, 0)
        sqlwarn = {
                sqlwarn0 = ' '
                sqlwarn1 = ' '
                sqlwarn2 = ' '
                sqlwarn3 = ' '
                sqlwarn4 = ' '
                sqlwarn5 = ' '
                sqlwarn6 = ' '
                sqlwarn7 = ' '
        }
        sqlext  = ""
}

But the data is not being added to the database.  Any ideas?

Cherie Slasor
			
-- 
====================================================================
Cherie Slasor			     |	Harris Semiconductor
Phone:    (407) 724-7607	     |	P.O. Box 883, MS #62B-022
          cbh@mlb.semi.harris.com    |  Melbourne, FL   32902-0883
Newsgroups: comp.databases.ingres
From: macdonal@westford.ccur.com (Steve MacDonald)
Subject: Abfimage creation
Organization: Concurrent Computer Corp.  Westford, MA
Distribution: usa
Date: Thu, 5 Nov 1992 21:47:06 GMT
From: davek@kestrel.ims.com (Dave Koon)
Newsgroups: comp.databases.ingres
Subject: HP9000 vrs HP700 ingres performance.
Date: 7 Nov 92 00:21:52 GMT
Reply-To: davek@kestrel.ims.com
Organization: Integrated Measurement Systems


	We are seriously looking at ManmanX.   Since it will only
run on HP or Dec, we are more interested in HP.  Any ideas why
our sales person would suggest an HP 9000/837 series box 
instead of an HP 700 series box for a lot less money?  Is there 
something here that I do not understand?  BTW, we expect this
application to run with no more than 40-60 concurrent users.

	Any help would be appreciated.

Thanks,

Dave Koon


davek@ims.com
Newsgroups: comp.databases.ingres
From: alan@curta.cc.columbia.edu (Alan Crosswell)
Subject: Re: QUEL and SQL in C.
Organization: Columbia University
Date: Tue, 10 Nov 1992 14:53:05 GMT

In article <1992Nov10.023910.26593@athena.mit.edu> thomasl@mtl.mit.edu (Thomas  
J Lohman) writes:
> I am curious if anyone can answer this question for me.
> I was told by someone that Ingres used to translate all their
> ESQL into the EQUEL equivalent at runtime.  I guess this means
> that if you wrote an SQL application that eventually the QUEL
> package would be used.  This led people way back when not to 
> transfer our software to ESQL.
> 
> My question is, how are things done today?  Is it more efficient
> to have things in ESQL or EQUEL, or does it make a difference?
> 
> Perhaps someone who is an expert on the low level optimization which
> takes place can help me...
> 
> thanks,
> 
> 
> --tom

I think the big performance difference these days has to do with using
cursors vs. select loops -- which is documented in the release notes
I believe.  Cursors are "standard" SQL. Select loops, while non-standard, are 
analagous to the QUEL retrieve loop (e.g. the only way to do it in QUEL
prior to the addition of cursors to QUEL).  Select loops are faster
than cursors -- but of course you can't do any other database operations
within the body of a select loop.
/a
Newsgroups: comp.databases.ingres
From: nariani@tiamat.cc.nd.edu (Sunil Nariani)
Subject: Printing out all Windows4gl Scripts.
Keywords: documentapp, Windows4gl, script
Reply-To: nariani@tiamat.cc.nd.edu (Sunil Nariani)
Organization: University of Notre Dame, Notre Dame
Date: Mon, 9 Nov 1992 18:49:53 GMT




I need a utility to print out all scripts of all frames
and procedures of a Windows4gl application without specifying
their names.

The utility documentapp does this but also attaches 
a lot of extra frame/constants decription information along with it
which I don't require. 

I need to write such a utility in either C (embedded sql) or
using Windows4gl.  Could someone give me general guidelines
to approach this problem, i.e. which table components in 3gl or
which classes/methods in Windows4gl should I be using.


-- 
-------------------------------------------------------------

All I ask is a chance to prove that money can't make me happy.

Sunil Nariani
Network Analyst
G008	OUC             My opinions are exactly that, MY opinions.
Univ of Notre Dame.
(219) 239-8575
(219) 271-1514

--------------------------------------------------------------

Newsgroups: comp.databases.ingres
From: Mike Stramba <stramba@zooid.guild.org>
Subject: Re: INGRES FAQ???
Organization: ZOOiD BBS
Date: Fri, 13 Nov 1992 09:35:12 GMT

fmn@nevada.edu (FRANK NEEDHAM) writes:
>
>Is there anyone out there who knows where a faq for ingres resides and would 
>be able to show me where it is?

I'm also interested in the same information

Mike Stramba	
Etobicoke,Ont

Newsgroups: comp.databases.ingres
From: melkor!valandil!mal (Michael A Leo)
Subject: Shared libraries and Ingres
Organization: National Radio Astronomy Observatory
Date: Thu, 5 Nov 1992 16:42:59 GMT


Hi,

  Our product uses Embedded C to access the tables
in our Ingres database.  

  Unfortunately, Ingres does not supply libingres.so,
so each of our binaries is 1/2 MB minimum, no matter
how trivial.

  Has anyone solved this problem?  Is there a way to
make a shared library out of libingres.a?  Will Ingres
ship a shared library?

Thanks,

Mike Leo
mike.leo@adc.com

NOTE!!  My header is still hosed up, so don't use
        "reply" on this message.  Sorry.
From: civil8@itakura.nuee.nagoya-u.ac.jp (Ito Labolatory(Civil. Eng.))
Newsgroups: comp.databases.ingres
Subject: PDS of Ingres
Date: 11 Nov 92 05:07:49 GMT
Distribution: comp
Organization: Itakura Lab., Dept. of Elec. Eng., Nagoya Univ.


Hi

Can you please tell me about the availability of Ingress
as a PDS?

Thank you

Amin Hammad
Nagoya, JAPAN
--

 --  $@L>8E20Bg3X(J $@>pJs9)3X2J(J $@HDAR8&5f<<(J  --  $@3aED(J $@>-;J(J (M2)
  
Newsgroups: comp.databases.ingres
From: CS_PAUL@GSBVAX.uchicago.edu (Paul Ford 312/702-0335)
Subject: re: Finding all tables and table definitions.
Organization: National Radio Astronomy Observatory
Date: Thu, 5 Nov 1992 16:07:24 GMT


Sunil Nariani writes:

>My question is how can I get this listing of which tables
>exist in a database and their field definitions using a C program
>with embedded sql or using Windows4gl ?

Do what INGRES does when you do 'help' and 'help table': query the
system catalogs, in particular the views iitables and iicolumns.  These
are documented in full in the INGRES/SQL Reference Manual, Appendix D,
The INGRES System Catalogs.

To see what queries INGRES is actually performing for help and help
table run this little script (VMS and Unix alternatives separated by |).

        define|setenv II_EMBED_SET printqry
        sql iidbdb
            help \g
            help iirelation \g
            help table iirelation \g
            \q
        deassign|unsetenv II_EMBED_SET
        eve|edt|vi|emacs  iiprtqry.log

The file iiprtqry.log contains the text of all the queries performed
during the terminal monitor session.

Paul Ford

GSB Computing Services                  312.702.0335
University of Chicago                   cs_paul@gsbvax.uchicago.edu
1101 E. 58th Street
Chicago IL 60637
From: civil8@itakura.nuee.nagoya-u.ac.jp (Ito Labolatory(Civil. Eng.))
Newsgroups: comp.databases.ingres
Subject: PDS of Ingres
Date: 13 Nov 92 05:51:10 GMT
Distribution: comp
Organization: Itakura Lab., Dept. of Elec. Eng., Nagoya Univ.


Hi 

I am posting for the second time asking about any PD version
of Ingres. I think that it is available somewhere and I hope 
one of you will tell me where.

Thank you.

Amin
--

 --  $@L>8E20Bg3X(J $@>pJs9)3X2J(J $@HDAR8&5f<<(J  --  $@3aED(J $@>-;J(J (M2)
  
Newsgroups: comp.databases.ingres
From: najman@hadassah.bitnet (Hadassah University Hospital. Jerusalem, Israel)
Newsgroups: comp.databases.ingres
Subject: Loading apostropes to tablefield
Date: 11 Nov 92 15:56:12 +0200
Organization: Hadassah Medical Center. Jslm Israel


subject: loading apostrophes to tablefield

----------------------------------------------------------------
Could anyone help us with our problem??

We're running Ingres Version 6.4/01 (vax.vms/01).
We have some tables with apostrophes (') in char data fields.
ISQL & QBF seem to have no problems loading the data.
When the data is loaded into a tablefield we get the following error message:

Program data can not be used for specified attribute, data types are
incompatible.

Is there any way around this problem & still maintaining the apostrophes
in the data.

Thanks.
Yisrael Blatman
Hadassah University Hospital.
--