HDTenEightyP/NetNews huggingface dataset:
From: dpotlur@hubcap.clemson.edu (Potluri Dora)
Subject: Thanx for help with serial insert in ESQL/C
Keywords: Serial, insert, ESQL/C, Informix SE 5.0, C
Organization: Clemson University
Date: Wed, 27 Jan 1993 00:42:30 GMT


hi,
	Here is the solution to the problem that I posted.
Thanx to all who responded to my post. 
	Here is the solution and once again thanx to every one who 
responded. I appreciate your help.

Solution:
----------------------------------------------------------------------
Check out the SQLCA record structure. sqlca.sqlerrd[1].
This record contains the value you require immediately after the insert.
Regards
Steve
-----------------------------------------------------------------------------
Steve Weet - European Mis - Motorola Cellular Subscriber Group

An example of how to use it:
--------------------------------------------------------------
Here is a code example I've used in the past:
/* generate a serial value, then insert into another table */
#include <stdio.h>
$include sqlca;

main(argc, argv)
int argc;
char **argv;
{
 $static long db_num;
 $database bb1;

  /* bb1 is a table with a serial column and integer column */
  $insert into bb1 values (0,1); 

  if (sqlca.sqlcode) {
      fprintf(stderr, "%s: Error generating serial number == %d\n",
                  argv[0], sqlca.sqlcode);
      exit(2);
   } else
   /* sqlca.sqlerrd[1] contains the serial value from the insert stmt */
      db_num = sqlca.sqlerrd[1];

   printf("serial value: %d\n", db_num);

   /* bb2 is a table with a single integer column */
   $insert into bb2 values ($db_num);
        if (sqlca.sqlcode) {
                fprintf(stderr, "%s: Error inserting data == %d\n",
                        argv[0], sqlca.sqlcode);
                exit(2);
        }
}

Hope this helps...
-- 
 *-------------------------------------------------------------------*
  \   Ricky Johnson                           Intergraph Corp.        \
   \    ricky@epic.b30.ingr.com               Huntsville, AL           \
    \     (205)730-3634                       Informix Database Support \
     *-------------------------------------------------------------------*

-- 
Potluri Dora
Information Systems Lab  
Clemson University
Clemson, sc 29631
From: cortesi@informix.com (David Cortesi)
Newsgroups: comp.databases.informix
Subject: Re:  ESQL/C + GX (yes)
Date: 22 Jan 93 17:42:07 GMT
Organization: Informix Software, Inc.

[somebody claimed...]
>>According to the Informix people at last summer's Worldwide Users Conference
>>4GL/GX was not planned to support ESQL extensions.

[thompson@stars.gsfc.nasa.gov (William Thompson, code 682.1, x2040) reacts...]

>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?

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!

There are two new things to worry about.

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.

   *Documented* library functions still work as before of course (subject
   to any warnings or restrictions you may find in the 4GL/GX pamphlet).
   And C functions that deal with the database, files, and other
   non-interface issues have no new constraints with /GX.

2) When linking the custom runner, the Motif libraries are required.
   The procedure is documented in the 4GL/GX pamphlet.

Dave Cortesi
Newsgroups: comp.databases.informix
From: aa@rexago8.uucp (Adam Andrews)
Subject: Re: First Time Informix User
Organization: Summit Information Systems
Date: Fri, 22 Jan 1993 15:21:24 GMT

alan@effluvia.den.mmc.com (Alan Popiel) writes:
>Debashis Dutta (ddutta@tiguex.cs.unm.edu) writes:
>->I have just started using informix and still trying to get some ideas about
>->how strong a DBMS package it is. I am having some problems in printing Ace
>->reports......well all I want to do is to have various font size options 
>->built within the report. That is to say, someone who wants Courier 10 cpi bold
>->format to print out the header of the report, how will he do that or say I
>->want to use the compressed printing mode of the hp laserjet III printer.....
>->now I can change the font setting of the printer manually and then send the
>->job for printing....but can I built this within the report itself.
>
>I don't use Ace, so I don't know how to do what you ask in Ace.   HOWEVER,
>it is really pretty easy to do what you ask in the 4GL report writer, which 
>is similar to, but more powerful than, the stand-alone ACE report writer.  
>Maybe you can do the same thing in Ace.

>When using the 4GL report writer, you can output your control codes by using 
>a PRINT statement.  However, the 4GL compiler will not let you print certain 
>control codes as constants, since it recognizes that they are special, and it 
>calls them "unprintable" or "non-printing" characters (I forget the exact 
>wording of the error message).

>DEFINE	code_on	 CHAR(3),
>	code_off CHAR(3)

>LET code_on  = ASCII 27, "W", ASCII 1	{ example Epson print codes }
>LET code_off = ASCII 27, "W", ASCII 0
>PRINT code_on, rest_of_data, code_off

I have used Ace, and the exact same syntax above should work in an ace report.

-- 
Adam Andrews                "When the going gets weird, we get even weirder."
uunet!rexago8!aa or aa@rexago8.UUCP       e-mail only to aa@summitis.com
From: pop@persia.newshost.gte.com (Paul O. Perry)
Newsgroups: comp.databases.informix
Subject: xload for informix ?
Date: 25 Jan 93 20:07:36 GMT
Distribution: comp
Organization: GTE Labs


Did I see someone post an xload like monitor of an informix database here ?
If so, I think I just missed it.  Could you mail me a copy ?

Thanks, Paul.


--
____________________________________________________________________
Paul O. Perry					pop@gte.com
GTE Laboratories M/S 40 			phone: (617)466-2853
40 Sylvan Road					fax:   (617)890-9320
Waltham, MA 02254
From: jparker@hpbs2561.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Re: Screen flashing
Date: 28 Jan 1993 18:13:06 -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.1830>

Quoting Walt Hultgren.
> 
> Just saw your posting on screen flashing.  I noticed something like that
> when I was doing an app in 4.1.  We had gone from ".03" to 4.1, skipping 4.0.
> I thought my problem might be related to the fact that the functions in
                                                         ^^^^^^^^^^^^^^^^
> question used the RUN statement.  It didn't make that much difference in
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> that particular program, so I just let it go.
> 

Ok, now that Walt has pointed this out....   Is there a fix?

j.
_____________________________________________________________________________
Jack Parker - Contractor               | 
Hewlett Packard, BSMC Boise, Idaho, USA|       "Excuse me, do you
jparker@hpbs2651.boi.hp.com            |          have a jack?"
(208) 323-5388 (W)  (208) 384-1623 (H) |
_____________________________________________________________________________
Newsgroups: comp.databases.informix
From: eric@nit.pactel.com (Eric Pederson)
Subject: Re: ESQL/C -- sqlturbo and sqlexit()
Organization: Pac*Tel Corporation
Date: Wed, 27 Jan 1993 01:44:35 GMT

It seems that sqlexit() in ESQL/C version 4.x is doing a blocking
wait() instead of a waitpid() or a non-blocking wait3() or wait4().
If I want to sqlexit() before my other children have died, then the sqlexit()
hangs.  Also, while it is hanging, I do a "ps" and find that sqlturbo is
*still* running.  Isn't it supposed to wait() *after* the kill?  If (while it
is hanging) I kill my application with a SEGV signal, I get the following in 
an "adb" traceback:

_wait4(?)
__DYNAMIC(0xefffe22c,0x0,0x2a9400,0x2,0x10,0x0)	+ 4
_killbackend(0x5035,0x0,0x0,0x10,0x2b2a68,0xc) + 34
_sqlexit(0x1,0x1f,0xefffe318,0x2c38d0,0xef7ea760,0x1) +	4

Is this fixed in version 5.0 or is there a way around using sqlexit()
to stop the sqlturbo process when you are finished with ESQL?
-- 
Eric Pederson                                       Pac*Tel Corporation
eric@nit.pactel.com                                        510-210-8890
Newsgroups: comp.databases
From: isc30158@nusunix1.nus.sg (WEE LEE SENG)
Subject: Re: Paradox question
Organization: National University of Singapore
X-Newsreader: TIN [version 1.1 PL6]
Date: Sun, 24 Jan 1993 14:45:29 GMT

J. D. McDonald (mcdonald@aries.scs.uiuc.edu) wrote:
: 
: 1) I can't get the "modify" or "data-entry" things on a table to
: come up automatically with the proper form for that table ... I
: have to change it manually every time with Image. How does one do this?
: Some sort of simple macro? 

 If you are thinking of using macros, you can create a script to 
 load the proper form and assign a key to play that script. Thus,
 in a way, just like a macro.

: 2) I can Ask to my heart's content and it works fine, but getting a 
: report on the result is a pain .. I have to COPY a report type to
: the Answer table by hand every time I create a new Answer .. is there some 
: way to make this stick .. I tried copying Answer over an old table to
: which I had already attached a report, but that seems to lose the report 
: already attached.

 You can try to copy the pre-designed report to the answer table instead
 of copying the answer table to the old table. The only restriction of 
 doing this is that the structure of answer table must be the same as 
 that of the old table.


============================================================================
Wee Lee Seng              |________|________|________|________|________|____
weeleese@nusdiscs.bitnet  ____|________|________|________|________|________|
isc30158@nusunix2.nus.sg  |________|________|________|________|________|____
___|________|________|________|________|________|________|________|________|
|_______|________|________|________|________|________|________|________|____
   |        |        |        |        |        |        |        |        |
============================================Just another brick in the wall==
From: helin@vehka.uta.fi (Mikko Helin)
Newsgroups: comp.databases
Subject: Format of R:BASE files
Date: 25 Jan 93 14:28:20 GMT
Reply-To: helin@vehka.uta.fi (Mikko Helin)
Organization: University of Tampere, Finland


Does anyone out there know where I can get the format of the R:BASE
files, or even better, the converter program that converts from
the R:Base format to the DBASE format (or Paradox or plain text format)?
 

Thanks!

M. Helin
---


--
---
Mikko Helin
helin@vehka.cs.uta.fi
From: hauser@nlm.nih.gov (Susan Hauser)
Newsgroups: comp.databases
Subject: Re: C source or LIB for database access wanted
Keywords: CodeBase
Date: 22 Jan 93 15:28:44 GMT
Reply-To: hauser@nlm.nih.gov
Organization: National Library of Medicine

One possibility is CodeBase from Sequiter Software. They
support dBase III, IV, Foxpro and Clipper. You can get
the "portability" (i.e. source code) version for some
extra dollars. I have tried porting it to the Sun for
dBase III+, but with little success.

		Sequiter Software, Inc
		in Edmonton, AB, Canada
		403-437-2410 (voice)
		403-436-2999 (fax)
		403-437-2229 (BBS)
Newsgroups: comp.databases
From: eross@uwovax.uwo.ca
Subject: Re: Clarion users
Organization: University of Western Ont, London
Date: Tue, 26 Jan 1993 22:23:56 GMT

In article <1k400hINN5va@golem.wcc.govt.nz>, francis_g@kosmos.wcc.govt.nz (gazza) writes:
> I was wondering how many folk use Clarion ?.
> 
>  And if so ho
> And if so who konws any thing about the pending realise 
> of the Version 3 product ?.

> Gary

I've been using Clarion for 4 years now and Irecently got my Clarion 3.0
pre-release - essentially a beta with manuals.  I'm not planning on doing any
serious work in 3.0 until they get a stable program out, hopefully soon.  I'm
in the midst of designing a major app that I will most likely write in 2.1 and
port over to 3.0 some time this summer.

-- 
-------------------------------------------------------------------------------
Evan Ross
-------------------------------------------------------------------------------
Western Foot Patrol, University of Western Ontario, Lambton Hall,
1421 Western Rd., London, Ontario, N6G 4W4
(519) 661-3650	 Fax (519) 661-3687
From: gordon@chmeds.ac.nz
Newsgroups: comp.databases
Subject: Paradox: table and index with different sort orders
Date: 22 Jan 93 22:01:57 +1200

One of our users has many tables which he cannot access because of a common 
error: "table and index have different sort orders". This is probably because 
the files have been moved between different PCs with differently configured 
Paradox setups.

Is there an easy way to fix this problem?  The only suggestions I have so far 
involve reentering many sets of data manually. That has been described as 
character-building. 
 
Cheers
Gordon
---
Gordon Findlay,  Computer Scientist, Christchurch School of Medicine
                 Nuclear-free New Zealand         !System error: y
Generic:  Gordon@CHMEDS.AC.NZ                     !hit any user to 
JANET:    Gordon%NZ.AC.CHMEDS@UK.AC.NSFNET-RELAY  !continue.
Paper:    PO Box 4345, Christchurch,  NEW ZEALAND !
Newsgroups: comp.databases
Subject: Relational database info needed
From: richard@technology.com (Richard Murphy)
Date: Mon, 25 Jan 1993 15:58:00 GMT
Organization: Southwest Research Institute, San Antonio, Texas

I need a recommendation on a relational database product that
supports "data items" that may be arrays or complex structures.
This product should run a UNIX workstation and also support
databases of 1 to 5 Gbytes in size. While most of the data are
just scalar values or time series, some are images. Please
e-mail me directly at richard@technology.com if you have any
experience with such products. Many thanks.

Richard
Newsgroups: comp.databases
From: waynel@microsoft.com (Wayne Lampel)
Subject: Re: Foxpro: Reporting/Querying on most recent date in DBF
Date: 21 Jan 93 18:26:45 GMT
Organization: Microsoft Corp.
Distribution: usa

In article <C131HG.4C4@acsu.buffalo.edu> v125qmam@ubvmsb.cc.buffalo.edu wrote:
> Hi all!
> 	How can I get Foxpro to point to the record containing the most
> 	recent date within a group?  For example: 
> 
> 	The File looks like this:
> 
> 			Name    C 	20
> 			Date	D	 8
> 
> 	I want to query the most recent Date associated with a given name.
> 	The MAX Function requires a list of possibilites...
> 
> Thanks!
> - Ami					

Perhaps: CALCULATE MAX(date) FOR name = "whatever" TO maxdate

Newsgroups: comp.databases
From: dcm@world.std.com (David C McGaffin)
Subject: Two-dimensional array simulation in Paradox
Keywords: PARADOX ARRAYS
Organization: The World Public Access UNIX, Brookline, MA
Distribution: comp.databases
Date: Sun, 24 Jan 1993 20:53:26 GMT

    I recently was attempting to recreate a procedure called, Dim2()
    that I first saw when I was programming in Clipper Summer '87. 
    The code I ended up with, now for Paradox 4.0, was this:

        proc closed Dim2 (aArray, nCol, nRow)

        return ( (nCol - 1) * (arraySize(aArray) / 2))  + nRow

        endProc ; Dim2

    This works fine, but it seems that in the original incarnation of 
    Dim2(), there was no need to pass the array along with the row and
    column.  However, I can think of no way to get the size of the 
    array, without passing it to the procedure.  Is the code above a 
    reasonable duplication of Dim2(), or is there something else to 
    it?  I appreciate any response.

    - David M.
From: anadeem@ampere.bit.listserv.tech-l (Ahmed Nadeem)
Newsgroups: comp.databases
Subject: Edge Detection And Segmentation Using Khoros And PV-WAVE Software
Date: 27 Jan 93 07:45:57 GMT
Article-I.D.: ampere.ANADEEM.93Jan27004557
Distribution: comp.databases
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: cocks_d@kosmos.wcc.govt.nz
Newsgroups: comp.databases
Subject: Re: dBASE III+/Foxbase Question
Date: 27 Jan 1993 22:17:49 GMT
Organization: Wellington City Council (Public Access), Wgtn, Nz
Reply-To: cocks_d@kosmos.wcc.govt.nz
NNTP-Posting-Host: kosmos.wcc.govt.nz

Thanks for your comments on my "off the cuff" code. I don't get feedback on
my code that often.

Regards, Derryl.

________________________________________________________________________________
Mail: 	Derryl Cocks, Analyst/Programmer
	New Zealand Fire Service, PO Box 2133
	Wellington, New Zealand
Phone:	(4)4724969  Fax: (4)4781603  International: +64 4 47.... 
Email:	"cocks_d@kosmos.wcc.govt.nz"
________________________________________________________________________________

Newsgroups: comp.databases
From: Mischa_Sandberg@mindlink.bc.ca (Mischa Sandberg)
Subject: Re: Help with SQL statement
Organization: MIND LINK! - British Columbia, Canada
Date: Tue, 26 Jan 1993 04:33:30 GMT

> Philip Muench writes:
> In article <1993Jan22.211051.4867@vpnet.chi.il.us> mike@vpnet.chi.il.us
> writes:
> >I have 2 tables lets say I have a Customer table and an order table.
> >I want to query the database for all customers and show their orders
> >for the past month.  I may have more than 1 order for a customer.
> >
> >The problem is that if I don't have an order for a customer, the join will
> >not find a match and that customer will be left out of the report.
> >I still want to show the customer even if no orders are present.
> >Is this possible with SQL ??  was my explanation clear enough ??
>
> Put a false order that you can easily recognize as false in the order
> table for every customer, or at least for every customer that has no
> real order.
> Joins, as you have found, are useless for finding records in one table
> that do not have a corresponding record in the other table.
> -Philip Muench

??? This is a straightforward outer join:
SELECT CUST.CUSTNO, ORDER.TOTAL
FROM CUST, ORDER
WHERE CUST.CUSTNO *= ORDER.CUSTNO

ORDER.TOTAL will be <null> where there is no order for that customer.


--
Mischa Sandberg ... Mischa_Sandberg@mindlink.bc.ca
                 or uunet!van-bc!rsoft!mindlink!Mischa_Sandberg
*-*-*-*-*-*-*-*-*-*-*
Engineers think equations are an approximation of reality.
Physicists think reality is an approximation of the equations.
Mathematicians never make the connection.
From: geoff@hawkesbury.uws.EDU.AU (Geoff Russell)
Newsgroups: comp.databases
Subject: Re: dBASE executables
Date: 27 Jan 93 21:15:12 GMT
Organization: University of Western Sydney, Hawkesbury


>>(Todd Wallace) writes:>> Does anyone here know how to turn dBASE 
>>applications into standalone executables for DOS?
>> Thanks.
>> ----------------------------------------------------------------
>> |    Todd Wallace               |  "A pessimist is surprised   |
>> |    twallace@gmuvax2.gmu.edu   |   as often as an optimist,   |
>> |                               |   but always pleasantly."    |
>> |                               |            - Robert Heinlein |
>> ----------------------------------------------------------------

Computer Associates (Nantucket) have a dBase4 compiler for about A$110.00

Geoff Russell
University of Western Sydney, Hawkesbury
Richmond, NSW, AUSTRALIA
From: cocks_d@kosmos.wcc.govt.nz
Newsgroups: comp.databases
Subject: Re: dBASE III+/Foxbase Question
Date: 23 Jan 1993 20:52:32 GMT
Organization: Wellington City Council (Public Access), Wgtn, Nz
Reply-To: cocks_d@kosmos.wcc.govt.nz
NNTP-Posting-Host: kosmos.wcc.govt.nz

In article <1993Jan22.103546.2528@ucbeh.san.uc.edu>, torbecvs@ucbeh.san.uc.edu writes:
>To whomever can possibly help me,
>	I am using dBASE III+ and Foxbase.  Simple question (I hope!)
>
>	How do you send output to a file?  To be a little more specific, I
>would like to give the user the option to output send to the screen, to a
>printer, or to a user specified filename.  I figure that it has something to do
>with: 
>	SET PRINTER TO (<device>
>		or
>	redirecting using a DOS command
>
>Am I close?!  Thanks ahead for any help,
>	VST

DO something like the following:

STORE "" TO METHOD
@10,10 say "Output method (S)creen, (P)rinter or (F)ile"
DO WHILE .T. && Endless loop which will be broken by the EXIT command
 @10,2 get METHOD
 READ
 IF METHOD $ "SPFspf" && Does the letter S,P or F appear in variable METHOD?
  EXIT
 END IF
ENDDO
DO CASE
 CASE METHOD $ "Ss"
  && Don't do a thing cause will default to screen
 CASE METHOD $ "Pp"
  SET CONSOLE OFF && Turn off screen
  SET PRINTER ON
 CASE METHOD $ "Ff"
  STORE "" to FILENAME
  @12,10 say "Name of file" GET FileName
  READ
  SET CONSOLE OFF
  SET ALTERNATIVE TO FileName
END CASE

... now put code to output to screen, printer or file

... and tidy up housekeeping
SET PRINTER OFF
SET CONSOLE ON
CLOSE ALTERNATIVE
SET ALTERNATIVE TO

Good luck with the above code

Regards, Derryl.

________________________________________________________________________________
Mail: 	Derryl Cocks, Analyst/Programmer
	New Zealand Fire Service, PO Box 2133
	Wellington, New Zealand
Phone:	(4)4724969  Fax: (4)4781603  International: +64 4 47.... 
Email:	"cocks_d@kosmos.wcc.govt.nz"
________________________________________________________________________________


________________________________________________________________________________
Mail: 	Derryl Cocks, Analyst/Programmer
	New Zealand Fire Service, PO Box 2133
	Wellington, New Zealand
Phone:	(4)4724969  Fax: (4)4781603  International: +64 4 47.... 
Email:	"cocks_d@kosmos.wcc.govt.nz"
From: dmead@sparkle.tnis (Dana Mead CT/90)
Newsgroups: comp.databases
Subject: Clipper Code to ????
Date: 28 Jan 93 18:49:25 GMT
Reply-To: dmead@sparkle.tnis
Organization: Sun Microsystems

Is there any compiler or product on the Pc that will take my clipper code?  A windows product would be preferred.

Thanks
dmead@cmsa.gmr.com
From: steve.silverwood@filebank.cts.com (Steve Silverwood) 
Newsgroups: comp.databases
Subject: BAD FAX NUMBER
Date: 22 Jan 93 09:46:00 GMT
Distribution: world
Organization: The File Bank BBS - Fallbrook, CA  619-728-4318
Reply-To: steve.silverwood@filebank.cts.com (Steve Silverwood) 

Michael:

Received your FAX message, but was unable to reply with requested
information.  Both the FAX numbers (in header and on cover sheet) failed
to answer after repeated attempts.  I have an 11 page fax waiting for
you, tell me what your FAX number is.

//Steve//
[Computer Associates]

PS: Reply to steve.silverwood@filebank.cts.com or
76703.3035@compuserve.com == the latter is fastest for me, as I get
messages there five or six times a day, whereas I check filebank only
three or four times a week.
     
----
*--------------------------------------------------------------------------*
| The File Bank BBS - 619-728-4318 - PCBoard v.14.5a/E10 - USR HST & DS    |
| 8 nodes / RIME / Internet / Largest Clipper file collection in the world |
*--------------------------------------------------------------------------*
Newsgroups: comp.databases