HDTenEightyP/NetNews huggingface dataset:
From: finin@cs.umbc.edu (Timothy Finin)
Newsgroups: comp.databases.informix,comp.databases.oracle,comp.databases.sybase,comp.databases.ingres
Subject: CIKM-93 CFP -- 2nd Int. Conf. on Information and Knowledge Mgmt.
Date: 24 Jan 1993 19:03:43 -0500
Organization: Computer Science, University of Maryland Baltimore County
Distribution: world
NNTP-Posting-Host: algol.cs.umbc.edu
Summary: April 1 paper deadline (no jokes, please)
Keywords: database, knowledge base, information retrieval, AI, DB, KB, IR

The CIKM-93, second International Conference on Information and Knowledge
Management will be held November 1-5, 1993 at the Double Tree Hotel in
Washington D.C., USA.  Like the successful CIKM-92, it will provide an
international forum for presentation and discussion of research on
information and knowledge management, as well as recent advances on data
and knowledge bases. Authors are invited to submit papers, proposals for
tutorials and exhibits concerned with theory or practice or both.  Papers
should be sent to the Program Chair, Dr. Bharat Bhargava, by April 1, 1993.

Send email to CIKM-INFO@CS.UMBC.EDU to receive an automatic reply with a
full copy of the Call for Papers.
From: coburn@informix.com (David Coburn)
Newsgroups: comp.databases.informix
Subject: Re: Informix triggers
Date: 26 Jan 93 14:38:33 GMT
Organization: Informix Software, Inc.

In article <1993Jan22.193703.20779@anasazi.com> briand@anasazi.com (Brian Douglass) writes:
>>In article <1993Jan20.165128.9762@dssmktg.uucp>, corinne@dssmktg.uucp
>>(Corinne Gregory) writes:
>>|> Hello, all...
>>|> 
>>|> 	We are in need of using Informix 4GL (with Online?) in a live-feed
>>|> sort of situation, where an "event" occurring which changes data in the 
>>|> 
>>|> [ remainder deleted ]
>>
>
>What you might look into as far as display is 20/20 Realtime.  A
>spreadsheet for unix that can be "programmed" to periodacally look at the
>data and update its cells based on changes in the data flow it is watching.
>

You can do the same thing with Wingz.  It has an event driven programming
language in it (although I know of no way for the engine to drive the
program).  It's graphical, though, so you would need to use an X-terminal,
or do this client/server to a Mac or DOS machine.

There is a real-time version of Wingz available, although I've done this
without that version of Wingz.

>Have only seen it in demos, but it looks cool.
>
>-- 
>"The best government of all is that government which governs the least."
>	Jefferson
>Brian Douglass		briand@anasazi.com 	602-870-3330 X657


David Coburn                                 coburn@informix.com
Informix Software, Inc.                    ...uunet!infmx!coburn
=========================================================================
Any opinions expressed here are not necessarily those of Informix 
(or for that matter, anybody else).
=========================================================================
From: alan@effluvia.den.mmc.com (Alan Popiel)
Newsgroups: comp.databases.informix
Subject: Re:  Catching output from RUN command (4GL)
Date: 25 Jan 1993 11:18:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: alan@effluvia.den.mmc.com (Alan Popiel)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1818>

->From: uaa1006@dircon.co.uk (Peter Miles)
->Subject: Catching output from RUN command (4GL)
->Date: Sun, 24 Jan 1993 13:34:36 GMT
->Reply-To: uaa1006@dircon.co.uk (Peter Miles)
->
->Does anyone know if there is any way of capturing the output 
->of a command run by the 4GL RUN command into an Informix 4GL
->variable?
->
->EG I want to say something like:
->
->LET string=RUN "tail -1 /tmp/somefile"
->
->The output I want to catch will always be only one line long.
->I'm running i4gl version 4 (standard engine).
->
->Comments and suggestions gratefully received!
->
->Please Email me, as my newsfeed seems to be a bit shakey at 
->the moment.
->
->Thank you!
->                        -- Pete
->-- 
->Pete Miles			uaa1006@dircon.co.uk
->				...uknet!dircon!uaa1006

Pete,

Your best bet seems to be writing a C subroutine that:
1. runs your command, 
2. picks up the result,
3. returns the result as its function value.

Here at Martin, we did something similar for 'sum' rather than 'tail', to 
test checksums on files being copied across our coast-to-coast net.  (This 
code is available on request.)

If you are using the interpreted (RDS) version of i4gl, then you will need 
to rebuild your runner to include the new subroutine.  If you are using the 
compiled version, just include the compiled subroutine in the list of .o 
files to be linked.  More info on this is in section 1 of volume 1 of the 
4GL reference manual.

Regards,
Alan
+------------------------------+---------------------------------------+
| R. Alan Popiel               | Internet: alan@den.mmc.com            |
| Martin Marietta, LSC         | ( Please note: My opinions do not   ) |
| P.O. Box 179, M/S 5422       | ( represent official Martin policy. ) |
| Denver, Colorado 80201-0179  | Voice: 303-977-9998                   |
+------------------------------+---------------------------------------+
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: backup differences between SE and OL - question.
Date: 21 Jan 93 17:46:47 GMT
Organization: Informix Software, Inc.

Will Hartung - Master Rallyeist writes:
>
>The 'tbunload' is the only real solution. But, you can get away with
>not swapping a billion tapes for every backup (assuming your tables
>aren't enormous that is). The trick here is to tbunload to the "no
>rewind" device of the tape, and just stick several back to back. I
>imagine that this will bring problems if your tables have a chance of
>spanning the tape. Discovering what happens then is an exercise for
>the reader. Our tables aren't 2 Gig in size, so I'm not worried.

DO NOT attempt to do this with regular archives, though.  We require
rewind in that case, because we read the header on the tape to insure
that the tape has been switched for multi-volume archives.

As far as I know, this is not an issue with tbunload.

>It would be nice to be able to recover a specific DATABASE from an
>OnLine Level 0 archive, though.

You will see this in the 6.0 release.

Dave

-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
From: promdist!bill@pds.com (Bill Foote)
Newsgroups: comp.databases.informix
Subject: Re: How To Distinguish Null Values in UNLOAD ??
Date: 28 Jan 1993 20:53:20 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: promdist!bill@pds.com (Bill Foote)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1834>

> 
>     Hi gurus,

Well, I think that I had my "guru" license suspended when I didn't know
about sqlca.sqlerrd[1], but I'll give it a shot!   :-)
> 
>     I need to dump data from an Informix 2.10 database into an ASCII file. 
> Fine. No problem. But, the program which uses the ASCII file needs to know 
> which values are NULL. The straight UNLOAD statement does not seem to 
> provide any way to distinguish a NULL value in a column from a value which
> has 4 spaces. 

Yes, it does.

> In either case, the output ASCII is a bunch of blanks.

No:  For a null value, the output is a _zero-length_ string, and for a
non-null value it isn't.  A text field that contains all blanks is output
as a string of length one containing a blank.

To illustrate, running this bit of sql:

	create table test(x serial, a char(10), b char(10) not null);
	insert into test (b) values ("hi");
	insert into test (b) values (" ");
	insert into test (b) values ("");
	unload to "/tmp/test" select * from test
    
    (i.e. x isn't null, a is, and b isn't)

produces the following in /tmp/test:

	1||hi|
	2|| |
	3|| |

Notice that the blank, non-null text fields are of length 1, and the
null text fields are of zero length.

The way Informix does it is better than putting a '.' in the ASCII file
for null values:  There is no way a non-null field can produce the same
output as a null field, regardless of contents.

I assume that Informix also outputs a zero-length string for a null value of
any other type.

-- 
Bill Foote						bill@pds.com
MIS Director						uunet!promdist!bill
PDS Corp, Los Angeles, CA  USA
Newsgroups: comp.databases.informix
From: riskit@x400gate.bnr.ca (Reg Foulkes)
Subject: Do you know the coltype converstion?
Followup-To: comp.databases.informix
Organization: Bell-Northern Research
Date: Sun, 24 Jan 1993 13:23:06 GMT

I need to build a lookup table for coltype in syscolumns. Does anyone have
a list of the conversions?
On my system if we do:

    Select coltype from syscolumns 
      where tabid = "some number" 

I will get a list of numbers 

0
1
2
.
.
.
256
etc

I know O is equivalent to Char and 256 is equivalent to Integer. Can anyone
help me fill in the blanks. 
thanks... 

riskit@bnr.ca
phone (613) 763-4131
Ottawa, Ontario Canada.
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re: Do you know the coltype converstion?
Date: 27 Jan 93 17:21:54 GMT
Organization: Informix Software, Inc.

In article <riskit-240193081954@47.201.0.36> riskit@x400gate.bnr.ca (Reg Foulkes) writes:
>I need to build a lookup table for coltype in syscolumns. Does anyone have
>a list of the conversions?
>On my system if we do:
>
>    Select coltype from syscolumns 
>      where tabid = "some number" 
>
>I will get a list of numbers ...

These are documented quite clearly in chapter 2 of the Informix
Guide to SQL: Reference.  Look up the description of Syscolumns.
The coltype value is not a simple integer mapping; there are
meanings to some of the bits as well.
From: anadeem@ampere.bit.listserv.tech-l (Ahmed Nadeem)
Newsgroups: comp.databases.informix
Subject: Edge Detection And Segmentation Using Khoros And PV-WAVE Software
Date: 27 Jan 93 07:49:00 GMT
Article-I.D.: ampere.ANADEEM.93Jan27004900
Distribution: comp.databases.informix
Organization: /home/ampere1/anadeem/.organization

Netters,
        I am currently working on a research project that involves generating
solid or geometric models from MRI images. Part of the procedure will require 
me to possibly perform Thresholding & Edge Detection on my MRI images in order
to find out which pixels lie on boundaries between two different regions. 
Thus, I would like to have an Image Processing Software package that has good 
Edge Detection and Classification ( Segmentation ) modules/routines.  
        I have heard a lot about Khoros ( University Of New Mexico) and 
PV-WAVE (Precision Visuals) and was curious if other professionals or students
had any experience on how good they are for the above purposes. Suggestions 
on other software packages are also much welcome.
                                                       Thanks,
                                                              Ahmed Nadeem
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Do you know the coltype converstion?
Date: 24 Jan 1993 21:13:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1815>

Quoting Reg Foulkes...
} 
} I need to build a lookup table for coltype in syscolumns. Does anyone have
} a list of the conversions?
} 
} I know O is equivalent to Char and 256 is equivalent to Integer. Can anyone
} help me fill in the blanks. 
} 
Here you go... and I believe 256 is really a CHAR that disallows NULL

SQLCHAR		0
SQLSMINT	1
SQLINT		2
SQLFLOAT	3
SQLSMFLOAT	4
SQLDECIMAL	5
SQLSERIAL	6
SQLDATE		7
SQLMONEY	8
SQLNULL		9
SQLDTIME	10
SQLBYTES	11
SQLTEXT		12
SQLVCHAR	13
SQLINTERVAL	14

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: alan@effluvia.den.mmc.com (Alan Popiel)
Newsgroups: comp.databases.informix
Subject: Re:  Help with Insert (ESQL/C)
Date: 26 Jan 1993 17:33:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: alan@effluvia.den.mmc.com (Alan Popiel)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1824>

ERROR ALERT:  Popiel goofs again !!!!  
Details at 11:00 ...

Bill Foote (promdist!bill@pds.com) writes:

->From: promdist!bill@pds.com (Bill Foote)
->Subject: Re:  Help with Insert (ESQL/C)
->To: informix-list@rmy.emory.edu
->Date: Tue, 26 Jan 93 13:00:01 PST
->In-Reply-To: <9301261539.AA08176@effluvia.den.mmc.com>; from "Alan Popiel" at Jan 26, 93 8:39 am
->Reply-To: promdist!bill@pds.com (Bill Foote)
->> 
->> ->	I have a scienario where I need to insert into one table
->> ->and one of the columns of the table is of serial datatype. After
->> ->inserting into this table, I need to know what the column value
->> ->is ( the serial type one) and insert this value into another 
->> ->table where it is a foreign key.
->
->> The value you want is in global variable 'sqlca.sqlerrd[2]'.
->> 
->> In my ESQL/C manual, it's on pages 2-18 ff.  For my 4GL colleagues, it's on 
->> pages 3-77 ff of I4GL Ref. Manual Volume 1.
->> 
->
->In my ESQL/C (version 4.00) manual, it's in sqlca.sqlerrd[1], _not_
->sqlca.sqlerrd[2].  sqlca.sqlerrd[2] is the number of rows processed.
->I hope that this was just a typo, because I don't want to think
->that something like this would change across versions.
->
->In reference to my previous post (where I claimed that this didn't
->exist in Informix ESQL/C 1.0), I guess that I didn't RTFM closely
->enough way back then.  Informix ESQL/C 1.0 _does_ return this value
->in sqlca.sqlerrd[1].
->
->-- 
->Bill Foote						bill@pds.com
->MIS Director						uunet!promdist!bill
->PDS Corp, Los Angeles, CA  USA
->

Alan Popiel (alan@den.mmc.com) shame-facedly replies:

The typo was mine, in translating from 4GL to C.  The correct, corresponding 
items are addressed as:

   SQLCA.SQLERRD[2]    in  4GL,  which subscripts starting at 1
   sqlca.sqlerrd[1]    in  C,    which subscripts starting at 0

My (weak) explanation:  I normally work in 4GL, *very* seldom in C.  This 
subscript stuff is a standard "gotcha" in moving to C from most other 
languages.

Thanks, Bill, for helping to keep me humble.  BTW, this is one reason I cite 
the ref. manuals, rather than trying to sound like a guru.  If you read the 
manuals,  you can recover from my errors, just as you did.  BTW #2, does your 
ESQL/C manual have the same typo error in the struct definition that mine does, 
regarding 'sqlwarn'?

Regards,
Alan
+------------------------------+---------------------------------------+
| R. Alan Popiel               | Internet: alan@den.mmc.com            |
| Martin Marietta, LSC         | ( Please note: My opinions do not   ) |
| P.O. Box 179, M/S 5422       | ( represent official Martin policy. ) |
| Denver, Colorado 80201-0179  | Voice: 303-977-9998                   |
+------------------------------+---------------------------------------+
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Msg: Cannot remove file for table().
Keywords: Corrupted DB,  dbspace
Date: 22 Jan 93 15:17:41 GMT
Organization: Informix Software, Inc.

Paul Kupersmith writes:
>Using Informix 4.1, when I try to drop a database, I get the following
>message:
>
>   214: Cannot remove file for table ().
>
>I have called Informix support, and they have stated that the dbspace
>has been corrupted. Their proposed work around to me is to reinitialize
>the dbspace. This is unacceptable to me due to the downtime it would
>cause to the production systems dependent upon that dbspace.
>
>BTW, If the database contained "production" data, Informix extended an
>offer to dial into the system and correct the problem.
>
>
>I have two questions:
>
>  1) What is causing the dbspace to be corrupted?

Impossible to say with the information you have provided.

>  2) What program does Informix use to correct the situation?

It is a custom program written by the folks in support to patch various
things on disk within an OnLine system.

>  3) Can I obtain a copy of this program (or something similar)?

Absolutely not.  Without detailed knowledge of the many data structures
existing in an OnLine system, you would not be able to do anything useful
with it (and could well make things much worse).  Only the advanced tech
support people use these patch utilities, and even they do so with a great
deal of caution.

Dave
-- 
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney
Newsgroups: comp.databases.informix
From: mlee@.adaclabs.com (Mike Lee )
Subject: Mirroring - Suggestions/Experiences
Originator: mlee@hourglass
Organization: Adac Laboratories, Milpitas Ca
Date: Thu, 28 Jan 1993 02:57:48 GMT


Hi everyone,

I've just inherited a project to do disk mirroring...Unfortunately I'm
getting bits and pieces on how the "mirror" is done now and don't have a
complete picture how things are working...

We are running Sun Sparcs using Online 4.00UH1.  Basically I need to know
the experiences anyone out has had doing disk mirroring and the best
strategies.

Currently the mirroring is done via NFS. Is this the correct way of doing
this?

Any and all help in educating me and steering me the right direction would
be appreciated...
         ________________________________________________________
________| Mike Lee           | I like pigs. Dogs look up to us.  |_______
\       | ADAC Laboratories  | Cats look down on us. Pigs treat  |      /
 \      | mlee@adaclabs.com  | us as equals. - Churchill         |     /
 /      |________________________________________________________|     \
/__________)                                                  (_________\
Newsgroups: comp.databases.informix
From: briand@anasazi.com (Brian Douglass)
Subject: Re: Informix triggers
Organization: Anasazi Inc Phx Az USA
Date: Fri, 22 Jan 1993 19:37:03 GMT

>In article <1993Jan20.165128.9762@dssmktg.uucp>, corinne@dssmktg.uucp
>(Corinne Gregory) writes:
>|> Hello, all...
>|> 
>|> 	We are in need of using Informix 4GL (with Online?) in a live-feed
>|> sort of situation, where an "event" occurring which changes data in the 
>|> database can be updated on the screen immediately.  We are anticipating
>|> a live-flow of data that needs to be imported into the database and then
>|> activities performed within the 4GL program depending on the situation.  I
>|> understand that triggers handle this situation nicely, but I have no
>|> experience with them in the Informix world.  Do they exist?  And, if yes,
>|> any suggestions, hints, etc., for how we would make use of them?
>|> 
>|> 	Thanks for any help...
>|> 
>|> - Corinne
>

What you might look into as far as display is 20/20 Realtime.  A
spreadsheet for unix that can be "programmed" to periodacally look at the
data and update its cells based on changes in the data flow it is watching.

Have only seen it in demos, but it looks cool.

-- 
"The best government of all is that government which governs the least."
	Jefferson
Brian Douglass		briand@anasazi.com 	602-870-3330 X657
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: ESQL/C + GX (yes)
Date: 22 Jan 1993 19:13:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: dave.snyder@snide.com (Dave Snyder)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1810>

Quoting David Cortesi...
} 
} I just asked two developers and both were positive that 4GL/GX supports
} construction of a custom runner just like 4GL RDS does.  So yes, you can
} continue to use your own ESQL/C functions with 4GL/GX...probably!
} 
} 1) If your C functions try to interact with the user, either using curses,
}    or stdout, or reverse-engineered Informix library calls
}    (who would do that?), they will likely break owing to the very 
}    different user-interface environment.
} 
Not Me :-)

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: promdist!bill@pds.com (Bill Foote)
Newsgroups: comp.databases.informix
Subject: Re:  Help with Insert (ESQL/C)
Date: 26 Jan 1993 16:48:11 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: promdist!bill@pds.com (Bill Foote)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1823>

> 
> ->	I have a scienario where I need to insert into one table
> ->and one of the columns of the table is of serial datatype. After
> ->inserting into this table, I need to know what the column value
> ->is ( the serial type one) and insert this value into another 
> ->table where it is a foreign key.

> The value you want is in global variable 'sqlca.sqlerrd[2]'.
> 
> In my ESQL/C manual, it's on pages 2-18 ff.  For my 4GL colleagues, it's on 
> pages 3-77 ff of I4GL Ref. Manual Volume 1.
> 

In my ESQL/C (version 4.00) manual, it's in sqlca.sqlerrd[1], _not_
sqlca.sqlerrd[2].  sqlca.sqlerrd[2] is the number of rows processed.
I hope that this was just a typo, because I don't want to think
that something like this would change across versions.

In reference to my previous post (where I claimed that this didn't
exist in Informix ESQL/C 1.0), I guess that I didn't RTFM closely
enough way back then.  Informix ESQL/C 1.0 _does_ return this value
in sqlca.sqlerrd[1].

-- 
Bill Foote						bill@pds.com
MIS Director						uunet!promdist!bill
PDS Corp, Los Angeles, CA  USA
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: CISAM/SVR4
Date: 28 Jan 93 03:00:40 GMT
Organization: Tools and Environments Technology Center, Informix Software, Inc.

In article <1993Jan27.231942.5046@cognos.com> nigelc@cognos.com (Nigel Campbell) writes:
>This is a CISAM specific question (vs ONLINE). What SVR4
>platforms is CISAM certified on and which of these share
>the same production tape vs a tape specific to that O/S.

Don't understand that last clause...

We run on a bunch of different SVR4 environments.  What kind of hardware are
you talking about?

>Does anyone know if CISAM for SCO UNIX 3.2.4 is certified
>to run on other boxes like UNISYS, UNIVEL, CONCENSYS.

No, no, and no.  There are Unisys-specific versions for Unisys; UNIXWare
will probably run the AT&T SVR4 ports (compatibility testing is under way);
and Consensys is not explictly supported (although there are no known problems
running the AT&T SVR4.0 port on it).

In any case, I wouldn't run the SCO port on anything but SCO.

>Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
>Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
>UUnet: nigelc@cognos.COM                                  CANADA  K1G 3Z4


--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland
 Disclaimer: These opinions are mine alone.  If I am caught or killed,
             the secretary will disavow any knowledge of my actions.

"The mist clung to the mountain the same way a thirteen-year-old girl clings
 to her boyfriend, although the mountain wasn't thinking about "getting lucky."
                                 (1990 Bulwer-Lytton Fiction Contest entry)