HDTenEightyP/NetNews huggingface dataset:
From: graeme@pyra.co.uk (Graeme Sargent)
Newsgroups: comp.databases.informix
Subject: Re: ESQL/C -- sqlturbo and sqldetach()
Date: 21 Jan 93 09:06:31 GMT
Reply-To: graeme@pyramid.com (Graeme Sargent)
Organization: Pyramid Technology Ltd.

In <FORNEY.93Jan19085549@vega.bsdsun> forney@vega.bsdsun (Elizabeth Forney  -- NEC America Network Management Group) writes:

>I need the capability to access two databases at once from a single 
>application.  With Version 5.00 of ESQL/C I noticed that there is a
>sqldetach function now available.  The manual is not quite clear, and I
>am wondering if sqldetach allows me to process requests from two databases
>at once, without closing one database before accessing the other?  The 
>manual did not contain a code example.  Could anyone on the net clarify the
>use of sqldetach -- possibly with a code snippet illustrating its use?

I get the impression you're barking up the wrong tree here.  As I
understand it sqldetach() allows a child process to detach from it's
parent's sqlturbo.

I don't understand why your requirement is not handled by code such as:

	DATABASE db1;
	INSERT INTO db2:tab2 SELECT * FROM tab1 WHERE ...

since you imply you are using OnLine 5.0 (as SE can't do it) and I would
call this one app accessing two databases???

graeme
--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
--------------------------------------------------------------------------------
      -m------- Graeme Sargent                 Voice: +44 (0)252 373035
    ---mmm----- Senior Database Consultant     Fax  : +44 (0)252 373135
  -----mmmmm--- Pyramid Technology Ltd.        Telex: Tell who???
-------mmmmmmm- Farnborough, Hants  GU14 7PL   Email: graeme@pyra.co.uk
--------------------------------------------------------------------------------
    We have the technology.  The tricky bit is learning how to use it.
-- 
graeme
--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
Newsgroups: comp.databases.informix
From: dpotlur@hubcap.clemson.edu (Potluri Dora)
Subject: Help with Insert (ESQL/C)
Keywords: ESQL/C, Informix, SE 5.00, SQL, Performance
Organization: Clemson University
Date: Tue, 26 Jan 1993 05:23:10 GMT


Howdy!
	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.
	I got the stuff working by inserting the row and then quering
using the select statement. USing this value I insert into the next 
table. 
	Due to voluminous data we have, and to improve the performance
I was thinking of eliminating the second query. Is there any other way
that I could accomplish the same thing?( ie with out quering using the
select statement?) .
	I would appreicate if you can either mail me or post it on the
news group.

Thanx
Potluri Dora
-- 
Potluri Dora
Information Systems Lab  
Clemson University
Clemson, sc 29631
From: rich@astro.umd.edu (Rich Puchalsky)
Newsgroups: comp.databases.informix
Subject: Informix full text searching
Date: 27 Jan 93 02:35:30 GMT
Organization: U. of Maryland @ College Park, Astronomy

I use Informix 4gl/SQL/Online 4.1 a good deal for numeric applications.
Unfortunately, I've had some problems with large text fields.  What
I would like to implement in many cases is a "full text" search; the
ability for the user to search for records by matching individual
words or word groups in a large text field.  Of course, anyone can search 
a large text field by searching where field matches "*word*", but
this is very slow and Informix does not use any indexes on the field
when you search using a leading wildcard.  I've thought of implementing
this kind of search by creating a detail table with each record consisting
of a single word or word group from the main table.  This detail table
could then be indexed and searched fairly quickly.  The problems with
this scheme, aside from the extra disk space needed to hold the detail
table, involve finding a good method of breaking down normal text into
words and word groups while avoiding "noise words" like "the", "and",
and "a" that no one would want to search on.  Has anyone out there
implemented such a scheme using Informix?
From: alan@effluvia.den.mmc.com (Alan Popiel)
Newsgroups: comp.databases.informix
Subject: Re:  Help with Insert (ESQL/C)
Date: 26 Jan 1993 11:13: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.1821>

->From: dpotlur@hubcap.clemson.edu (Potluri Dora)
->Subject: Help with Insert (ESQL/C)
->Date: Tue, 26 Jan 1993 05:23:10 GMT
->Reply-To: dpotlur@hubcap.clemson.edu (Potluri Dora)
->Organization: Clemson University
->
->Howdy!
->	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.
->	I got the stuff working by inserting the row and then quering
->using the select statement. USing this value I insert into the next 
->table. 
->	Due to voluminous data we have, and to improve the performance
->I was thinking of eliminating the second query. Is there any other way
->that I could accomplish the same thing?( ie with out quering using the
->select statement?) .
->	I would appreicate if you can either mail me or post it on the
->news group.
->
->Thanx
->Potluri Dora
->Information Systems Lab  
->Clemson University
->Clemson, sc 29631

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.

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: alan@effluvia.den.mmc.com (Alan Popiel)
Newsgroups: comp.databases.informix
Subject: Re: Do you know the coltype converstion?
Date: 25 Jan 1993 12:08:04 -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.1820>

Correction to my prior posting on this subject:

As Dave Snyder <dave.snyder@snide.com> points out, coltype=14 is INTERVAL, 
not coltype=9, as I had indicated in my included table.  Sorry for the error, 
and any confusion it caused.

Alan
+------------------------------+---------------------------------------+
| R. Alan Popiel               | Internet: alan@den.mmc.com            |
| Martin Marietta, LSC         | ( Please note: My mistakes do not   ) |
| P.O. Box 179, M/S 5422       | ( represent official Martin policy. ) |
| Denver, Colorado 80201-0179  | Voice: 303-977-9998                   |
+------------------------------+---------------------------------------+

Xref: sparky comp.databases.informix:3058 biz.jobs.offered:638
From: mcginnis@kuhub.cc.ukans.edu
Newsgroups: comp.databases.informix,biz.jobs.offered
Subject: Looking for Informix Expert (job available)
Date: 27 Jan 93 13:28:56 CST
Organization: University of Kansas Academic Computing Services

I have a friend looking for somebody with experience
with Networking (I have no details here)
with Informix and UNIX
some PC skills
and Project Leadership experience.

If you're interested, send me your phone number and address
and I'll have Ron get in touch with you.

Michael McGinnis                Internet: mcginnis@kuhub.cc.ukans.edu
Computer Center                   Bitnet: mcginnis@ukanvax
University of Kansas               Voice: (913)864-0413
Lawrence, KS  66045                  FAX: (913)864-0485

Rust never sleeps.
From: alan@effluvia.den.mmc.com (Alan Popiel)
Newsgroups: comp.databases.informix
Subject: Re:  Do you know the coltype converstion?
Date: 25 Jan 1993 11:38:12 -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.1819>

->From: riskit@x400gate.bnr.ca (Reg Foulkes)
->Subject: Do you know the coltype converstion?
->Date: Sun, 24 Jan 1993 13:23:06 GMT
->Reply-To: riskit@x400gate.bnr.ca (Reg Foulkes)
->Organization: Bell-Northern Research
->
->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.

Reg,

Your requested table is attached.  You made one error in your e-mail: 256 is 
NOT 'integer', it is 'char(n) not null'.  In general, if coltype = x is type 
'y', then coltype = x+256 is type 'y not null'.

coltype         data type
 
      0         CHAR(n)         collength gives bytes (=n)
      1         SMALLINT
      2         INTEGER
      3         FLOAT 
      4         SMALLFLOAT
      5         DECIMAL(n,m)    collength gives digits, encoded
      6         SERIAL
      7         DATE 
      8         MONEY(n,m)      collength gives digits, encoded
      9         INTERVAL        collength gives units
     10         DATETIME        collength gives units
 
    256         CHAR(n)         NOT NULL
    257         SMALLINT        NOT NULL
    258         INTEGER         NOT NULL
    259         FLOAT           NOT NULL
    260         SMALLFLOAT      NOT NULL
    261         DECIMAL(n,m)    NOT NULL collength gives digits
    262         SERIAL          NOT NULL
    263         DATE            NOT NULL
    264         MONEY(n,m)      NOT NULL collength gives digits
    265         INTERVAL        NOT NULL collength gives units
    266         DATETIME        NOT NULL collength gives units

Translating the collength for DECIMAL, MONEY, INTERVAL, and DATETIME is 
possible, but a pain.  If you need the info, let me know.

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: rtparies@turq.b8.ingr.com (Randy Paries)
Newsgroups: comp.databases.informix
Subject: DateTime in .ec
Date: 27 Jan 1993 15:38:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: rtparies@turq.b8.ingr.com (Randy Paries)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1827>

 Help.
 
 	I am looking for help in manipulating a datetime variable in
 	an .ec program.
 
 	My problem is that I have to add 2 hours to a 
 	"$datetime year to minute" variable. 
 
 	There are some little examples in the esqlc man in appendix H.
 	but they are all 4gl code. 
 
 	Any help would be appreciated...
 

-- 
------------------------------------------------------------------------     
Randy Paries 	       rtparies@turq.b8.ingr.com
x6191  cr041           Intergraph, Huntsville Alabama
------------------------------------------------------------------------
From: john@elsouth.uucp (John White)
Subject: Anyone having trouble with terminfo besides me?
Summary: Pain, anguish, buckets o' angst
Organization: Electrical South Inc
Date: Mon, 25 Jan 1993 14:57:59 GMT

I'm on a Starserver E running SYSV R4.0 V3.0 and Informix 4GL 4.0.UE2.
I'm having trouble with the graphics feature. 

   1) My upper and lower right hand corners are reversed.
   2) My smacs entry reads like this:
      smacs=\E$,
      The problem is that the $ is confusing the 4GL app. A X millisecond
      pause is represented by $<X>. The app. seems to be seeing the $ as
      the beginning of a pause rather than just a $. The result is that 
      whatever comes next in the terminfo file gets piggy-backed onto the 
      smacs string. The next entry is smso, so whenever I go into graphics
      I'm also in reverse and I don't go out until a reversed string is 
      finished being displayed. This is a problem. 
      
Has anyone else run into any other pot-holes in the term drivers for 4GL 
that I ought to know about?
-- 
-john (john%elsouth@concert.net)
Newsgroups: comp.databases.informix
From: nigelc@cognos.com (Nigel Campbell)
Subject: CISAM/SVR4
Organization: Cognos Incorporated, Ottawa CANADA
Date: Wed, 27 Jan 1993 23:19:42 GMT

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.
Does anyone know if CISAM for SCO UNIX 3.2.4 is certified
to run on other boxes like UNISYS, UNIVEL, CONCENSYS.

-- 
Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
Database and Connectivity MCI: nigel campbell || 307-4729 Ottawa, Ontario
UUnet: nigelc@cognos.COM                                  CANADA  K1G 3Z4
Newsgroups: comp.databases.informix
From: riskit@x400gate.bnr.ca (Reg Foulkes)
Subject: Thanks (Re: Do you know the coltype converstion?)
Followup-To: comp.databases.informix
Organization: Bell-Northern Research
Date: Mon, 25 Jan 1993 20:42:46 GMT

Thanks to everyone who sent me info on coltype. I do appreciate it. 
I now have everything under control. 

   Cheers, 
        Reg


riskit@bnr.ca
phone (613) 763-4131
Ottawa, Ontario Canada.
Newsgroups: comp.databases.informix
From: thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040)
Subject: Re:  ESQL/C + GX
News-Software: VAX/VMS VNEWS 1.4-b1  
Organization: NASA/GSFC-Laboratory for Astronomy and Solar Physics
Date: Thu, 21 Jan 1993 14:23:00 GMT

In article <1jjvokINN7nt@hpsdde.sdd.hp.com>, kurt@hpsdde.sdd.hp.com (Kurt Andersen) writes...
>In article <1jel7rINNqtq@emory.mathcs.emory.edu> alan@effluvia.den.mmc.com (Alan Popiel) writes:
>>alex@aureus.sublink.org (Sandro Doro) writes:
>>
>>Rebuilding the 4GL runner is (sort of) standard practice for the character 
>>mode 4GL, but it is not trivial.  Also, I do not know whether it is supported 
>>for 4GL/GX.
> 
>According to the Informix people at last summer's Worldwide Users Conference
>4GL/GX was not planned to support ESQL extensions.
> 
>Maybe feedback at the conference changed their mind, but I wouldn't count
>on it.

Let me be very clear on this.  I got the impression from the Informix
literature that 4GL/GX simply gave a windows interface to 4GL.  This led me to
believe that everything you could do in 4GL you'd be able to do in 4GL/GX.  Are
you telling me that this is *NOT* true?

Bill Thompson
From: lei@mtcdev.MEDIATECH.COM (Charles Lei)
Newsgroups: comp.databases.informix
Subject: Looking for Mark Jeske
Date: 21 Jan 1993 12:18:11 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: lei@mtcdev.MEDIATECH.COM (Charles Lei)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1806>

Sorry to post this here but I am trying to reach Mark Jeske, formerly
with Informix Counsulting here in Chicago.

If you have a number where he could be reached, or if you could have 
him call me at the number below my signature I would really appreciate 
it.

Thanks if advance for any replies.


Charles Lei
Mediatech, Inc.

Voice: (312) 828-9223 x.202
E-Mail: lei@mediatech.com
UUCP: ..{uunet,4gen}!mtcdev!lei
From: prem@prem.lbl.gov (shirdi prem)
Newsgroups: comp.databases.informix
Subject: How To Distinguish Null Values in UNLOAD ??
Date: 28 Jan 1993 19:32:02 GMT
Organization: Human Genome Center at LBL
Distribution: world
Reply-To: prem@prem.lbl.gov (shirdi prem)
NNTP-Posting-Host: prem.lbl.gov

    Hi gurus,

        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. In either case, the output ASCII is a bunch of blanks. Is 
    there a way around this ??

        Ideally, I would like to put a '.' (dot) in the ASCII file for those 
    entries which have a NULL value. And leave spaces for those entries that
    really are spaces.

    I appreciate your help very much,

    Prem!
    prem@prem.lbl.gov
From: lei@mtcdev.MEDIATECH.COM (Charles Lei)
Newsgroups: comp.databases.informix
Subject: Re: Help with Insert (ESQL/C)
Date: 27 Jan 1993 15:03:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: lei@mtcdev.MEDIATECH.COM (Charles Lei)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1826>

Bill,

Take a look at sqlca.sqlerrd[2].  That'll tell you what the serial
value is...


Charles
From: promdist!bill@pds.com (Bill Foote)
Newsgroups: comp.databases.informix
Subject: Re: Help with Insert (ESQL/C)
Date: 26 Jan 1993 13:23:08 -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.1822>


> 
> 
> Howdy!
> 	I have a scienario where I need to insert into one table
> and one of the columns of the table is of serial datatype. 
	<...>
> 	I would appreicate if you can either mail me or post it on the
> news group.

Please post, as I'd be interested in any good answers, too.  I've often 
resorted to things like creating my own "serial" values, and storing them 
in an integer field with a unique index.

Mind you, this isn't a terrible thing to do:  If I really cared about
efficiency, I'd have a small (4 byte) file holding the next sequence
number, and access it using open()/read()/write() with the appropriate
flock() (or lockf(), depending on your religion) call around the
critical region.

Of course, it would be _nice_ if the insert statement could just tell
me what serial value it just created.  I know that this wasn't possible
when I looked into it last, but that was Informix ESQL/C version 1.0
(on a 286-based machine, sometime in the late 50's I believe).  Perhaps
they've added something.

-- 
Bill Foote						bill@pds.com
MIS Director						uunet!promdist!bill
PDS Corp, Los Angeles, CA  USA
From: jparker@hpbs2561.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Informix 4.1 Screen 'flash'
Date: 28 Jan 1993 16:28:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jparker@hpbs2561.boi.hp.com (Jack Parker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1829>


A number of us here have discovered - after the switch from 4gl 4.0 to 4.1 -
that every time our programs leave a function the screen clears.  Is this
a 'feature'?  Is there a cure?  Are we doing something stupid? - I mean more
stupid than usual.

It's rather obnoxious when you have a function whose sole purpose is to 
display data which is provided by other functions - because each time you
leave the display-function you see a 'flash' of the data you were trying
to display followed by a blank screen.

Comments would be much appreciated.
j.
_____________________________________________________________________________
Jack Parker - Contractor               | 
Hewlett Packard, BSMC Boise, Idaho, USA|     For a good time call:
jparker@hpbs2651.boi.hp.com            |           555-1212
(208) 323-5388 (W)  (208) 384-1623 (H) |
_____________________________________________________________________________
From: jparker@hpbs2561.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: screen flashing (fwd)
Date: 28 Jan 1993 19:33:14 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jparker@hpbs2561.boi.hp.com (Jack Parker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1832>

Quoting a whole lot of people(s):

> Jack,
> 
> Just saw your second posting on screen flashing hit the mailing list (I've
> GOT* to get out of here!).  Anyway I hadn't posted anything to the list on
> it because I vaguely (sp?) recalled seeing something on the list a while back
> on the subject, and I was too lazy to look it up so I wouldn't appear too
> dumb.  When I saw you quoting me, I figured I better do some checking.
> 
> Anyway, I grepped around in the archive and found the following messages from
> December of 1991 (some of the headers are in an old style):
> | 
> | From: dave@das13.snide.com (Dave Snyder)
> | 
> | > Does anyone know if there is a way to run a unix command without the 
> | > screen blinking/Flashing in Informix 4gl ?
> | > 
> | What we did was to call a C function that executes a "system" on the passed
                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> | in string.

Much stuff deleted...

Thank you Walt ! - and Dave and others.

enclosed is same c routine:

______________________________________________________________________________
/*
run_cmn - run an OS command.  To replace the 4GL RUN command which clears
the screen.  syntax is CALL run_cmn(command, length(command)+1) returning int
*/

run_cmd(arg)
{
char    cmd[80];
int     siz, retcode;

   popint(&siz);                        
   popquote(cmd,siz);
   retcode=system(cmd);

   retint(retcode);

   return(1);
}
_____________________________________________________________________________


Works like a champ. 

On the same subject.  If you display directly to the screen with a 
'DISPLAY string', it will clear the screen to display your string.

If you 'DISPLAY string AT y,x' it will work fine.

(Caused me heartache as I tested the return code by 'DISPLAY retcode' just
after my OS call - thought we had the wrong solution)


Again, much obliged.
j.
_____________________________________________________________________________
Jack Parker - Contractor               |    "I wanna walk like you
Hewlett Packard, BSMC Boise, Idaho, USA|         talk like you
jparker@hpbs2651.boi.hp.com            |           toooooooo."
(208) 323-5388 (W)  (208) 384-1623 (H) |                   - King Louie
_____________________________________________________________________________
Newsgroups: comp.databases.informix