HDTenEightyP/NetNews huggingface dataset:
From: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  ESQL/C and error msgs
Date: 23 Jul 92 12:48:03 GMT
Reply-To: widener!obelix.informix.com!johnl@emory.mathcs.emory.edu (Jonathan Leffler)
X-Informix-List-ID: <list.1336>


>From: uunet!strengur.is!snorri (Snorri Bergmann)
>Subject: ESQL/C and error msgs
>To: informix-list@rmy.emory.edu (Informix - List)
>Date: Wed, 22 Jul 92 9:06:08 CUT
>X-Informix-List-Id: <list.1333>
>
>Is there function in esql/c to get the SQL error message if you have the
>sql error code? (Similar to ERR_GET function in 4gl).

The answer is yes: the function is rgetmsg.

rgetmsg(msgnum, msgstr, len)
short	msgnum;
char	*msgstr;
short	len;

If you're creating function prototypes, treat the shorts and ints.

This is an RTFM question if you have ESQL/C Version 4.00 or later.

Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>
Newsgroups: comp.databases.informix
From: spw@ccd.harris.com (Steve Wallick)
Subject: Co-op position available
Organization: Harris Controls and Compositions
Distribution: us
Date: Wed, 29 Jul 1992 15:49:54 GMT



******************************************************************************
		HARRIS PUBLISHING SYSTEMS CORPORATION
		   505 N. John Rodes Blvd, Bldg. 1 
		     Melbourne, Florida 32934-9196
******************************************************************************

SOFTWARE ENGINEERING CO-OP POSITIONS

Harris Corporation with annual sales of over $3 billion, is a producer of 
state-of-the-art information processing, communication, and microelectronic 
products for the worldwide information technology market.  Our Publishing 
Systems subsidiary, located in Melbourne FL, is a leading producer of 
Computer Graphic Systems for the newspaper industry.  The evolution of our 
exciting new family of Engineering Workstation and PC-based products for 
interactive Newspaper Layout and Electronic Photo Processing provides a 
number of cooperative education opportunities within our Engineering 
Department.

SOFTWARE ENGINEERING (BUSINESS APPLICATION) CO-OP

In this position you will work with Software Engineers to perform a variety 
of tasks associated with developing and implementing an integrated business 
information system.  You will be exposed to the latest technologies of open 
systems and business management software.  Your responsibilities will include 
database applications programming in SQL (I4GL) to adopt standard software to 
custom needs.  Working knowledge of database concepts is required.  SQL, C, 
and UNIX experience is helpful. 

This assignment will be double block in duration.

Contact Tim Kirk, e-mail harris.tkirk@ic1d.harris.com or phone (407) 242-4440.
Harris is an equal opportunity employer M/F/H/V

	Experience the difference at Harris Publishing Systems.

******************************************************************************
   
******************************************************************************
Xref: sparky comp.databases.informix:1591 comp.databases:5758
From: bkuhn@rhlab.UUCP (bmk Bradley Kuhn)
Newsgroups: comp.databases.informix,comp.databases
Subject: Problems with temporary tables in INFORMIX
Keywords: informix, 4gl, temp tables
Date: 22 Jul 92 16:33:33 GMT
Followup-To: poster
Organization: Baltimore Rh Laboratory, Inc., Maryland


We are running DOS INFORMIX-4GL  V 1.10.06E on a 286 Librex notebook
running MS-DOS 5.0.  We use the protected mode engine, and protected mode
applications.

  Much of our code uses temp tables ; Often we execute statements such as
the following :

create temp table foo (s serial, x int, str char(20))
.
.
declare c_mumble cursor for
   select int_val, str_val from another_tab

foreach c_mumble into prg_var_int, prg_var_str
    insert into foo values (0, prg_var_int, prg_var_str)
end foreach
.
.
.
.
drop table foo


This code works fine, if we only execute the sequence once per program
run.  However, when we attempt to create the temp table again, using the same
sequence of code we get this error on the first insert attempt:

Program stopped at [line of insert command]
SQL statement error number -242.
ISAM error number -9.
Could not open database table (foo)

We cannot understand why it cannot open the table, since the program just
created it a few lines before.  Obviously, it has something to do with 
dropping then creating it again, but we can figure out why.  The code works
perfectly on INFORMIX-4GL V 4.00 running on our AT&T 3B2/600 under
AT&T UNIX SYS V R3.2.3.

We attempted to remedy the problem by using a permenant table instead of 
a temp table.  This executes better (i.e. we can drop and re-create more than
once), but after about 4 drops and recreates it complete corrupts the database,
so that it must be deleted and re-created. 

 Has anyone had any problems of this nature with the PC version?

Any help will be appreciated.
Post to comp.databases.informix or by EMAIL.
 -- 
   __                 _             _ _ _      _   ,
  /  )             / //            ' ) ) )    ' ) /       /
 /--<  __  __.  __/ // _  __  ,     / / /      /-<   . . /_  ____
/___/_/ (_(_/|_(_/_</_</_/ (_/_    / ' ( o    /   ) (_/_/ /_/ / <_
                            /
                           '
 -- Bradley M.  Kuhn  Computer Systems Development, Inc
     INTERNET: rhlab!bkuhn@uunet.uu.net OR bkuhn@loyola.edu
     UUCP:     ...uunet!rhlab!bkuhn
From: bmacwill@letterkenn-emh2.army.mil ("B.T. MacWilliams")
Newsgroups: comp.databases.informix
Subject: DBLOAD!?
Date: 21 Jul 92 13:53:07 GMT
Reply-To: bmacwill@letterkenn-emh2.army.mil ("B.T. MacWilliams")
X-Informix-List-ID: <list.1330>


>I'm experiencing crashing with dbload, making it difficult to know what's
>going wrong.  I've already discovered that the 'DELIMITER' keyword only
>works in lowercase, but the following dbload program just coredumps.
>Since I'm fairly new to Informix - is dbload generally so flakey?
>
>    FILE "vme_database" delimiter "|" 7 ;
>        ( project, manufact, model, serial_num, descrip, proj_id, comment )
>        values ( "gammasphere", f01, f02, f03, f05, f06, f07 );
>
>Informix SE, ISQL 4.00.UH1, SunOS 4.1.2


I recall having a strange problem like this and I didn't document it well.
Try putting "delimiter" in  CAPS: "DELIMITER". I hope this helps.

						Brian MacWilliams
						USAMC SIMA HQ
						CHAMBERSBURG PA

Newsgroups: comp.databases.informix
From: jka@windshear.larc.nasa.gov (J. Keith Alston)
Subject: User defined signal 1 on dbload???????
Organization: NASA Langley Research Center, Hampton, VA  USA
Date: Fri, 24 Jul 1992 13:26:11 GMT

Hi,
  I'm using Informix v4.1 on a Sun SPARCstation 2. I have a dbspace , with
3 chunks and each chunk is a different disk partition. I needed to decrease
the size of one of the chunks to regain some unix file system space. I
tbunloaded all of the databases in this dbspace, dropped the databases, and
dropped the dbspace. I then recreated the dbspace, and the 3 chunks(2 the same
size as before, 1 smaller). I've successfully reloaded some of the databases
with tbload, but on some I get the error:

User Defined signal 1

It appears that the database is loading, but it gets dropped because of the
error.  Does anyone out there have any idea what this error is, and/or how
I can get around it. Thank you.
-- 
************************      Don't just do it!     ***********************
Lockheed Eng. and Sci. Co./Nasa Larc|J. Keith Alston jka@windshear.larc.nasa.gov
From: carsmax!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein)
Newsgroups: comp.databases.informix
Subject: Re: Online 4.1 shared memory initialization
Date: 25 Jul 92 03:08:06 GMT
Reply-To: carsmax!carsmax!bryan@uceng.uc.edu (Bryan Klopfenstein)
X-Informix-List-ID: <list.1341>

Juergen Roberg says:
> Problem using Informix-Online 4.1
> When I try to start isql I get the following error messages:
> 
> -529	Cannot attach to shared memory.
> 	[...]
> -123	ISAM error: no shared memory
>	[...] 
> 
> This seems to be a problem solved easily, but

Yeah, my first thought was that your engine was down -- but read on...

> 1) on call of tbinit you get the message: shared memory already initialized
> 2) there are no users connected.
> 
> Has anybody out there any opinions ?

Check the INFORMIXDIR, TBCONFIG, and SQLEXEC environment variables. The
engine must be up, but one or more of these variables doesn't match the
engine's environment, so isql is looking in the wrong place.

If TBCONFIG and SQLEXEC are not set, make sure that the engine is using
the tbconfig file "$INFORMIXDIR/etc/tbconfig".

Hope this helps...
-- 
Bryan Klopfenstein			try: bryan@cinnet.com
CARS Information Systems, Inc.		or: ..uunet!uceng!cinnet!carsinfo!bryan
Cincinnati, OH				better: usr10300@tso.uc.edu
		Standard Disclaimers Apply

Newsgroups: comp.databases
From: cmiller@watserv1.waterloo.edu (Craig Miller - DCS)
Subject: Simple, easy-to-use unix databases for end-users
Organization: University of Waterloo
Date: Wed, 22 Jul 1992 18:12:39 GMT

  Hi.  As the subject suggests, I'm looking for a straightforward database
for novice unix users (on vt100-emulating terminals no less!). 

  The database would be used for basic data manipulation, uncomplicated
searches, and generating reports, and would contain stuff like students'
marks and equipment lists.  The user would have some database experience
but little unix knowledge. 

  Would something like FoxPro or Paradox fit all these requirements?  Or
am I living in a dream-world for even seeking such a database? (break it
to me gently)

  All comments or suggestions are welcome.  My e-mail address is:
cmiller@watserv1.uwaterloo.ca

Thanks,
Craig.
Newsgroups: comp.databases
From: datkins@carina.unm.edu (Drexel Atkinson CIRT)
Subject: Request for Text Retrieval Info 
Date: Mon, 27 Jul 92 15:51:51 GMT
Organization: University of New Mexico, Albuquerque


  This may the wrong news group to ask for this, but I haven't found a 
more appropriate one.  I am reviewing our current text retrieval program
(searchmate) and would like to get additional information on other text
retrieval programs, including their capabilities, problems, costs, etc.
Any information would be more than I currently have.  I currently retrieving
the program gopher and am going to take a look  at it.  Anyone know this 
program?  How about some others?

thanks,
	_drex

   
---------------------------------------------------------------------------
    Drexel Atkinson 			BITNET:  	datkins@unmb
    Systems Programmer			INTERNET:     	datkins@ariel.unm.edu
    CIRT-ACS  University of New Mexico  
    
Newsgroups: comp.databases
From: gaujxl@samhain.fnma.com (Jacob Lifshitz)
Subject: Re: Sybase rounding problem
Keywords: Sybase Rounding
Organization: Fannie Mae, Washington, DC
Date: Wed, 22 Jul 1992 12:14:48 GMT

In article <rjmartin.711766123@extro.ucc.su.OZ.AU> rjmartin@extro.ucc.su.OZ.AU (Trilogy Business Systems) writes:
>
>Does anybody know of a way to force Sybase to round money fields to 2 decimal
>places e.g.
>
>	123.4549 --> 123.45
>	123.4550 --> 123.46
>
>John Martin
>Software Manager
>Trilogy Business Systems Pty Ltd. (Aust)

On page 2-126 of the Command Reference Manual for release 4.2 (May 90)
under the heading: Functions, sub-heading 4: Mathematical Functions it says:

round (numeric-expr, integer-expr)	Rounding of a numeric expression to
					the precision specified in
					integer-expr.  The expression can be
					of integer, float, or money type.
					type as the numeric expression.

kobi
From: walz@elde1.epfl.ch
Newsgroups: comp.databases
Subject: Index management source code required
Date: 31 Jul 92 16:22:17 GMT
Organization: Ecole Polytechnique Federale de Lausanne



I'am looking for public domain or cheap (<$300) C source code for index file
management.

Any ideas ?


Thanks 


Michael Walz
walz@elde.epfl.ch



Newsgroups: comp.databases
From: lung@venice.sedd.trw.com (Diane Lung)
Subject: Re: Sybase and Interactive woes
Organization: TRW Systems Engineering & Development Division, Carson, CA
Date: Wed, 22 Jul 1992 17:35:12 GMT

In article <rjmartin.711764896@extro.ucc.su.OZ.AU> rjmartin@extro.ucc.su.OZ.AU (Trilogy Business Systems) writes:
>mosmith@asc386 (Matt Smith) writes:
>
>>We are currently using version 3.2 of Interactive and
>>version 4.2 of Sybase.  As the subject implies, we seems to be having
>>great difficulty keeping the Sybase server up.  If there is anybody
>>out there using this configuration or could suggest a better one, I would
>>really like to hear from you.
>
>We are currently running 4.2 on SCO ODT 1.1 and SCO Unix 3.2., and while we 
>have had our fair share of problems, the system is up around 99%+ of the time.
>Our local sybase people are fairly helpful, although when we get really
>hairy problems they are referred back to the U.S.
>
>Something to be really careful about is the number of streams parameters 
>configured in the kernal. The first set of release notes were ** WRONG ** 
>about how many to set up (I think they just thought of some numbers that
>would never be exceeded). You can use the crash command, and then use strstat
>to see how these are going, also make sure you have a good reliable maths 
>co-processor (387 compatable), apparently this can cause problems. One last
>thing to look at is the amount of available free ram, and if all else fails,
>try dumping the database, re-install, and start from scratch. We had some 
>problems with a demo machine that used unix files as the database devices,
>and occasionally it wouldn't be able to open the log device, thereby marking
>the associated database as being hopelessly corrupt. I then manually changed
...

Another item you might check (related to the number of streams) is the
number of connections that your SQL Server is configured for - remember
that each database device requires a connection. On Interactive I have had
similar problems when the Server would come up and fail on bringing up
database/log devices and mark them corrupt. In this situation, it was the
case that the SQL Server had not been configured for enough connections.

    Howie

**********************************************************
Internet:    howie%ranger@venice.sedd.trw.com
Prodigy :    DBKX34A

All opinions are my own and not my employer's.
**********************************************************




-- 
lung@venice.SEDD.TRW.COM
Newsgroups: comp.databases
From: des@helix.nih.gov (David E. Scheim)
Subject: Re: PC client apps -> Sybase SQL server
Organization: National Institutes of Health, Bethesda
Date: Mon, 27 Jul 1992 14:44:49 GMT

In article <1992Jul22.205435.16420@welchgate.welch.jhu.edu> glenn@welchgate.welch.jhu.edu (Glenn M. Mason) writes:
>
>
>We are currently running Sybase SQL server on a networked Sun SPARC platform.
>I am currently interested in developing database front-end applications on
>the PC platform running under DOS and possibly Microsoft Windows that access
>a Sybase SQL server on a Unix server. I am particularly interested in develop-

We've been happy with the tool JAM from JYACC which supports several front
end platforms, including DOS, Windows, and OS/2, and several backend
database servers.  It uses productive, event-driven application
development, makes small, royalty-free run-time executables, has total
flexibility for screen and keyboard control, and runs very quickly.  
Newsgroups: comp.databases
From: cm@impmh.uucp (Colin Manning)
Subject: Wanted: introductory literature on OO databases
Organization: Integrated Micro Products Ltd
Date: Mon, 27 Jul 1992 09:30:51 GMT

Could someone suggest to me suitable literature describing
object oriented databases.
Many thanks,
- Colin Manning    cm@impmh.uucp
Newsgroups: comp.databases
From: news@tamsun.tamu.edu (Read News)
Subject: Novice Clipper Question!
Organization: Texas A&M University, College Station
Date: Fri, 31 Jul 1992 03:52:32 GMT

hi, there,
 I 'm a clipper novice.
 I know by using "extend.h", we can run some "C" routines
 embedded in clipper codes, but how about C++?
 if possible, how it works? anyone tried before?

 Thanx in advance

Y. Wan


Newsgroups: comp.databases
From: westrich@mira.ncc.umn.edu (Brian Westrich)
Subject: Re: Features of MEDICAL Databases
Keywords: medical databases
Organization: University of Minnesota, Nutrition Coordinating Center
Date: Mon, 27 Jul 1992 21:34:26 GMT

In article <1992Jul27.105628.9055@cs.hw.ac.uk> jian@cs.hw.ac.uk (Jian Hu) writes:
>I'm involving a project to deal with medical databases and I need to have
>some knowledge of the distinct features of the medical databases or medical
>information systems. Could anybody give me some hints or recommend some
>references?

This is an introductory text on Medical Information Management.

Shortliffe E and Perreault L  (1990)  Medical Informatics.
Addison-Wesley.


This is a collection of writings on various HIS's:  

Orthner and Blum, eds.  (1989)  Implementing health care information
systems.  Springer-Verlag.

Good luck!


 -- Brian

-----------
Brian Westrich  				
Nutrition Coordinating Center (NCC)     internet: westrich@keystone.ncc.umn.edu
University of Minnesota (USA)           phone:    (612) 627 4862
-- 
Brian Westrich  				
Nutrition Coordinating Center (NCC)     internet: westrich@keystone.ncc.umn.edu
University of Minnesota (USA)           phone:    (612) 627 4862
From: thyerj@HAMLET.UNCG.EDU (Jonathan S. Thyer)
Newsgroups: comp.databases
Subject: FoxView to FoxPro screen conversions
Date: 24 Jul 92 20:36:33 GMT

I am looking for a program to convert screens from FoxView 1.02 to FoxPro 2.0.
Does anyone have such a thing or know of anyone (company) that has it?
Please EMAIL the response as I have no news feed.
Thanks in advance.
----------------------------------------------------------------------
 Jonathan S. Thyer, Programmer/Consultant
 235Q Bryan Building                 InterNet: thyerj@steffi.uncg.edu
 UNC-Greensboro                      BitNet  : thyerj@uncg.bitnet
 Greensboro, NC 27412                Phone   : (919) 334-5699
----------------------------------------------------------------------
Newsgroups: comp.databases
From: g88m0396@alpha.ru.ac.za (Jon-Dean Mountjoy)
Subject: FTP site for CLIPPER software/libraries request.
Summary: FTP site for CLIPPER software/libraries request.
Keywords: FTP, CLIPPER
Organization: Rhodes University, Grahamstown, South Africa
Date: Fri, 31 Jul 1992 09:56:12 GMT

Hello World

I am looking for some ftp sites which hold clipper libraries or any
such software.  Could someone please mail to me any such information.

Thanking you 

Jon-Dean Mountjoy
csjm@beta.ru.ac.za
--
-------------------------------------------------------------------------------
     Jon-Dean Mountjoy     g88m0396@beta.ru.ac.za        Rhodes University
-------------------------------------------------------------------------------
From: jlewis@astro.as.arizona.edu (Jeff Lewis)
Newsgroups: comp.databases
Subject: Sybase/Realtime
Date: 21 Jul 92 22:04:40 GMT
Distribution: usa
Organization: University of Arizona, Tucson, AZ


 wfinnert@larry.shearson.com (Warren Finnerty) writes - 

        I cannot tell from this post whether you are interested in "real_time"
        or "online_and_really_fast_time". Real time implies able to keep up
        with externally driven events, which implies extremely predictable 
        performance. None of the RDBMS's that I know of are very good at that. 
        They tend not to have robust priority scheduling; and predictability 
        doesn't go hand-in-hand with black box caching and ad-hoc queries. 
        SYBASE is however a *very* good OLTP database. 
 
Thanks for the reply - my particular application involves realtime data as 
in milliseconds between events...but with proper buffering I was hoping that 
some DBMS could keep up...I am talking about 40K events per hour maximum with 
data available for stats shortly after.  shortly indicating minutes. 
 
Also - does anyone have any input as the how well Sybase deals with RPC's? 
 
Thanks in advance. 
 
Jeff Lewis is jlewis@astro.as.arizona.edu
From: mayer@andromeda.rutgers.edu (Warren Mayer)
Newsgroups: comp.databases
Subject: Info Please: DOS dbms to handle ~150,000 records with video capability
Summary: A dbms to be used for a museum collections mgmt. 150,000 records. Video
Keywords: database dbms video image
Date: 24 Jul 92 14:12:07 GMT
Organization: Rutgers Univ., New Brunswick, N.J.

This is a reposting after getting the original request redefined.

I am posting for a friend who lacks internet access.  We are looking for a DOS
database management program which can handle upwards of 150,000 records. This
dbms must meet the following criteria:

* flexible enough to be used by both programmers and non-programmers alike
* must be able to store/retrieve/manipulate approximately 150,000 records
* must have video storage capability:  storage of photographs, video images
* must have extensive reporting capability (reports generated for Annual Rpts,
  etc.)
* MUST be FAST in it sorting/searching/retrieving/updating

This program must run on in a DOS environment.  The system it will be used on
will be either a very fast 386 or 486 system.

This program can be DOS or Windows-based.

Please send information directly to me at:  mayer@andromeda.rutgers.edu

and/or post directly here.

Thank-you

Warren Mayer
Rutgers University Computing Services - Newark, N.J.
-- 
  *      **               Warren Mayer                  rutgers!andromeda!mayer
   *   *    *    **       mayer@andromeda.rutgers.edu   mayer@draco.bitnet
    * *      * *    * **  Rutgers University Computing Services - Newark, N.J.
     *        *      *  * * * * * * * * * * * * * * * * * * * * * * * * * * * *
-- 
  *      **               Warren Mayer                  rutgers!andromeda!mayer
   *   *    *    **       mayer@andromeda.rutgers.edu   mayer@draco.bitnet
    * *      * *    * **  Rutgers University Computing Services - Newark, N.J.
     *        *      *  * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Newsgroups: comp.databases
From: jka@windshear.larc.nasa.gov (J. Keith Alston)
Subject: clipper 5.01 and DOS 5.0 
Organization: NASA Langley Research Center, Hampton, VA  USA
Date: Tue, 28 Jul 1992 13:19:38 GMT

Hi,
   I have an application that I have compiled with clipper 5.01 under DR DOS
6.0.  It compiles and runs fine under DR DOS 6.0 with the CLIPPER=F50 environment
variable set. when I attempt to run this same program on another machine, running
DOS 5.0 with the CLIPPER=F50 env variable set I get DOS error number 4, which
is, I believe, a " not enough file handles" error. I have FILES=55 and
buffers=30 on both machines. Also I've tried increasing the f50 and the FILES
to higher numbers, without luck. Does anyone out there have even the slightest
clue as to what might be the problem?
-- 
************************      Don't just do it!     ***********************
Lockheed Eng. and Sci. Co./Nasa Larc|J. Keith Alston jka@windshear.larc.nasa.gov
From: steve@hpuplca.nsr.hp.com (    Steve de Simon)
Newsgroups: comp.databases
Subject: UNIFY 4GL termcap problem
Date: 29 Jul 92 10:44:44 GMT
Organization: Hewlett-Packard Neely Golden Gate Area (Northern Calif.)

Has anyone been successful using UNIFY 4GL with an HP terminal?  We are
not able to use their termcap entry for HP, although other brands of
terminal termcaps seem to work OK.  We need to get it working on HP. 
Right now the screen does not repaint properly after the line-drawing
character set has been used.  Help!

Steve de Simon
Hewlett-Packard
steve@hpuplca.nsr.hp.com
Newsgroups: comp.databases
From: ctorres@cco.caltech.edu (Chon David Torres)
Subject: Code Base
Summary: questions concerning codebase
Keywords: new versions should i get them?
Organization: California Institute of Technology, Pasadena
Date: Tue, 21 Jul 1992 22:14:22 GMT

hello,
  i have a copy of codebase4 and recently i saw that 4.2 exisited. (I haven't
programmed for awhile). Does 4.2 have any really good new features? should
i buy it?
     Thanks,
     - chon

-- 
ctorres@juliet.caltech.edu              | "Just for one moment I thought 
ctorres@cco.caltech.edu                 |  I'd got my way
                                        |  Destiny unfolded - 
"Dreams make no promises"               |  watched it slip away ..." Ian Curtis
Newsgroups: comp.databases