HDTenEightyP/NetNews huggingface dataset:
From: bob@worms-emh2.army.mil (Bob Kane)
Newsgroups: comp.databases.informix
Subject: Re:  Help with dbload
Date: 22 Jan 1993 09:28:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: bob@worms-emh2.army.mil (Bob Kane)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1809>

}
}I use Informix version 4.00 on a 3b2 and cannot get
}dbload to work properly.  The comand file looks like this:
}
}   FILE "Newreport.out" DELIMITER "|" 21 ;
}   INSERT INTO acd (pdate,ptime,vdn,acd,exten,tpeg,tusg,avg_svc_time,
}                 taban,textaban,qpeg,qusg,avg_que_time,max_calls,max_que_time,
}                 pct_time_exc,vpeg,vusg,vaban,success,status)
}       VALUES (f01,f02,f03,f04,f05,f06,f07,f08,f09,f10,f11,f12,f13,f14,f15,f16,
}             f17,f18,f19,f20,f21);
}
}
}Resulting in this error:
}
}   DBLOAD Load Utility           INFORMIX-SQL Version 4.00.UG1
}   Copyright (C) Informix Software, Inc., 1984-1989
}   Software Serial Number AAA#C293637
}
}   FILE "results/Newreport.out" DELIMITER "|" 21 ;
}   Syntax error occurs on statement above.
}   Line 1          Character 30
}
}Character 30 would be the D of DELIMITER.  Help is greatly appreciated.
}
}
}
}Leif Van Horn
}Telecommunications Services
}University of Colorado at Boulder


On our 3B2 with 4.0, dbload will not work with the quotation marks around the
path name, even though the manual specifically states to use them.  Give it
a try.

-----------------------------------------------------------------------------
Bob Kane                   Internet: bob@worms-emh2.army.mil (IP 134.235.9.2)
TechDyn Systems               Voice: (049) 6241-487306   (WORMS, GERMANY)
CMR 421, BOX 706                Fax: (049) 6241-49560
APO AE 09056                    CIS: 71054,2661
Newsgroups: comp.databases.informix
From: pak2@base.bellcore.com (Paul Kupersmith)
Subject: Wanted: Performance Tuning Tips
Keywords: performance, tuning
Organization: Bellcore
Date: Wed, 27 Jan 93 13:37:25 GMT

I am in the process of collecting tips relevant to tuning the
Informix Online system parameters and performance tips for
application programs using ESQL/C.

Any documentation, pointers to existing information, or personal 
hints/tips that you would like to share would be appreciated.

Thank you,
Paul
From: bob@worms-emh2.army.mil (Bob Kane)
Newsgroups: comp.databases.informix
Subject: <No Subject Supplied>
Date: 22 Jan 1993 05:38:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: bob@worms-emh2.army.mil (Bob Kane)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1808>

Copy of: Registered Message.
To:       "Thomas S. Martin" <tom@worms-emh2.army.mil>
Subject:  Re:  [Just another eccentric comput: Re: MNP-5 Board Compatabilities with MMDF - II]
Resent-Date:  Fri, 22 Jan 93 10:01:51 GMT
Resent-From:  bob@worms-emh2.army.mil
Resent-To:  informix-list@rmy.emory.edu

Bruce,

If ISEC will provide us with the correct MMDF-II source, I will do the 
compilation and testing over a weekend, after AT&T reinstalls our MNP card.
We will only do so of course if we get the source.  I feel this is time
well spent as the MNP has other advantages, such as Berkely complient librarys
and header files.  I took straight BSD 4.3 code for 'whois' and compiled it
for the MNP.  Worked like a charm.  Here is the include stuff:



/*
 *      whois or nicname - DARPA Internet user name directory service
 *                         as defined in RFC 742.
 *
 *      Written by:  DDN Network Information Center.
 *      This code may be freely copied for any use.
 *
 *      Tested on Sun3s running 3.5, VAXes and Pyramids running Berkeley
 *      BSD4.3, and Microvaxes running Ultrix v2.0.
 *
 *      To compile on BSD4.[23], SunOS3.x, and Ultrix:
 *
 *              cc -o whois whois.c
 *
 *      Usage: whois [ -h host ] name
 *
 *      'host' may be either by name or address.
 */
#include <CMC/types.h>
#include <CMC/socket.h>
#include <CMC/in.h>
#include <stdio.h>
#include <CMC/netdb.h>
#include <CMC/bsd.h>

The code was compiled with the new librarys, libcmcnet.a and libsnmp.a.

-----------------------------------------------------------------------------
Bob Kane                   Internet: bob@worms-emh2.army.mil (IP 134.235.9.2)
TechDyn Systems               Voice: (049) 6241-487306   (WORMS, GERMANY)
CMR 421, BOX 706                Fax: (049) 6241-49560
APO AE 09056                    CIS: 71054,2661
Newsgroups: comp.databases.informix
From: uaa1006@dircon.co.uk (Peter Miles)
Subject: Catching output from RUN command (4GL)
Date: Sun, 24 Jan 1993 13:34:36 GMT


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
From: lei@mtcdev.MEDIATECH.COM (Charles Lei)
Newsgroups: comp.databases.informix
Subject: Re: Help with Insert (ESQL/C)
Date: 27 Jan 93 19:33:03 GMT
Reply-To: lei@mtcdev.MEDIATECH.COM (Charles Lei)
Organization: Mailing List Gateway
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1825>

Bill,

Sorry about the last post, it should have said sqlca.sqlerrd[1].

Charles
From: lad@remus.rutgers.edu (Kamlesh)
Newsgroups: comp.databases.informix
Subject: Informix-Online 4.10
Keywords: temp table locking problem
Date: 27 Jan 93 20:32:43 GMT
Organization: Rutgers Univ., New Brunswick, N.J.


Hello,

	I have informix-Online version 4.10, running on HP-UX ver.
8.02.

I have the problem of the temp table locking.  A user will not be able
to enter the databse sometimes, and this locks most of the users.

However, if I take the database engine off-line, and bring the engine
back up the problem is cleared.

I have heard this is a problem with the Mixing of informix 4.10 and 
hp-ux 8.02.

Any new versions of informix-online solve this problem?

-lad@remus.rutgers.edu
From: cheng@cis.uab.edu (Wai-Fong Cheng)
Subject: Re: Msg: Cannot remove file for table().
Keywords: Corrupted DB,  dbspace
Organization: University of Alabama at Birmingham
Date: Thu, 21 Jan 1993 19:24:55 GMT

In article <1993Jan21.153628.22858@walter.bellcore.com> pak2@base.bellcore.com (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?
>  2) What program does Informix use to correct the situation?
>  3) Can I obtain a copy of this program (or something similar)?
>
>Thank you,
>
>Paul


Paul,
we had a similar problem creep up on us using Informix 4.1 on a Motorola
88Open machine. We had lost a table and Informix told me that this was 
caused by a "nasty and known bug" (Sorry, can't remember the BUG #). The
only solution to our problem was to remove the table from systables and
then try to recreate the table.  Informix sent us another port of the 
Online engine to fix the problem. The corruption was caused (so they say) by 
a series of update statements within the code.  This code had been running 
just fine for over one year.

Now that we have this new port, the problem has gone away and we were able
to recreate the table (thank god it only had 13 rows...).

Hope this helps,

Matt...
				   
(Do not reply to the above E-Mail address, it belongs to a friend of mine)

				   
				   
				   
				   
Newsgroups: comp.databases.informix
From: jgordon@ssf-sys.DHL.COM (Jim Gordon)
Subject: Re: Informix triggers
Reply-To: jgordon@ssf-sys.DHL.COM (Jim Gordon)
Organization: DHL
Date: Fri, 22 Jan 1993 00:41:50 GMT

In article <1993Jan21.175641.22759@informix.com>, davek@informix.com
(David Kosenko) writes:
|> Jim Gordon writes:
|> >
|> >Firstly,  Triggers are only available in Online V5.01.  
|> 
|> More correctly, 5.01 servers.  They are available for both OnLine and SE
|> servers (aka engines).
|> 
|> Dave

True.  I stand corrected.  :-)

Cheers - Jim
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Sending me email
Date: 21 Jan 93 18:06:58 GMT
Organization: Informix Software, Inc.
Originator: davek@puma

On the subject of sending me email - please don't.  I have received,
in the last few weeks, quite a number of email messages requesting
help on specific problems.  While I spend some spare time offering
suggestions/solutions in this forum, I really do not have the
time to do so through email as well.  If you have a problem, you
should be calling Tech Support (which I do NOT work for, btw).  If
that is a problem for some reason, you should post your problem
here.  There are several at us in Informix who read and respond
here, and coupled with a very knowledgeable user base reading this
group, you are pretty likely to get an answer.  Sending me email
directly will generally only result in a response if the answer is
short, and I know it off the top of my head.  I am simply too busy
with "real" work (the stuff my manager gives me to do) for anything
more.

Thanks for your consideration on this.

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: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Informix triggers
Date: 21 Jan 93 17:56:41 GMT
Organization: Informix Software, Inc.

Jim Gordon writes:
>
>Firstly,  Triggers are only available in Online V5.01.  

More correctly, 5.01 servers.  They are available for both OnLine and SE
servers (aka engines).

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: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: ESQL/C -- sqlturbo and sqlexit()
Date: 27 Jan 93 15:34:10 GMT
Organization: Informix Software, Inc.

Eric Pederson writes:
>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?

Well, let's take a look at what sqlexit() actually does.  This is based
on 5.0 behavior, though I don't think it changed from 4.x.

As you can see from the stack trace, sqlexit() calls  killbackend(); in fact,
it does little else.  killbackend() does all the work.  What it does is to
close the input and output pipe that is used to communicate with the server.
It then does a wait() until the pid returned is that of the spawned server.
This wait is done inside a while loop, which will not terminate until that
child process has died.  Note that there is no kill involved.

On the server end, closing the pipes from the client end should generate either
an eof from the read side (when the server reads from the pipe to see what to
do next - this is a blocked read), or a SIGPIPE when it tries to write to a
pipe whose other end is closed.  The first case should be straightforward;
the second can be problemmatic.

The SIGPIPE generated by the write to the pipe can only occur when a write
is initiated by the server.  If you should attempt to perform an sqlexit()
while the server is off doing some work (by catching a SIGINT in your app,
and calling sqlexit() as part of your signal handler) you could wind up in
some trouble, because the server is merrily off doing its work, and will
not notice the closed pipes until it attempts to send something back.  If
it is involved in a complex operation (or the OnLine system is hung for
one reason or another), the write will not be happening right away, and your
app will be sitting on that wait until the server finishes what it is doing.

The best way around this is to always start any signal handling with an 
sqlbreak().  That will interrupt the server asap, at which point it can see
the sqlexit() stuff and clean up properly.  



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: proberts@informix.com (Paul Roberts)
Newsgroups: comp.databases.informix
Subject: Re: Catching output from RUN command (4GL)
Date: 24 Jan 93 22:26:17 GMT
Organization: Informix Software, Inc.

In article <C1D1pp.AA0@dircon.co.uk> uaa1006@dircon.co.uk (Peter Miles) writes:
>
>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!

You can always do something (kind of klugey!) like this :

run "tail -1 /tmp/somefile > /tmp/t1"
run "paste -d'|' /tmp/t1 /dev/null > /tmp/t2"

### (i.e. stick a "|" onto the end of your one-line file)

create temp table temp1 ( a char(80) )

load from "/tmp/t2" insert into temp1

select a
  into string_var
  from temp1

drop table temp1
run "rm /tmp/t1 /tmp/t2"

I have done this kind of thing, and it does work. 

Paul
Newsgroups: comp.databases.informix
From: pak2@base.bellcore.com (Paul Kupersmith)
Subject: Msg: Cannot remove file for table().
Keywords: Corrupted DB,  dbspace
Organization: Bellcore
Date: Thu, 21 Jan 93 15:36:28 GMT

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?
  2) What program does Informix use to correct the situation?
  3) Can I obtain a copy of this program (or something similar)?

Thank you,

Paul
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Catching output from RUN command (4GL)
Date: 24 Jan 1993 22: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.1816>

Quoting Paul Roberts...
} 
} In article <C1D1pp.AA0@dircon.co.uk> uaa1006@dircon.co.uk (Peter Miles) writes:
} >
} >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?
} >
} 
} You can always do something (kind of klugey!) like this :
} 
  [ Interesting kludge deleted... ]

If you want to stay with pure 4GL, Paul's idea is perfect.  If you aren't
afraid of C, you could do something like this:

Mind you, this pseudo code (but you'll get the idea)

runit(arg)
{
    FILE    *pp;
    char    buf[513], txt[257];

    popquote(buf, sizeof(buf));		/* Pop the run string off the stack */
    pp = popen(buf, "r");		/* Open a pipe for read w/ run string */
    fgets(txt, sizeof(txt), pp);	/* Read a line from the pipe */
    pclose(pp);				/* Close the pipe */
    retquote(txt);			/* Push the txt string onto the stack */
    return(1);				/* Tell 4GL that you returned 1 arg */
}

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re:  Upgrading Informix to 4.1 (SQL and 4GL)
Date: 21 Jan 93 17:52:03 GMT
Organization: Informix Software, Inc.

Alan Popiel writes:
>
>To release locks that are "hanging around" for a table in an SE database, 
>the OWNER of the database / table should do the following:
>
>1. cd to the directory holding the database, i.e. to directory <dbname>.dbs in 
>one of the directories within $DBPATH.  Because of permissions, you may have 
>trouble getting into the directory.  Have root open the permissions if 
>necessary.
>2. then:
>cp /dev/null <tblfilname>.lok


Note that this will only work if you happen to have one of the few
releases that use .lok files (Sun versions, primarily).

Better is the method anothe rposter suggested, setting the
RESETLOCK environment variable.  As of 5.0, we no longer use .lok
files for any platforms.

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: anadeem@ampere.bit.listserv.tech-l (Ahmed Nadeem)
Newsgroups: comp.databases.informix
Subject: MRI And CT-SCAN Images Of Dogs?
Date: 27 Jan 93 07:47:25 GMT
Article-I.D.: ampere.ANADEEM.93Jan27004725
Distribution: comp.databases.informix
Organization: /home/ampere1/anadeem/.organization

Netters,
      I am currently working on a research project that involves construction 
of realistic, solid or geometric models for dogs.
      Does anyone know where I can get serial section images( MRI, CT-SCAN, 
etc ) for dogs?
                                                       Thanks,
                                                              Ahmed Nadeem
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Question about Informix Correction (fwd)
Date: 28 Jan 1993 20:28:12 -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.1833>

Well this one has me stumped... does anyone out there have an answer to this
question?

Quoting Greg Washington...
} 
} How do you correct the problem of full logical logs with a process in critical
}     section waiting for a checkpoint.
} 

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: ddutta@tiguex.cs.unm.edu (Debashis Dutta)
Subject: First Time Informix User
Organization: Computer Science Department, University of New Mexico
Distribution: usa
Date: Thu, 21 Jan 1993 14:52:31 GMT

Hello World :

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 builtwithin 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.

What I have tried so far is to write the report in a file, then pass the
file thru a shell script that sends the <ESC> sequence to the printer to 
change the font size.....but I want everything built within the program
so that a less knowledgeable user can just printit everytime without any
problems.

I would really appreciate if some one can guide me to incorporate this within
the program itself. My email is ddutta@unmvax.cs.unm.edu

Dev Dutta
University of New Mexico, CS Dept.
Newsgroups: comp.databases.informix
From: shemminga@cix.compulink.co.uk (Stuart Hemming)
Subject: Re: Thanks (Re: Do you know th
Reply-To: shemminga@cix.compulink.co.uk
Date: Wed, 27 Jan 1993 17:02:00 +0000


TITLE: Thanks (Re: Do you know the coltype converstion?)

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

Lucky you 8-)


| I work with some bloody strange people, and so do they!    |
|------------------------------------------------------------|     
| Stuart Hemming       | shemminga@cix.compulink.co.uk       |
| Tudor Labels Ltd     | uunet!cix.compulink.co.uk!shemminga |
| Roman Bank Bourne    | Tel :  (+44) 778 426444             |
| Lincs PE10 9LQ. UK.  | Fax :  (+44) 778 421862             |
Newsgroups: comp.databases.informix
From: tony@cwi.com (Tony Chang )
Subject: Re: Help with Insert (ESQL/C)
Organization: CaseWare, Inc., Irvine, CA
Date: Tue, 26 Jan 1993 23:52:54 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. 
>	<...>
>> 	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.
>
We use sqlca.sqlerrd[1] here in our environment. We have
Informix OnLine 4.10 and ESQL/C 4.10 running on the
Sun SPARCs.

>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.
>
This approach might work fine in a local environment but will
not work for us since our applications run on multiple machines
of various platforms, and do not necessarily see the "small
(4 byte) file". It is much more efficient to let the OnLine
server handle the mess.

>-- 
>Bill Foote						bill@pds.com
>MIS Director						uunet!promdist!bill
>PDS Corp, Los Angeles, CA  USA
>
>

Tony Chang                    email: tony@cwi.com
Database Engineer             phone: (714) 453-2200 ext. 241
CaseWare, Inc., Irvine, CA
-- 

Tony Chang                    email: tony@cwi.com
Database Engineer             phone: (714) 453-2200 ext. 241
CaseWare, Inc., Irvine, CA
Newsgroups: comp.databases.informix
From: brad@hawk.adied.oz.au (Bradley Edelman)
Subject: Informix-OnLine/Secure
Organization: Australian Defence Industries
Date: Thu, 28 Jan 1993 00:39:33 GMT

Is Informix-OnLine/Secure available on Unix?  SunOS?  Sun CMW?

Brad. [brad@hawk.adied.oz.au]
Australian Defence Industries Ltd,
Enterprise Unit 3, Technology Park,
Bentley, WA 6102, Australia.
Tel: (09) 333 8888.  Fax: (09) 333 8889.