HDTenEightyP/NetNews huggingface dataset:
From: infmx!obelix!johnl@uunet.UU.NET (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  Unknown sqlca.sqlcode (-522)
Date: 15 Apr 92 12:33:10 GMT
Reply-To: infmx!obelix!johnl@uunet.UU.NET (Jonathan Leffler)
X-Informix-List-ID: <list.1066>

>Subject: Unknown sqlca.sqlcode (-522)
>X-Informix-List-Id: <list.1057>

>  I get an error >of (-522) and the book doesn't say what that is...

>Dow Myers                           |  This space for rent.
>myers@acm.org                       |  Real Cheap.
>Applied Network Technologies, Inc.  |  Call,
>Waco, TX.                           |  (817) 752-6888

The 5.0 Error Messages book says:

-522 Table table-name not selected in query.

The table shown appears at some point in the query, but it does not
appear in the FROM clause.  Review the uses of this name: if it is
spelled as you intended, then add it to the FROM clause.

I have truncated you message as much as I could to ensure that this
answer gets through the informix-list gateway.

Yours sincerely,
Jonathan Leffler (johnl@obelix.informix.com)
From: jeffl@isg100.isg.com
Newsgroups: comp.databases.informix
Subject: Re: SQL query question
Date: 14 Apr 92 16:03:06 GMT
Reply-To: jeffl@isg100.isg.com
X-Informix-List-ID: <list.1058>

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

Correct.

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

Bzzt.  Sorry wrong answer, please try:

	update phonetab
		set (phonecol[4,7], phonecol[8])
		= (phonecol[5,8], " ")
		where phonecol[4] = "-"

This is assuming a phone number format of NNN-NNNN.

Hope this helps.

jeffl


----
Jeffrey F. Lawhorn             American TriTech/ISG
Programming Manager            C, C++, and Database Consulting
jeffl@isg.com                  450 B Street 16th Floor
sdsu!isg100!jeffl              San Diego, CA 92101   (619) 234-3405 x274
From: mrh@guug.de (Mark Herbert Mueller-BBM GmbH)
Newsgroups: comp.databases.informix
Subject: HP terminals and 4GL
Summary: Need termcap/terminfo for hp2392
Keywords: 4GL HP hp2392 termcap terminfo
Date: 16 Apr 92 17:11:40 GMT
From: dave@das13.snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: isql commands from shell prompt
Date: 14 Apr 92 01:11:12 GMT
Article-I.D.: das13.1654
Organization: Snide Inc. - Folcroft, PA

In article <1992Apr13.225513.8254@col.hp.com>, judym@col.hp.com (Judy Miller) writes:
> I have an Informix-SQL Version 4.00 in front of me.
> 
> How do I issue the following command from inside a shell script?
> 
>    load from "add_units.data" insert into fgistatus;
> 
> In which section is this discussed?  

Judy, try this in your shell script...

Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip
isql dbname - <<EOF
load from "add_units.data" insert into fgistatus;
EOF
Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.4
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: widener!uunet!infmx!quasar!aland@emory.mathcs.emory.edu (Alan Denney)
Newsgroups: comp.databases.informix
Subject: Re: bug in 4GL-4.10 menus
Date: 15 Apr 92 01:48:08 GMT
Reply-To: widener!uunet!infmx!quasar!aland@emory.mathcs.emory.edu (Alan Denney)
X-Informix-List-ID: <list.1064>

|> From uunet!rmy.emory.edu!informix-list-owner Fri Apr 10 12:22:30 1992
|> From: uunet!ssf.pt!mm (Manuel Monteiro)
|> To: informix-list@rmy.emory.edu
|> Subject: bug in 4GL-4.10 menus
|> 
|> There's a bug in 4GL (version 4.10) menus.
|> Try the following program:
|> 
|> 	main
|> 		menu "Test"
|> 			command "Aaaaaaaa"
|> 			command "Bbbbbbb"
|> 			command "Ccccc"
|> 			command "Ddddddddddddddddddddddddd"
|> 			command key("n","p") "Pppppppppppppppppppppppppp" "Second page"
|> 			command "Exit"
|> 				exit menu
|> 		end menu
|> 	end main
|> 
|> When you try to move from the first menu page to the next using the
|> <down-arrow> key you'll get no response as if you entered an endless loop.

You *have* entered an endless loop... ugh.  Same behavior in compiled 4GL 
and RDS.

|> This only happens if the first option of the second page has more than
|> one response key.

I would guess that it would happen on the first option of any page N+1.
Also, I found that it does the wrong thing with up arrow (stays on the 
first page instead of going to the last page).  

|> Any suggestions to work-around this bug are welcome.

If you omit the command string ("Ppppppp...p"), it works OK.  If you split the
two command keys "n" and "p" into separate options, it doesn't happen.

|> Thanks
|> MM
|> 
|> PS: I'm running Informix-4GL 4.10 in a DECstation with Ultrix 4.2
|> 
|> | Manuel Figueiredo Monteiro

You were the first user to report this.  I've reported it as a bug
(bug number 12662, FYI).


--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

"Yesterday, I got food poisoning.  I haven't decided when
 I'm going to use it."           -- Steven Wright
Newsgroups: comp.databases.informix
From: felicia@miller.cs.uwm.edu (Felicia Chu Peng Cheong)
Subject: HELP use tbmonitor non-interactive way!
Originator: felicia@miller.cs.uwm.edu
Organization: University of Wisconsin at Milwaukee
Distribution: na
Date: Thu, 9 Apr 1992 17:50:06 GMT

 
 HELP INformix veterans!  

    How can I have a cron task to execute tbmonitor tool to
    archive or unarchive or backup trans. log periodically?
 
    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. ]
 
    Thanks in advance.
 
    -felicia@point.cs.uwm.edu
From: infmx!obelix!johnl@uunet.UU.NET (Jonathan Leffler)
Newsgroups: comp.databases.informix
Subject: Re:  Curses And Informix?
Date: 13 Apr 92 19:53:11 GMT
Reply-To: infmx!obelix!johnl@uunet.UU.NET (Jonathan Leffler)
X-Informix-List-ID: <list.1055>

>From: uunet!npri6.npri.com!jhagen (Jarom Hagen)
>Date: 3 Apr 92 17:29:22 GMT
>Message-Id: <5269@npri6.npri.com>
>Subject: Curses And Informix?
>X-Informix-List-Id: <news.968>
>
>Hi,
>
>I am trying to evaluate Informix and it looks good except for curses
>handling.  Apparently Informix has put several "curses" routines in
>its libraries used for linking an executable.

#include <disclaimer.h>

Informix uses its own implementation of curses with termcap, and I think
it uses its own version of terminfo too (though I'd stand to be corrected
on that).  This library originates way back in the long-lost mists of
history, and need not bear any resemblance to any other form of
termcap/terminfo library.  It has never been documented that you can ever
call any curses routines and have them work the way you expect.  All that
has been said is that you can use the termcap (and possibly terminfo)
terminal definitions (with some Informix-only extensions if desired) to
describe your terminal in a format that Informix will understand.  Thus,
any linking problems you have using curses are because you are doing
unsupported things.

If you wish to use curses yourself, you may do so, but you need to decide
to do without any of Informix's termcap/terminfo stuff.  Specifically,
forget about form handling.  Hence, you should be using ESQL/C, not
Informix-4GL, because ESQL/C has no termcap routines in it. (Comment: it
might coincidentally have one or two routines with the same name, but I
haven't checked this out -- there are no routines deliberately with the
same name.  If there are name collisions, then you have a problem unless
the two versions of the routine definitely have the same interface and
functionality.)

>I have run into the following problems:
>1.  I have to draw a form before I can use a curses routine called
>    from a C program.  (Calling intscr() from a C program causes
>    the application to crash when a form is brought up.)
>2.  wclear() does not clear a window defined in a C program.
>3.  wprintw() is not defined.
>4.  I can't link with the curses library because I get multiple
>    definitions.
>There may be other problems, but these make it hard if not unworkable
>to use curses.
>
>Any help would be appreciated.
>Jarom
>-------------------------------------------------------------------------------
>  *Not paid for and/or endorsed by NPRI.  602 Cameron St, Alexandria VA 22314
>  (UUCP: ...uunet!uupsi!npri6!jhagen)       (Internet: jhagen@npri.com)

Summary: don't use curses functions with I4GL -- it only causes grief.

Jonathan Leffler (johnl@obelix.informix.com)      #include <disclaimer.h>
From: aland@informix.com (Colonel Panic)
Newsgroups: comp.databases.informix
Subject: Re: delimiters
Date: 17 Apr 92 05:54:32 GMT
Organization: International Brotherhood of Geeks, Local 619

In article <8743@emory.mathcs.emory.edu> kristen.m.altman@ccd.harris.com (Kristen Altman) writes:
|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   |
|
|My application uses only Informix-ISQL.                         
|
|If anyone has any idea how this might be accomplished (without using the
|unload command), I would love to hear from you!!

Why can't you use the UNLOAD command?  I can't fathom anything you need to
use it for that couldn't be accomplished with 
  UNLOAD TO PIPE <pgmname> select field1, field2, field3 from test;

|Thanks in advance
|Kristen Altman


--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

"Democracy means buying a house you can't afford with money you don't 
 have to impress people you wish were dead."         - Carson
Newsgroups: comp.databases.informix
From: hlt@napcc.cvm.uiuc.edu ("Harold L. Trammel")
Newsgroups: comp.databases.informix
Subject: Test of Mailer
Date: 14 Apr 92 18:03:10 GMT
Reply-To: hlt@napcc.cvm.uiuc.edu ("Harold L. Trammel")
X-Informix-List-ID: <list.1060>

This is only at test of the mailer to the
informix-list@rmy.emory.edu.

Sorry for the inconvience.

Harold


========================================================================
Harold L. Trammel                       |  Email: h-trammel@uiuc.edu 
National Animal Poison Control Center   |  Phone: 217-333-2053
College of Veterinary Medicine          |  FAX  : 217-244-1580
University of Illinois Urbana-Champaign |
Urbana, IL                              |
========================================================================
From: RUCHI%CFRVM.bitnet@VTVM2.CC.VT.EDU (Ruchi Patel)
Newsgroups: comp.databases.informix
Subject: SQL query question
Date: 13 Apr 92 23:43:13 GMT
Reply-To: RUCHI%CFRVM.bitnet@VTVM2.CC.VT.EDU (Ruchi Patel)
X-Informix-List-ID: <list.1056>


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

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.

Thanks in advance.

Ruchi Patel
Senior Programmer Analyst     Email: ruchi@cfrvm.cfr.usf.edu
Division of Telecommunications, OPM 128
Tampa, FL 33820-7549
Newsgroups: comp.databases.informix
From: dave@das13.snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: isrecnum bug in C-ISAM
Date: 14 Apr 92 17:03:54 GMT
Organization: Snide Inc. - Folcroft, PA

In article <1992Apr14.031228.10589@luga.latrobe.edu.au>, lhscmc@latrobe.edu.au (Craig Macbride) writes:
->In article <1653@das13.snide.com> dave@das13.snide.com (Dave Snyder) writes:
->>In article <1992Apr13.034933.2354@luga.latrobe.edu.au>, lhscmc@latrobe.edu.au (Craig Macbride) writes:
->>> When you read ISNEXT or ISPREV (with ISSKIPLOCK) and get a return code
->>> indicating that the record is locked, you know that isrecnum is junk, but
->>> the data returned is correct. Therefore, issue a read ISEQUAL on the key
->>> which the ISNEXT/ISPREV read returned. This second read will return not
->>> only the correct data, but also the correct isrecnum!
->>
->>Why not use ISCURR?  I believe that ISCURR reads the record where the
->>file pointer is pointing regardless of what is in isrecnum.  Also, this
->>method would work on Unique and Duplicate indexes (it'd be quicker too).
-> 
-> You'd have hoped that it would work, wouldn't you? Yep, it's the first thing
-> I tried, and guess what? When you use ISNEXT and get isrecnum left unchanged
-> from the previous call, and you then use ISCURR (and the record is still
-> locked by someone) ... isrecnum is _still_ not updated! 
-> 
Bummer!  Ok, Informix, what should we try next?  :-)

DAS
-- 
David A. Snyder @ Snide Inc. - Folcroft, PA                    Current Release
                                                               is db4glgen-3.4
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
Newsgroups: comp.databases.informix
From: jcarter@sun419.nas.nasa.gov (John R. Carter Sr.)
Subject: Re: SQL query question
Organization: Numerical Aerodynamic Simulation Facility NASA
Date: Tue, 14 Apr 92 15:35:29 GMT
Reply-To: jcarter@sun419.nas.nasa.gov (John R. Carter Sr.)

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.


------------------------------------------------------------------------------
John R. Carter, Sr.                          Programmer/Analyst - Informix DBA
Computer Sciences Corporation                jcarter@nas.nasa.gov
Numerical Aerodynamic Simulation             415/604-3662
NASA Ames Research Center, Moffett Field, CA 94035-1000   M/S 258-6
------------------------------------------------------------------------------
From: childres@c11038.b17d.ingr.com (Maria Childress)
Newsgroups: comp.databases.informix
Subject: Re:  Chunk Writes
Date: 16 Apr 92 19:48:12 GMT
Reply-To: childres@c11038.b17d.ingr.com (Maria Childress)
X-Informix-List-ID: <list.1072>


 Intergraph Corporation                                    TIM
 ============================================================================
                                                           E-Mail Memorandum
 
 Hi all,
 
     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?  In the 5.0 adminstrator's guide p. 2-71 it states 
 
    "During a chunk write, each page cleaner is assigned to one or more
 chunks."  So is this chunk a unit of disk space that makes up a dbspace?
 For performance reason, would it make sense to have one page cleaner per
 disk unit chunk rather that one page cleaner per scsi controller?
 
     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.
 
 
     Hope this all makes sense, if not maybe we can discuss it.
 
     Thanks in advance for all input.
 
 Maria
 
 
 
 
 
 +---------------------------------------------------------------------------+
 |Maria Childress               |Phone:      205-730-7938                    |
 |Intergraph Corporation - TIM  |E-mail:     childress@c11038.b17d.ingr.com  |
 |Database Support - Informix   |Fax:        205-730-7509                    |
 |Huntsville, AL 35894-0001     |Mail Stop:  IW17D1                          |
 +---------------------------------------------------------------------------+
Newsgroups: comp.databases.informix
From: lpc@dickens.com (Luis P Caamano)
Subject: Need gif file from 35mm slide to put on ONLINE. HELP!
Date: Fri, 10 Apr 1992 15:52:14 GMT
Organization: Dickens Data Systems, Inc.

Does anybody know of any company that can scan from a 35mm slide
and create a gif file?

This is for an interesting project using Wingz as the front end
and ONLINE as the backend. The project is for the 5th Centennial
of the discovery of America. This is in the Dominican Republic
and they want to have pictures of historical places in an ONLINE
database and show it up with WINGZ. They'll have some kind of touch 
screen and visitors would be able to touch the buttons on the
screen to retrieve the different picture and text BLOBS.

Now, they have the slides and they need somebody to scan them and
create the GIF files.

Any pointers? I tried to find somebody here in Atlanta but
all the companies I talked to only have text scanning services.

BTW You can send mail directly to them to: uunet!microc!jose

As always thanks in advance for your time on this.
-- 
---------------------------------------------------------------------------
Luis P. Caamano                    |         lpc@dickens.com
Dickens Data Systems, Inc.         |         uunet!ddssuprs!lpc
Norcross, GA                       |         (404) 242-5991
---------------------------------------------------------------------------
If you think you know it all, you'll stop learning. -myself
The more I learn, the more I know I know nothing. -somebody else
Xref: sparky comp.databases.informix:754 comp.databases:4114
From: lhscmc@latrobe.edu.au (Craig Macbride)
Newsgroups: comp.databases.informix,comp.databases
Subject: Informix support: Where are you?
Date: 13 Apr 92 04:15:18 GMT
Organization: La Trobe University

Recently, I have found a bug in Informix C-ISAM. The supplier has told
me that it is indeed a bug and that they have heard nothing about when/how
it will be fixed from Informix. I posted a message to comp.databases.informix
and received no reply from anyone.

How can one get Informix to do more than just acknowledge that a bug exists?
A fix or even a work-around would be far more useful.

-- 
 _--_|\		Craig Macbride	<lhscmc@luxor.latrobe.edu.au>
/      \			<s900387@minyos.xx.rmit.oz.au>
\_.--.*/
      v
From: suran@nff.ncl.omron.co.jp (Suran de SILVA)
Newsgroups: comp.databases.informix
Subject: Multimedia database
Date: 14 Apr 92 08:45:28 GMT
Distribution: comp.databases.informix
Organization: OMRON Corp., Kyoto, Japan

Hello,

        I was wondering if you may be able to help me.
Our section at Omron Japan is looking into multimedia
databases and I would like to talk to a developer at
Informix on the topic.  Would you be able to refer me
to an email address where I could find an appropriate
person or where I can ask further?

Thank you,
Suran de Silva

-------------------

                Omron Corporation | Suran de Silva (suran@nff.ncl.omron.co.jp)
                                        | Corporate Research & Development H.Q.
              | Shimokaiinji, Nagaokakyo-city, Kyoto, 617 Japan
                                                        | Tel (075) 951 - 5111
From: mukesh@elsouth.wsnc.org (Mukesh Rathor)
Newsgroups: comp.databases.informix
Subject: stuffing the read buffer
Keywords: buffer, read
Date: 6 Apr 92 21:29:45 GMT
Organization: Electrical South Inc.


>Under DOS, a character can be placed in the front of the keyboard
>buffer using the BIOS interrupt 16h, service 05h.  This character
>is the next one read by the Informix application and can be used
>in ON KEY code to push carriage returns into the keyboard buffer,
>which Informix then reads and interprets as user supplied keystrokes.
>This action results in Informix advancing to the next field and
>skipping the current field, but the current field's AFTER FIELD
>code is executed.  The same AFTER FIELD code is not executed when
>NEXT FIELD's are used.

>Does anyone know whether or not it is possible to reproduce this
>type of behavior under SCO Unix?
 
    or under Sys V 3.2.x.  I wrote a 4GL simulating sperform 2-screens
    interface. Upon pressing escape on one screen, I wanted to "stuff
    the buffer with an escape" so that when the next screen is
    displayed, it will get terminated and after input will do the 
    checking. I tried, and tried .... and finally resorted to 
    asking the user to press the esc key again. It would be very
    useful if the above was possible...

    Mukesh
    (mukesh@elsouth.wsnc.org)
From: bochner@das.harvard.edu (Harry Bochner)
Newsgroups: comp.databases.informix
Subject: Re: how to get the value of a typed-in field
Date: 8 Apr 92 17:32:43 GMT
Article-I.D.: das.1992Apr8.173243.27830
Organization: Aiken Computation Lab, Harvard University

In article <1992Apr7.162351.9860@cssnl.syssup.tds.philips.nl>, 
harry@.syssup.tds.philips.nl (Harry Weseman) writes:
|> 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?

If I understand you correctly, the problem is that the value isn't stored in the
variable until the user exits from the field, and that hasn't happened yet in
your case. Version 4.1 provides a way to do this (the get_fldbuf() function), but
it's described in the section on enhancements, so it doesn't look like there's
any way to do it in older versions. So I think you're out of luck, unless
upgrading is an option for you.

But maybe one of the real gurus can suggest an undocumented way to do it;
any ideas?

-- 
Harry Bochner
bochner@das.harvard.edu