HDTenEightyP/NetNews huggingface dataset:
From: A.Heskett@bnr.co.uk (Tony Heskett)
Newsgroups: comp.databases.informix
Subject: Re: SQL query question
Date: 14 Apr 92 20:23:21 GMT
Article-I.D.: emory.8730
Reply-To: A.Heskett@bnr.co.uk (Tony Heskett)
X-Informix-List-ID: <list.1062>


Dave Snyder writes (quoting Ruchi Patel) :

> -> Is there anyway you could update the lower case data into uppercase by using
> -> the simple SQL UPDATE statement?
> No.
> 
> -> Is there anyway you could delete a character from the column using the
> -> UPDATE statement? e.g. I would like to drop a "-" character from the
> -> phone_no column.
> No.

Ok, so how about cheating ?      :-)

For the first one:

---8<-------8<-------8<-------8<-------8<-------8<-------8<-------8<----
echo 'unload to "fred.unl" select * from fred;' | isql mydb 

echo '%s/^[^|]*/\L&/|wq' | ex fred.unl

echo 'load from "fred.unl" insert into fred;' | isql mydb 
---8<-------8<-------8<-------8<-------8<-------8<-------8<-------8<----

Backslash L drops matched chars (&) to lower-case, %s does it on all lines.

This is only downshifting the first field (easiest), so arrange the
fields in the SELECT to suit this.

A pipe separates ex commands.

You can use a similar dirty hack to get rid of the hyphens; or try

%s/-/ /g

if you haven't got any apart from in the 'phones ...

Otherwise, it's easy (but *still* harder) in 4GL and using an UPDATE.

Cheers - Tony.

PS.   So when's Informix going to come out with one of these *advanced*
      hierarchical databases I keep hearing about, then ?    %-)
__________________________________________________________________________
Tony Heskett                 th@bnr.co.uk   Voice: (+44) 279 429531 x 2637
BNR, London Road, Harlow, Essex, CM17 9NA   Fax:   (+44) 279 454187
From: judym@col.hp.com (Judy Miller)
Date: Sat, 11 Apr 1992 18:17:51 GMT
Subject: Re: Table lookup function in isql?
Organization: HP Colorado Springs Division
Newsgroups: comp.databases.informix

>>Problem:  I have a list of keys to 4000 records which I need to delete from
>>          a table of 12000.
>>
>>I'm trying to avoid writing a program for this common function.
>>(I do not have 4GL on this machine, but I do have ESQL/C.)
>
>Try this one:
>1. load the key list into a (temporary) table
>   (create table, load from .. etc.)
>2. Then delete records by executing:
>   delete from orig_table
>   where key_field in ( select * from temp_table )
>
>3. Then drop key list, if not created by create temp table ..

Thanks for this and all email responses.  
This is the obvious solution ... welcome to the relational database world.

Judy
From: mak@spuddy.uucp (mak)
Newsgroups: comp.databases.informix
Subject: Re: how to get the value of a typed-in field
Date: 10 Apr 92 10:30:48 GMT
Organization: Spuddy's Public Usenet Domain

In article <1992Apr7.162351.9860@cssnl.syssup.tds.philips.nl> harry@.syssup.tds.philips.nl (Harry Weseman) writes:
>Hi!
>
>In informix-4gl, (I have 1.10.03), I would like to inspect what the user
>has typed in. I am using an INPUT statement, that gives me the value of
>a field with the AFTER FIELD clause. However, with the ON KEY clause, and
>then an IF INFIELD(field1) statement, I know that the user has typed something
>into the field I want, but I cannot get it from the input buffer. Or is
>there a way?
>

In compiled Informix .03 I know of a means of accessing the input buffer
it uses a bit of a 'phreak' in the <$INFORMIXDIR/incl/sqlfm.h> as follows
insert the following line

#define _getbuf(x) 1;pushquote(_sqicb._EFbuf,256)

then in your .4gl you can find what is in the buffer within an 'ON KEY'
by using a 'function' call of the following form

call _getbuf() returning charbuf   # where charbuf is char(256)

unfortunately I am not aware of any way of finding the input buffer when using
the RDS ... Help ??

mak (Remember - wherever you go - there you are)
From: echen@sword.eng.pyramid.com (Eric Chen)
Newsgroups: comp.databases.informix
Subject: Re:  Chunk Writes
Date: 17 Apr 92 03:31:29 GMT
Organization: Pyramid Technology

Maria Childress wrote:
>     Does anyone know what a chunk write is?  Does a chunk write relate to
> a chunk of disk on the OnLine system?  Or does it relate to the buffer
> queues?  

   "Chunk Write" refer to the flushing dirty buffers in shared memory
back to disk during the checkpoint. The "tbstat -F" will show you the 
statistics.  The "chunk" refers to a piece of contiguous physical disk
space, this term is used by Informix to represent physical disk space. The
"tbcheck -ce -p" command output will give you the idea. 

>     I think what is happening is that all modified pages in the buffers that
> need to be written to disk are sorted by their disk chunk number.  Then each
> page cleaner can write all the modified pages for a given disk chunk in a
> single I/O operation.

  Not exactly. 
  During checkpoint, the dirty buffers are indeed sorted by their chunk
number and location on chunks. But the page cleaner can't write all the 
dirty pages "in a single I/O operation". Reason: all the dirty pages belong
to a chunk may not be contiguously located right next to each other on the
disk chunk. Example:If you have page 1,2,3,5,8,9,10 dirty and page 4,6,7
clean; the page cleaner will do 2 big buffer writes and 1 normal buffer 
write to complete this chunk which means total of 3 "chunk write"s.  

>     Hope this all makes sense, if not maybe we can discuss it.
>
>     Thanks in advance for all input.


Eric 

==========================================================================
Eric Chen	Pyramid Technology		email: echen@pyramid.com
==========================================================================
From: walt@mathcs.emory.edu (Walt Hultgren {rmy})
Newsgroups: comp.databases.informix
Subject: Re: delimiters
Date: 17 Apr 92 15:52:24 GMT
Organization: Emory University

In article <1992Apr17.055432.25624@informix.com>,
aland@informix.com (Colonel Panic) writes:

>Why can't you use the UNLOAD command?
>
>  UNLOAD TO PIPE <pgmname> select field1, field2, field3 from test;

I would also use the UNLOAD command if possible, but my ISQL (4.10.UC1)
won't unload TO PIPE -- would that it could!  Will it in a later release?

Maybe you could unload to a temp file, then go from there.  Don't forget
that UNLOAD strips trailing blanks from char fields, if that's important.

Walt.

-- 
Walt Hultgren              Internet: walt@rmy.emory.edu       (IP 128.140.8.1)
Emory University               UUCP: {...,gatech,rutgers,uunet}!emory!rmy!walt
954 Gatewood Road, NE        BITNET: walt@EMORY
Atlanta, GA  30329  USA       Voice: +1 404 727 0648
From: proberts@informix.com (Paul Roberts)
Newsgroups: comp.databases.informix
Subject: Re: SQL query question
Date: 14 Apr 92 18:07:20 GMT
Organization: Informix Software, Inc.

In article <1992Apr14.153529.27934@nas.nasa.gov> jcarter@sun419.nas.nasa.gov (John R. Carter Sr.) writes:
>In an article regarding SQL query question Ruchi Patel writes:
>> Is there anyway you could update the lower case data into uppercase...
>> Is there anyway you could delete a character from the column...
>
>Although I like the sophisticated method submitted by Paul Roberts,
>I prefer to perform an ASCII dump of the offending records and let UNIX do
>the conversion, then reload the records. You may find this to be a bit faster
>and far less of a problem. UNIX can 'sed', 'tr', 'awk' or even 'perl'
>your most gruesome task with ease. It also has the advantage of taking 
>such mundane tasks out of the database leaving it to do what it does best.
>The disadvantage is that you need to lock the tables from updates while
>the data is 'outside' being modified, or do this at a time when you know
>no one is using the database. If you must have more real time access then
>Paul's solution is best.
>
>

Yes, this is probably a much better way to do it. Of course, you have to be
careful that you only remove hyphens from the "phone number" field if you
do this, and not from the other fields as well. I am not all the fluent at
'sed'/'awk', but I expect you can specify something like this.

Paul

(Hey, mom, some at NASA said my method was `sophisticated'!  :-)
From: dave@das13.snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: SQL query question
Date: 14 Apr 92 01:24:59 GMT
Organization: Snide Inc. - Folcroft, PA

In article <8718@emory.mathcs.emory.edu>, RUCHI%CFRVM.bitnet@VTVM2.CC.VT.EDU (Ruchi Patel) writes:

-> Is there anyway you could update the lower case data into uppercase by using
-> the simple SQL UPDATE statement?
No.

-> Is there anyway you could delete a character from the column using the
-> UPDATE statement? e.g. I would like to drop a "-" character from the
-> phone_no column.
No.

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.4
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: dave@das13.snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: HELP use tbmonitor non-interactive way!
Date: 10 Apr 92 01:51:33 GMT
Distribution: na
Organization: Snide Inc. - Folcroft, PA

In article <1992Apr9.175006.25922@uwm.edu>, felicia@miller.cs.uwm.edu (Felicia Chu Peng Cheong) writes:
> 
>     How can I have a cron task to execute tbmonitor tool to
>     archive or unarchive or backup trans. log periodically?

To the best of my knowledge, there is no way of performing a NON-INTERACTIVE
archive, unarchive, or logical log backup.

>     How can I execute tbmonitor without without the interactive mode???
>     [If it's instructed in the manual, pleeeease also tell me where it 
>      is mentioned, I still find the Informix manuals are not very clear
>      and easy to look-up something - my friends said too. ]

Tbmonitor options can be executed from the command line with "tbstat".  The
Online manual has an entire appendix chapter devoted to the tbmonitor on
the command line.

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.4
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: lhscmc@latrobe.edu.au (Craig Macbride)
Newsgroups: comp.databases.informix
Subject: isrecnum bug in C-ISAM
Summary: isrecnum is not set correctly in all cases of reading locked records
Date: 7 Apr 92 10:40:32 GMT
Organization: La Trobe University

There is some code which I have been working on which needs to know actual
record numbers for records being accessed with C-ISAM. (We are using version
4.00.UE1 running on a Xenix system.)

The manual clearly states that reading records with ISSKIPLOCK will set the
currect record pointer to the record read and set isrecnum to the value
appropriate to this record. If the record concerned is not locked by
another user at the time, or for _some_ types of isread() (eg. ISSTART) then
things always work correctly (as far as I can tell).

However, reading previous or next (ISPREV or ISNEXT) when the next or
previous record respectively is locked at the time by another user causes
the appropriate record _data_ to be returned but isrecnum is _unchanged_!!!

In other words, there is absolutely no way to _reliably_ tell what record
C-ISAM has returned to you!

Can anyone tell me how to get a fix to this, as it is holding up quite a bit
of software testing and implementation? Any comments much appreciated.

-- 
 _--_|\		Craig Macbride	<lhscmc@luxor.latrobe.edu.au>
/      \			<s900387@minyos.xx.rmit.oz.au>
\_.--.*/
      v
From: gaukur@rhi.hi.is (Kristjan Gaukur Kristjansson)
Newsgroups: comp.databases.informix
Subject: Ownership of (temp)tables.
Date: 6 Apr 92 11:06:05 GMT

I'm having a bit of a problem with temptables.
I'm using temptables for storing of select-results to use further later,
and that works just fine.
BUT, if I want to do two things at the same time that use the same temptable
name, and so start the 4gl program in two windows, I get a conflict between
the temptable(s) since in both cases it gets the same owner name, and that,
the good book says, is not allowed.

Now, the question is, is there any way to connect the tablename to the
process id. instead of the users login name?  Or even give temptables
variable names?  Or any other solutions?

		With thanks in advance,

				Gaukur.

				(gaukur@rhi.hi.is)
From: baem@cbnewsh.cb.att.com (brian.ae.meekings)
Newsgroups: comp.databases.informix
Subject: Re: Unknown sqlca.sqlcode (-522)
Date: 14 Apr 92 16:30:48 GMT
Distribution: usa
Organization: AT&T

In article <8719@emory.mathcs.emory.edu> MYERS@PASCAL.ACM.ORG writes:
>
>  I'm running INFORMIX/se 4.1 and ESQL/C 4.1 on a Sun4.  I get an error
>of (-522) and the book doesn't day what that is.  Any input would be
>appreciated.
>Thanx,
>Dow
>-------------------------------------------------------
>Dow Myers                           |  This space for rent.
>myers@acm.org                       |  Real Cheap.
>Applied Network Technologies, Inc.  |  Call,
>Waco, TX.                           |  (817) 752-6888


-522:Table (%s) not selected in query.
From: A.Heskett@bnr.co.uk (Tony Heskett)
Newsgroups: comp.databases.informix
Subject: Re: delimiters
Date: 16 Apr 92 21:23:11 GMT
Reply-To: A.Heskett@bnr.co.uk (Tony Heskett)
X-Informix-List-ID: <list.1074>


Kristen Altman writes:

> Informix fans,

???   ;-)

> I need to be able to put a delimiter between the data fields returned from
> a select statement.  This data is being written to standard output.  An
> example would be:
> 
> >isql testdb -
> >select field1, field2, field3 from test;  {where the delimiter is "|"}
> 
> a   |b   |c   |
> d   |e   |f   |

How 'bout something like:

isql sis <<HERE
select gen_awb, "|", gen_stn, "|", gen_dtmadd
from gen_rec;
HERE

which gives me :

    gen_awb (constant) gen_stn (constant)  gen_dtmadd

  193627895 |          ZEN     |            700105446
  916211133 |          BSL     |            700105446
  530039510 |          LUG     |            700105446
   14283651 |          ZRH     |            700105446
etc ...

You'll have to do the usual stuff to get rid of the headers,
etc, by writing it down a pipe and discarding stderr, but
that should swing it.

> Kristen Altman
> 
> P.S. In Sybase, this is accomplished with the isql command.  When you call
> isql, you can specify a delimiter to separate the fields.  Maybe there's 
> something similar in Informix that I don't know about (I hope).

So does that mean you're on the (Sybase) mailing list where you
get 15 copies of each piece of mail ?   Great, see you there
often    :-)

> *******************************************************
> *                   Kristen Altman                    *
> *                 kma@ccd.harris.com                  *
> *       Harris Controls and Composition Division      *
> *                   Melbourne, FL                     *
> ******************************************************* 

Hope this helps.

Cheers - Tony.
__________________________________________________________________________
Tony Heskett                 th@bnr.co.uk   Voice: (+44) 279 402637
BNR, London Road, Harlow, Essex, CM17 9NA   Fax:   (+44) 279 454187
From: cheryl@redriverad-emh1.army.mil (Cheryl Gross)
Newsgroups: comp.databases.informix
Subject: Methods of changing to upper case and taking the dash out
Date: 16 Apr 92 08:51:11 GMT
Reply-To: cheryl@redriverad-emh1.army.mil (Cheryl Gross)
X-Informix-List-ID: <list.1069>

REF:  Ruchi's Inquiry about updating to upper case and taking dashes out.

  Several other messages were much better about updates than my suggestions:

But:
  
  Create a C (ESQL/C) program to run to_upper on all the lower case data.
   toupper() 

  You could create a C (ESQL/C) program to read and update the phone number 
  using substring functions (string.h).
  
  
  cg
From: cimarron@erewhon.postgres.Berkeley.EDU (Cimarron D. Taylor </>)
Newsgroups: comp.databases
Subject: Re: Relational Systems set back DP by at least 10 yrs.
Followup-To: comp.databases
Date: 11 Apr 92 05:04:40
Organization: Postgres Research Group, U.C. Berkeley
Distribution: world
NNTP-Posting-Host: erewhon.berkeley.edu
In-reply-to: chandra@cs.tamu.edu's message of 9 Apr 92 22:41:22 GMT


Henry G. Baker writes:

 | As a designer of commercial manufacturing applications
 | on IBM mainframes in the late 1960s and early 1970s, I can
 | categorically state that relational databases _set the data processing
 | industry back at least ten years_ and wasted many of the billions of
 | dollars that were spent on data processing.

	From my experiences with IBM, I would say that it's more
	likely that IBM set the data processing industry back at
	least 10 years and that billions of dollars were wasted
	on IBM mainframes doing data processing.  ;-)

He also says

 | they made trivial problems _obviously_ trivial, but did nothing to
 | solve the really hard data processing problems. in fact, the advent
 | of relational databases made the hard problems harder

	I maintain that:

	1. Making trivial problems trivial is something to be proud
	   of when everyone else is making trivial problems hard.

	2. Don't expect something that makes hard problems trivial to
	   work wonders on trivial problems.

	3. Some problems are hard, no matter what you do.  
	   No system I know of can handle transitive closures well and
	   at the same time scale well.  (Perhaps someone out there
	   can enlighten me?)


	Since I have studied databases and since I make a living
	working with relational stuff, baker would probably try to
	dismiss me as a brainwashed relationite.  But I also like
	things like consistency, integrity and sound logical argument
	in general and I think Baker falls short here.

	In particular, Baker's paper contains a lot of whiny statements and
	catchy sound bites but no substantive criticisms.  Nor does he
	make his argument clear.  For instance, where does he state
	something like: ``Relational systems are bad because XXX''
	and then proceed to demonstrate that XXX is the case?  His letter
	was a textbook case of claiming to have shown something
	without having done so.  He seems to expect us to trust him
	because of his experiences in the 60's.


	Perhaps he will make his argument clearer in next month's ACM.


	Cimarron Taylor
	Electronics Research Laboratory / POSTGRES project
	University of California, Berkeley
	cimarron@postgres.berkeley.edu
From: troy@intelhf.hf.intel.com (Troy Allison)
Newsgroups: comp.databases
Subject: VPinfo documentation
Summary: Does anyone have or know of where I can get a users manual for VPinfo ver1.40d?
Keywords: documentation help
Date: 6 Apr 92 19:46:26 GMT
Article-I.D.: intelhf.1992Apr6.194626.7523
Organization: Development Tools Operation, Intel Corp., Hillsboro  OR

Does anyone know of where I might find and obtain documentation
on a p.c. based program called VPinfo.  The version I am working with
is 1.40d.  The company that made it is no longer; Rosa inc.  Any
information at all would be of great help!!  Thanks,

Troy
tallison@pcocd2.intel.com


-- 
=========================================================
It is easy to identify a begining martial-arts student:
s/he is the one practicing the most advanced technique
they know, while the advanced student practices the first
From: steven@monu6.cc.monash.edu.au (Steve Stergakis)
Newsgroups: comp.databases
Subject: INFO NEEDED on OOA Methodologies
Date: 9 Apr 92 00:43:10 GMT
Organization: Monash University, Caulfield Campus


NOTE: this message has been posted for persons that either use, teach 
or have some opinion regarding current OOA methodologies being 
used...

THIS MESSAGE HAS BEEN CROSS POSTED TO MANY NEWS GROUPS.  PLEASE 
DISREGARD IT IF HAS BEEN POSTED TO AN INCORRECT AREA.

i am a postgraduate student who is currently studying OOA and 
would greatly appreciate any information regarding experience
you have had with object oriented methodologies

as i am about to write a critical review of the current OO methodologies i 
would appreciate if you could tell me which approach you prefer.. or if
you know of any article that have compared current OOA methods, that would
also be greatly appreciated...

i am especially interested in persons who use such methodologies 
in practice.. their extent of their use in your work area.. 
the type of work you do.... and your opinion!

PLEASE feel free to comment on any of the above questions.. if you do
not wish to relate specific information pertaining to your work /
work environment, then leave it out

NOTE: if possible please reply directly to me 

thanks in advance

+------------------------------------------------------------+
| Steven Stergakis      steven@monu6.monash.cc.edu.au        |
|                                                            |
|                       (Post Graduate)                      |
|                       Faculty of Computing and Information |
|                       Technology                           |
|                                                            |
|                       Monash University - Australia        | 
+------------------------------------------------------------+
From: jja@amy (Joseph Alotta)
Newsgroups: comp.databases
Subject: Re: Looking for distributor of MUMPS
Date: 8 Apr 92 20:13:12 GMT
Organization: First National Bank Of Chicago, Chicago IL, USA

I met a distributor of MUMPS a while back.  Didn't catch the name but I  
did catch it bad.

--
Joe Alotta
First Chicago Corp.
jja@fnbc.com
(312)732-3439

"Wisdom is better than gold and understanding more valuable than silver."
Newsgroups: comp.databases
From: silvert@cs.dal.ca (Bill Silvert)
Newsgroups: comp.databases
Subject: Alpha 4 release 2 -- bug status?
Date: 11 Apr 92 16:36:11 GMT
Reply-To: silvert@biome.bio.ns.ca (Bill Silvert)
Distribution: na
Organization: Habitat Ecology Div., Bedford Inst. of Oceanography

There was some disucssion of this new release being very buggy and
the company working on it.  Any further developments?  We're 
wondering whether to go for the upgrade.
-- 
William Silvert, Habitat Ecology Division, Bedford Inst. of Oceanography
P. O. Box 1006, Dartmouth, Nova Scotia, CANADA B2Y 4A2.  Tel. (902)426-1577
InterNet Address: silvert@biome.bio.dfo.ca
-- 
William Silvert, Habitat Ecology Division, Bedford Inst. of Oceanography
P. O. Box 1006, Dartmouth, Nova Scotia, CANADA B2Y 4A2.  Tel. (902)426-1577
InterNet Address: silvert@biome.bio.dfo.ca
Newsgroups: comp.databases