HDTenEightyP/NetNews huggingface dataset:
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Question: Can I embed SQL in C++
Date: 7 Oct 92 20:33:18 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1507>

Quoting Low Chee Meng (KSL)...
} 
} I would like to know if anybody has any experience/success writing
} embedded SQL statements inside a C++ program.
} 
} We have an Informix database and a ESQL pre-processor meant
} for C. According to the local agent from Informix, the SQL
} pre-processor works only on C files, not C++ files. 
} We intend to use GCC as our C++ compiler, but we do not know
} how to make the pre-processor work with GCC.
} 
} Is there any way to work around the abovementioned problem? 
} 
To make the ESQL/C pre-processor work with gcc, do this:
 1) vi $INFORMIXDIR/bin/esql
 2) Change the "cc" near the bottom of the file to "gcc"
 3) save your changes

As for the C++ thing, you're on your own.

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: neil@salmon.demon.co.uk ("Neil S. Briscoe")
Subject: char database types blanks and nulls
Date: Tue, 13 Oct 1992 09:41:05 +0000

Rob,

In article <1992Oct12.225029.2143@advtech.uswest.com> Rob Yslas posted
the following code:

>$string column1[20];

>$declare test_curs cursor for
>select distinct column1
>into $column1
>from test_table
>where column1 is not null;
>$open test_curs;
>$fetch test_curs;

He then stated that using the string datatype, trailing spaces would
be truncated (interesting, I didn't know that but I don't have the
Esql/C manuals).

Your cursor will certainly not return fields that have actually been
written with the NULL value.  However, imagine a field that has been
written to the table SPACE filled.  It will be returned by the cursor.
The action of the string data type (by Rob's definition) leaves it
clipped.  Informix has no option, therefore, but to leave the
variable with a NULL value.

Hope this helps

Regards
Neil

Neil S. Briscoe				Telephone: +44 252 376737
System Administrator			Fax:       +44 252 376644
                                        Email: neil@salmon.demon.co.uk
                                               nbriscoe@cix.compulink.co.uk
Bartec Medical Systems Ltd.
Impression House
Invincible Road				"!##@!** Listen who swears
Farnborough				Christopher Robin has fallen downstairs"
Hants GU14 7NP				-- The Goodies Book of Criminal Records
England
"A man is incomplete until he's married -- then he's finished!"
-- seen on a desktop calendar
From: villy@uunet.uu.net (Will Hartung - Master Rallyeist)
Newsgroups: comp.databases.informix
Subject: Auditing thoughts...
Date: 15 Oct 92 23:03:09 GMT
Reply-To: villy@uunet.uu.net (Will Hartung - Master Rallyeist)
X-Informix-List-ID: <list.1517>


     We've got a client running OnLine for their application. They
     want to note every time someone changes a field in their
     application (i.e. who changed what field on which record and what
     did they change it from).

     Try as we might to convince that this kind of control is better
     maintained to a set of procedures and transaction histories, all
     of our arguments have fallen on deaf ears. They don't seem to
     care that when someone enters a record with 20 fields in it, that
     their 'audit trail' table will get 20 rows added to it. We can't
     seem to convince them that they are going to produce an insane
     amount of information that they'll probably never be able to use.

     The idea is when they track down a discrepancy that was due to
     something being changed, they'll want to know who did it. "We
     don't have those kind of controls now" they say. Heck, they don't
     have ANY controls now.

     I'm just looking for some options to their grand design. The way
     they've got it set up right now is going to be just absolute
     madness to the system. There will more time spent logging all of
     these audit trails then getting work done. If they were using SE,
     I could rig something up with auditing (maybe), but they're
     running OnLine, and that's not an option.

     Of course, I'me hearing from our side "It's their nickel, let
     them make the call".

     So, I'm looking for alternative ways of tracking changes made to
     a database. Preferably something that won't be really
     overbearing. Any hints will be appreicated.

     Thanx!

     Will Hartung
     (uunet!la4gen!villy - or - me@zipbang.socal.com)
From: acw@siesoft.co.uk (Andy Watson)
Newsgroups: comp.databases.informix
Subject: Query By Example in 4GL
Date: 15 Oct 92 18:34:45 GMT
Organization: Siemens Nixdorf Information Systems Ltd.
X-Newsreader: Tin 1.1 PL4

When one uses the CONSTRUCT command in 4GL it blanks the listed screen 
fields before allowing user input. Does anyone know of a means of 
avoiding this, or alternative ways of achieving the functionality below.

a) To allow the user to edit his previously entered criteria (e.g. his 
first search returns far less than he expected)

b) Use a QBE on two fields to search Table 1. Only if that fails search
using the same values on table 2. One way I've thought of is to replace
the Table 1 column names in the return field of the original CONSTRUCT.

Informix 4GL V1.1 by the way, but V4.0 manuals don't look any different

Thanks in Advance

===============================================================================
                "Disclaimer, witticism, political statement."
Andy Watson - Consultancy Department - Siemens Nixdorf Information Systems 
Bracknell, England                     E-mail   : A.Watson@siesoft.co.uk
===============================================================================
From: "clay irving" <clay.irving@execnet.com>
Newsgroups: comp.databases.informix
Subject: dbexport.
Date: 7 Oct 92 17:04:03 EST
Reply-To: "clay irving" <clay.irving@execnet.com>
Distribution: comp
Organization: Executive Networks Information

On 10-07-92  David Kosenko writes:


|In article <9655@emory.mathcs.emory.edu> mana-s@ascii.co.jp (Manabu 
|Shimohira) writes:
|>
|>Hello to networld.
|>
|>Is there anybody who can let me understand why the dbexport is not
|>suitable for database backup, or why I should avoid using dbexport
|>for database backup.
|>
|>I thought the dbexport and dbimport is a handy method for archiving
|>data with their schema.
|>
|>But I can find several caution to not to use dbexport for database
|>backup (ex. p4-7 in I-SE ADMIN, p5-24 in GUIDE TO SQL TUTORIAL,
|>p3-113 in I-OnLine ADMIN.. all for v5.0)
|>
|>There will be some reason not to use dbexport. I just want to know 
|why.
|
|I didn't email this as I'm sure there is some general interest in the
|topic.
|
|The answer has several parts.  First, and I think most important, is 
|that logs cannot be applied to a database restored via dbimport.  So your
|backup is a static picture of the database at a particular moment in 
|time.
|If it is sufficient to restore your system to that point only, then
|dbexport may be an appropriate choice for backup for you.  However, the
|secondf part is that dbexport takes a long time and locks the database
|while it does its work.  This means that you cannot access any data 
|until the export is complete.  Again, if this is acceptable for your 
|application, then dbexport may be the right choice.  If you are using 
|OnLine, you probably want to minimize downtime, so the OnLine backup 
|utilities will be more useful, since the allow on-line archiving as well 
|as full restoration from logs.  If you are using SE, then you would use a 
|Unix backup utility.
|Again, if you are not using a log (or don't need to recover xactions
|from the time of the last backup to the time of the crash), then 
|dbexport may be ok.  Bear in mind that it will take longer than a dd (for 
|example) and it will take longer to restore the database, should you need 
|to (again, compared to dd or equivalent).

When you load the database from the dbimport hasn't the extent information 
been lost?...

---
  WinQwk 2.0b#480  Failed gymnast:  A flip flop
--
Executive Network Information System  (914) 667-4567
International ILink Host
From: ptm@xact.demon.co.uk (Paul Thomas Mahoney)
Newsgroups: comp.databases.informix
Subject: OnLine Mirroring
Date: 12 Oct 92 11:26:27 GMT
Organization: X-Act Solutions Limited

When you INITIALISE an OnLine system you can enable/disable the disk mirroring
capability. If you enable mirroring you can later, optionally, enable disk
mirroring of dbspaces.

We have now decided not to employ mirroring of dbspaces. What performance
overhead have we incurred because we said "yes" to the initialisation time
mirror parameter?

-- 
Paul Mahoney, X-Act Solutions Limited
smail: 20 Shipley Lane, Cooden, Bexhill-on-Sea, East Sussex, TN39 3SR
email: ptm@xact.demon.co.uk ... pmahoney@cix.compulink.co.uk
phone: +44 424 3 6368
From: davidj@informix.com (David Jennings CONTRACTOR)
Newsgroups: comp.databases.informix
Subject: Re: Error -4518: Cannot allocate any more space
Keywords: -4518
Date: 13 Oct 92 18:31:52 GMT
Distribution: comp
Organization: Informix Software, Inc.

In article <1992Oct8.161759.12356@nijmeg.ingr.com> clercqm@nijmeg.ingr.com (Marien de Clercq) writes:
>Can someone please help me with error -4518:
>
>	"The 4GL program cannot allocate any more space for temporary 
>	string storage."
>
[ stuff deleted ]
>
>Who can give me a clue about where to look for a solution ???
>
>
>
>-- 
>Marien de Clercq                            ___ "She was bored with the man,
>Intergraph European Mfg. bv.      /|/|    //     because no matter what happened
>Nijmegen - The Netherlands       /   | __//      he was always happy as a ...
>E-mail: clercqm@nijmeg.ingr.com /    |/_/ \___   clown"    -  Laurie Anderson


I ran into this same problem recently.  What was the apparent cause in my
case was that all the temporary string space was being eaten up by
a function called from within a loop which returns a string variable.  My
solution was to make the variable a global, which solved the problem.

Other possible causes for error -4518:
   
      1- use of GROUP BY
      2- literal strings
      3- CASE statement with no OTHERWISE clause
      4- use of USING 
      5- use of SPACE
      6- use of upshift and downshift


I hope this helps,

-- dave
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
David Jennings                                      Informix Software, Inc. 
Programmer/Analyst, MIS (Contractor)             uunet!pyramid!infmx!davidj
From: baskett@hermes1.sps.mot.com (Bob Baskett)
Newsgroups: comp.databases.informix
Subject: Re:  Auditing thoughts...
Date: 16 Oct 92 19:13:25 GMT
Reply-To: baskett@hermes1.sps.mot.com (Bob Baskett)
X-Informix-List-ID: <list.1524>

will,

i've run into the same situation.  what i did was created a table with
the same schema as the one i wanted to 'audit' but added columns to 
store the userid, date, time, and transaction type (add,delete,update).
prior to performing the disk operation i wrote the entire record out
to this table with the appropriate additional fields.  this solution
works, but does take some extra disk space.

------------------------------------------------------------------------------
Bob Baskett
Motorola, Inc.

Newsgroups: comp.databases.informix
From: hankard@nikki.osf.org (William Hankard)
Subject: ULTRIX 4.3 and Informix 5.0
Organization: Open Software Foundation
Date: Wed, 7 Oct 1992 15:33:00 GMT

Hello,

	Does anyone know if Informix 5.0 will run correctly
	on ULTRIX 4.3  Thanks in advance.

-- 
============================================================================
William D. Hankard 	        ___   ___   ___     Voice: (617) 621-7233
Open Software Foundation       /  /  /__   /__      Fax: (617) 621-0584
11 Cambridge Center           /__/  ___/  /         Internet: hankard@osf.org
Cambridge, MA 02142                                 UUCP: uunet!osf!hankard
Office Number: 214			            System Administrator	
============================================================================
Newsgroups: comp.databases.informix
From: yslas@riverauswest.com ( Rob Yslas)
Subject: What value is saved to a char variable if the field is null
Keywords: null,char
Organization: U S WEST Advanced Technologies
Date: Wed, 7 Oct 1992 23:00:31 GMT

If the valued being selected from the database is null, assuming a char array,
what value will be stored into the variable.  I know that an indicator variable
will tell me that the value is null, but I would like to know what the actual
array value will be.

i.e    will a string termination be in the first array position.

and assuming the informix string type is used.

Thanks in advance.

-- 
yslas@advtech.uswest.com
Thanks
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Query By Example in 4GL
Date: 16 Oct 92 02:18:05 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1519>

Quoting Andy Watson...
} 
} When one uses the CONSTRUCT command in 4GL it blanks the listed screen 
} fields before allowing user input. Does anyone know of a means of 
} avoiding this, or alternative ways of achieving the functionality below.
} 
Yes...

} Informix 4GL V1.1 by the way, but V4.0 manuals don't look any different
} 
Yup, you're right.  Take a look at the 4.10 Supplement though.  4.10 will
allow you to do what you want with some creative BEFORE FIELD code.

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: bochner@das.harvard.edu (Harry Bochner)
Subject: Re: Perform Data Ordering.
Organization: Aiken Computation Lab, Harvard University
Date: Fri, 9 Oct 1992 20:28:21 GMT

In article <1992Oct8.224918.20188@sequent.com>, kevinc@sequent.com (Kevin 
Closson) writes:
|> In article <9638@emory.mathcs.emory.edu> maint72@saad-emh1.ARMY.MIL (Michael 
Gordon) writes:
|> >          1.   Open the TABLE and check for INDEXED fieldnames, the
|> >               fieldnames for last_name and first_name must be indexed.
|>    This technique should only work on static tables.  Should a row of
|>  "Johnson" be deleted and then a row of "Smith" be inserted, the ordering
|>  will be broken.

No, that would be a problem if you were relying on the physical order of the
records in the table, but that's not what was suggested: if you were relying
on the physical order, it wouldn't matter if there was an index.

I don't know the internals, so I don't know how reliable the suggestion is, but
the idea is this:
Experience indicates that perform _tends_ to use an index if one is available,
rather than just reading the table directly (probably this allows it to skip
deleted rows efficiently?). If there's more than one index, I don't know how
it decides which one to use. But if there's only one index, it tends to scan
rows via that index, and since the B-tree (?) index is ordered by the key field,
perform returns them in that order. So Michael Gordon's suggestion tends to
work, although it's not guarranteed as far as I know.

-- 
Harry Bochner
bochner@das.harvard.edu
Newsgroups: comp.databases.informix
From: yslas@riverauswest.com ( Rob Yslas)
Subject: sqlca.sqlcode error -522
Organization: U S WEST Advanced Technologies
Date: Wed, 7 Oct 1992 20:29:05 GMT

Does anyone know what this error code description is it's not in my ESQL/C 
Informix manual.

Thanks in advance for help,
Rob Yslas

-- 
yslas@advtech.uswest.com
Thanks
From: tchow@ra.cs.umb.edu (Tony Yee Chow)
Newsgroups: comp.databases.informix
Subject: Re: Evaluating Informix 4.1 vs. 5.?
Date: 8 Oct 92 12:02:35 GMT
Organization: University of Massachusetts at Boston, Dept of Math and CS

I have sent a message before but it got corrupted.  So I am posting it again.

I am looking for some info on Informix 4.1 vs 5.? ( latest release ),
programming bugs, stability, and any helpful hints that I can evaluate before
I purchase Informix product.
Thanks in advance.
Tony Chow.
From: "clay irving" <clay.irving@execnet.com>
Newsgroups: comp.databases.informix
Subject: back-end growth
Date: 11 Oct 92 16:19:58 EST
Reply-To: "clay irving" <clay.irving@execnet.com>
Distribution: comp
Organization: Executive Networks Information

On 10-11-92 Ihor J Kinal writes:

|Recently, I posted an article about the backend [sqlturbos]
|growing in Online 4.10 UE1 and UE3P1.
|
|Further investigation showed one specific case to be where
|we had a cursor that had been prepared once [the specific
|query was a join between two tables].  After about 50 open/closes,
|we discovered steady growth in our backends.
|
|This problem was reproduced even on the stores db, so I'm surprised
|that more people haven't come across this problem.
|
|After sending a test program to Informix support, we have received
|a fix to bug # 14071 in release 4.10 UE4P1.
|
|Thanks to Informix for fixing the problem so quickly.
|Further details upon request.

Maybe this explains what's been happening to my system. I'm running 4.10 
UE1 on an IBM RS/6000. I have a batch 4GL program that I tried to run 
against 37,000 rows. I have 16MB of memory with 32MB page space. Everytime 
I run the program it ABENDs -- Not enough memory. I watched sqlturbo go 
from 1MB to 2MB to 3MB... to 8MB.. Eventually it eats all the virtual 
memory and the RS/6000's Virtual Memory Manager starts killing processes.


---
  WinQwk 2.0b#480  I believe the word you're looking for is AAAAARRRRRGGH!
--
Executive Network Information System  (914) 667-4567
International ILink Host
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Auditing thoughts...
Date: 16 Oct 92 04:33:13 GMT
Reply-To: dave.snyder@snide.com (Dave Snyder)
X-Informix-List-ID: <list.1521>

Quoting Will Hartung - Master Rallyeist...
} 
}      We've got a client running OnLine for their application. They
}      want to note every time someone changes a field in their
}      application (i.e. who changed what field on which record and what
}      did they change it from).
 [verbosity left out]...
}      So, I'm looking for alternative ways of tracking changes made to
}      a database. Preferably something that won't be really
}      overbearing. Any hints will be appreicated.
} 
In writing a medical system for my current client, I had the same dilema.
Medical records can NEVER be updated, only appended to.  In my system,
any time someone "changes" a record, instead of doing an UPDATE WHERE CURRENT
OF... I do an INSERT INTO.  The first time a patient is added, the record
that gets inserted get a sequence number of 1.  Each subsequent "change" is
just another insert with the next higher sequence number.  Of course I had
to make the SELECT statement intelligent enough to select the MAX(seq_nbr)
record for a patient instead of selecting all of the records for a patient.
When it comes to reporting this information, ALL the records for a patient
are printed.  Hope this sparks some ideas!

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.7
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: mtoms@ems.cdc.com (Mark Toms)
Newsgroups: comp.databases
Subject: Re: Clipper Windows Version
Date: 12 Oct 92 12:41:27 GMT
Reply-To: mtoms@ems.cdc.com
Distribution: na
Organization: Empros Systems International, a division of CDC

In article <1992Oct12.035020.56168@datamark.co.nz>, david@datamark.co.nz (David Rowland) writes:
|> I Read a review about a future product from nantucket which is the
|> windows version of clipper.  Does anyone know about it (i.e. release
|> dates etc)???
|> 
|> Thanks in advanced.
|> -- 
|> | David Rowland       | The British are using New Zealanders.  They must |
|> | Datamark Intl Ltd   | really mean business !                           |
|> | Wellington          |      -  General Rommel During Northern African   |
|> | NEW ZEALAND         |         Campaign WWII.                           |

Wasn't the Clipper product bought by Computer Associates?


==========================================================================
J. Mark Toms                                email: mtoms@ems.cdc.com
Baltimore Gas & Electric, Company
C/O Empros Systems International            Phone: (612) 553-4423
2300 Berkshire Lane North                     FAX: (612) 553-4018
Plymouth, Minnesota  55441-3694 USA      Mailstop: PLY060
==========================================================================
Newsgroups: comp.databases
From: david@datamark.co.nz (David Rowland)
Subject: Re: We need dBaseIV help!
Date: Sun, 11 Oct 1992 21:05:44 GMT
Organization: Datamark International Ltd.

In <1992Sep28.163538.1@ulkyvx.louisville.edu> cl130000@ulkyvx.louisville.edu writes:

>  We are having some trouble with dBase IV.  First, does this version support
>the mouse?  If so, how do you activate it.  The mouse is connected and the
>software is in memory.  Second, when working with the DATE data type, how do
>you enter null values into the year?  We need to enter something like '**'
>because some people don't want us to know how old they are.  Any help would be
>greatly appreciated.
>
>Thanx, in addvance.
>

I think there is a dBASE program you run which invokes dBASE with
mouse support.  Check the documentation or the programs which came
with the mouse.

As to your date, can you use DD/MM/00 for these dates as 00 is a valid
year?
-- 
| David Rowland       | The British are using New Zealanders.  They must |
| Datamark Intl Ltd   | really mean business !                           |
| Wellington          |      -  General Rommel During Northern African   |
| NEW ZEALAND         |         Campaign WWII.                           |
Newsgroups: comp.databases
From: osstlm@eua.ericsson.se (Tomas Lundstrom)
Subject: new ODBMS product
Reply-To: osstlm@eua.ericsson.se
Organization: Ellemtel Telecom Systems Labs, Stockholm, Sweden
Date: Fri, 16 Oct 1992 17:30:42 GMT



I have posted a description of the latest EasyDB ODBMS product to
comp.newprod and eunet.newprod.

For further information, please contact Renee Sjostedt, Jaan Haabma or Per-Arne 
Gussander at Objective Systems SF AB on:

	phone: +46 8 703 45 30, fax: +46 8 750 80 56,
	E-mail: base-open-request@os.se


Product Summary

	EasyDB releases 3.1 product highlights are summarized in:

*	Multi-user system with network distributed storage - can be scaled down 
	to single-user and single-host configurations.

*	Strong modeling system (both graphical and textual). Dynamic schema 
	evolution.

*	Well integrated language bindings (C, C++, Ada in Q2 -93).
	Static or dynamic name resolution. Multimedia support.

*	Safe and easy to use conflict handling throughout the system.

*	Support for Configuration Management.

*	Powerful distribution mechanism. Network topology independent.

*	Technology independent layers.

*	High performance. Short and long-lasting transactions.


/Tomas
Newsgroups: comp.databases
From: allenjm@eng.auburn.edu (John M. Allen)
Subject: Re: Foxpro's Dev. Kit & Exe's
Organization: Auburn University Engineering
Date: Wed, 14 Oct 1992 06:36:01 GMT

In article <Bw2r7B.A7G@acsu.buffalo.edu> v125qmam@ubvmsb.cc.buffalo.edu (Ami R Pflugrad) writes:
>	one complaint though, is there anyway to avoid getting the
>	startup "credits", ie. "Foxpro Lan2.0/EXE Support Library"
>	and ends with the serial numbers.  I know its just a matter
>	of cosmetics, but its annoying.  Any way to avoid this?
>
>	Much thanks
>		- Ami

	There is a startup switch which suppresses the startup screen. I am
not sure if it works with exe's.  try  -T  .  It is mentioned on page 67 of
the quick reference manual and probably elsewhere in the documentation.

			-John
Newsgroups: comp.databases