HDTenEightyP/NetNews huggingface dataset:
From: inf_bb@hermes1.sps.mot.com (informix users bb)
Newsgroups: comp.databases.informix
Subject: Re:  4GL date routine, HOW?
Date: 7 Jan 1993 14:48:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: inf_bb@hermes1.sps.mot.com (informix users bb)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1759>

ed,

your problem statement says that you are computing the number
of days between 2 dates.  your program is computing 60 days 
prior to today. ??  here is a short program for you:

database stores

main
  define date1 date
  define date2 date
  define date3 date
  define diff  integer

  prompt "ENTER DATE1" for date1
  prompt "ENTER DATE2" for date2

  # get the number of days between the two dates
  let diff = date2 - date1

  # add 'diff' days to date2
  let date3 = date2 + diff

  display "DATE1 : ",date1
  display "DATE2 : ",date2
  display "Days between DATE1 & DATE2 : ",diff
  display "DATE2 + (Days between DATE1 & DATE2) : ",date3

end main

regards,

------------------------------------------------------------------------------
                                                            |     .     .
  Bob Baskett                                               |    ...   ...
  Software Engineer, DBA                                    |   ..... .....
  Business Systems Integration Group                        |  ..   ...   ..
  Semiconductor Products Sector                             | .      .      .
  Mesa, AZ                                                  |
                                                            |  Motorola, Inc
------------------------------------------------------------------------------
From: jparker@hpbs2776.boi.hp.com (Jack Parker)
Newsgroups: comp.databases.informix
Subject: Carl Wuebkers 'recovery' problem.
Date: 11 Jan 1993 15:33:04 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jparker@hpbs2776.boi.hp.com (Jack Parker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1771>

Folks,

After perusing the responses to Carl's problem I realized that no-one
has come up with this answer, so here it is.  

We had this problem over and over again and started re-creating it on
purpose to devise a solution.  The solution wound up being to lower the high
water marks by 10%:

LTXHWM          70              # Long TX high-water mark (percent)
LTXEHWM         80              # Long TX exclusive high-water mark (percent)

I also bumped the log files to incredible sizes, (24 500k logs, we log to disk,
- since this is a development machine I have some free rein on disk - tee hee.

Bumping the log files didn't solve it on it's own since no matter how big
your logs are, sooner or later someone is going to do a 
'LOAD FROM xxx INSERT INTO...' which will throw you into this situation, but
the high water marks made a big difference.

I also started educating the users NOT to use 'LOAD FROM...' but rather dbload
instead.  There are a couple of other statements which will really cramp
your style - like updates on a big table which don't lock the table first.
Generally get your users - and yourself - to use common sense and avoid
Loing Transaction situations.  You could even turn off logging for BAD 
transactions.  When you do wind up getting locked up in the logfiles - DON'T
to that kill thing.  Be very careful to check latches and whether the 
transaction has gone 'critical' before shooting it.  On-Line has eventually
killed long transactions for me when I couldn't shoot them myself - but
every time someone has shot a 'critical' transaction we've been in (In
Big George's Words) deep doo-doo.

Yeah, I know that most of you already know this but what the hey.

j.
_____________________________________________________________________________
Jack Parker - Contractor               | 
Hewlett Packard, BSMC Boise, Idaho, USA|    I forget how much I remember
jparker@hpbs2651.boi.hp.com            |           
(208) 323-5388 (W)  (208) 384-1623 (H) |
_____________________________________________________________________________
Newsgroups: comp.databases.informix
From: hlam@bnr.ca (Hayward Lam)
Subject: NeXT User Group Of Ottawa Meeting on January 7th
Reply-To: hlam@bnr.ca (Hayward Lam)
Organization: Bell-Northern Research Ltd.
Date: Tue, 5 Jan 1993 20:16:31 GMT

NeXT User Group of Ottawa Meeting on January 7th
------------------------------------------------


When : Thursday, 7:00pm
Where: ComputerActive
       21 Antares Dr., Unit 112,
       Ottawa, Ontario, Canada


Topics: 
***  Database on NeXT  ***
Demo and discussion on databases and development tools 
available on NeXT.
Inlcude Parabase, Sybase, Oracle, DBkit, Objective DBtool kit etc.
Topic will be oriented for users and developers alike.
Demo machine is a NeXTcube with NeXTdimension board.

(A guest will talk about their experience with database 
development. Not confirmed yet.)


***  General discussion  ***
CD-ROM drive available for 3.0 upgrade.
Software packages discount for user group members.
NeXTWorld Expo etc.


Please pass the news around to whoever might be interested.
Feel free to contact me if you have any questions.


Regards,
Hayward

phone: 613-763-3663
email: hlam@bnr.ca
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: hidden password entry
Date: 12 Jan 1993 22:33:04 -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.1778>

Quoting System Admin...
} 
} Two questions:
} 
} One is any one keeping the archive of this news group and so where is it located ?
} 
Yes, there is an archive of all informix-list stuff kept on mathcs.emory.edu.
This is an anonftp site.

} Secondly: I remember someone posted a routine a while ago which lets you do
} hidden password entry.  Con somone repost it or sent me the sample ??
} 
I did, it's short so here it is again...

Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip
MAIN
    DEFINE  c CHAR(1)           # Get character
    DEFINE  psw CHAR(8)         # Store the password
    DEFINE  i SMALLINT          # Counter

    OPTIONS PROMPT LINE 22
    FOR i = 1 TO 8
        PROMPT "Enter password: " FOR CHAR c
        IF (c IS NULL) THEN     # Check for space or return
            EXIT FOR
        ELSE
            LET psw = psw CLIPPED, c
        END IF
    END FOR
END MAIN
Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: Helen@daisy.UUCP (Helen C Payne)
Newsgroups: comp.databases.informix
Subject: Slicing up big disk section
Distribution: world
Date: Mon, 11 Jan 93 10:24:12 GMT
Organization: Payne Day Corp

Helen Payne                                      
helen@daisy.UUCP                                
                                               
					
{ Article also posted to comp.sys.hp}


                                               
                                        
We have a HP827 running HP/UX 8.02, using Informix Online 4.0 and 
several 1.3Gb disks, with a default section 5 of approx 900Mb.

A particular application would like to live on a 200Mb partition.

Informix will allow me to configure database chunks specifying a 
raw disk device and an offset, so there shouldn't be a problem 
there.  (X-posting to comp.databases.informix in case someone
knows otherwise)

I would like to configure a unix file system of roughly 200Mb
on the first part of section 5, and a couple informix database 
chunks on the last part.

I have tested this (in part) by using mkfs to make a "short" system 
at the start of section 5.  'df' reported a file system of the 
desired size.

I spoke to HP support and they assure me that it is NOT possible to
divide the section in two as the device driver gives you a 900Mb section,
end of story.   ie.  "that's the way it works".  I was unable to get a
more technical explanation.  When I asked if I could put a short file system
at the start of the partition, and specify an offset to Informix to build 
a raw database using the rest of the partition, they said that this was
also not possible.

Is there anyone out there who has succeeded in such an exercise, 
or is able to tell me why it won't work?
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: 2 questions: 4GL source length limit & screen redraw question
Date: 12 Jan 1993 23:03:04 -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.1779>

Quoting paul linton...
} 
} 2) With ^R to redraw the screen and Informix refreshing underlying windows
}    when one is closed it makes sense to think there is some sort of
}    data structure keeping track of what the screen should look like.  I
}    would appreciate any information to access that structure.  In this case
}    I would like to dump the current screen to a file/printer from an
}    ON KEY(whatever) CALL dumpScreen() type senario.
} 
You are correct in your assumption that some type of stucture keeps track of
the screen.  Sounds like you want fgl_prtscr().  This function is available in
most versions of db4glgen.  BTW, db4glgen-3.9 does have this function.

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: ttvvtt@mixcom.com (Donald Amby)
Subject: How to apply changes to Informix database(s)?
Organization: Milwaukee Internet Xchange BBS, Milwaukee, WI U.S.A.
Date: Thu, 07 Jan 1993 21:50:44 GMT


We have a set of Informix-4GL applications which use a number of
databases in a partition (Informix-ONLINE), for which we need to make
a new release.  As part of the next version we have:

    1. Introduced some new databases.
    2. Added some tables to existing databases.
    3. Added some fields to existing tables.
    4. Removed some fields from existing tables.

This is all in addition to the code changes which operate on the
databases.

I need to come up with a procedure or set of tools, which can help
automate the conversion/upgrade of the database(s) from one version
(old) to the next (new).  Are there any tools, or recommendations,
from anyone that may have done this before?

I am in the initial research stages, so I am looking at different
alternatives.  One suggestion has been to do a dbschema of the old
database(s) and new database(s), and use the differences to
build a set of isql commands to apply the changes to the old database.
-- 
Donald E. Amby
    amby@mixcom.com             414-797-6713 (voice)   414-797-6533 (FAX)
    Harnischfeger Engineers, Inc., P.O.Box 1512, Milwaukee, WI 53201-1512
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Negative PIDS, and SE/Online questions
Date: 11 Jan 93 22:03:00 GMT
Organization: Informix Software, Inc.

Naomi Walker writes:
>
>Hey, all you Informix gurus.....
>
>I have two questions.  The following is an excerpt from the Informix error
>log on a Pyramid MIS-S server, runing 4.1 UC1 Online and 4.1 UC1 ESQL/C.
>I've seen these negative pid's and funky user numbers before, and sloughed
>them off as programming boo-boos.  All I really know is that we had a
>scheduled reboot of this machine, for another reason.  Anyone seen this
>negative pid and user id before or have any comments?

When tbinit detects that a user's server process has died, it marks the pid
in the user structure as negative.  I'm not sure why it should do this,
other than to flag that it is a problem.

Once upon a time, this also showed up as a result of a real problem on
AIX: IBM used 64bit userids, whereas we used 2 bytes to track it in
shared memory; when the pid got too high, it showed up as a negative
number.  This was the only platform, that I know of, where this was the
case.

>My next question is about SE.  I am very familiar with all the Informix
>tools available to me when using Online.  I am not familiar with SE.
>In general, are the same or equivalent tools available when using the
>standard engine (tbcheck)?  How about all the sql statements, like 
>$ SET EXPLAIN ON/OFF, and $ ALTER TABLE to change things like lock modes
>and next extent?

bcheck is the SE equiv of tbcheck, though it provides less (no equiv
of the -p options); SET EXPLAIN is available with SE; there are no lock
modes or extents with SE, so these ALTER TABLE statements do not
apply.  Off the top of my head, the following OnLine items are not
available with SE:

	Isolation levels
	BLOBS
	VARCHARs
	Buffered/Unbuffered Log toggle
	Distributed queries (I-Star)
	Deferred constraints


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: inf_bb@hermes1.sps.mot.com (informix users bb)
Newsgroups: comp.databases.informix
Subject: Re:  2 questions: 4GL source length limit & screen redraw question
Date: 12 Jan 1993 16:38:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: inf_bb@hermes1.sps.mot.com (informix users bb)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1775>

paul,

im not sure about your first question on size of program modules,
but the second one:

2) With ^R to redraw the screen and Informix refreshing underlying windows
   when one is closed it makes sense to think there is some sort of
   data structure keeping track of what the screen should look like.  I
   would appreciate any information to access that structure.  In this case
   I would like to dump the current screen to a file/printer from an
   ON KEY(whatever) CALL dumpScreen() type senario.

yes, there is a way to print the current screen.  you must first set the 
DBSCREENOUT environment variable to the name of the file you want to
save the screen to.  then just run the program and hit CONTROL-P as many
times as you like.  the screen images will be appended to the file named
by DBSCREENOUT.  

regards,

------------------------------------------------------------------------------
                                                            |     .     .
  Bob Baskett                                               |    ...   ...
  Software Engineer, DBA                                    |   ..... .....
  Business Systems Integration Group                        |  ..   ...   ..
  Semiconductor Products Sector                             | .      .      .
  Mesa, AZ                                                  |
                                                            |  Motorola, Inc
------------------------------------------------------------------------------
From: willem@sparc-1.law.columbia.edu (System Admin)
Newsgroups: comp.databases.informix
Subject: hidden password entry
Date: 12 Jan 93 14:33:47 GMT
Organization: Columbia University

Two questions:

One is any one keeping the archive of this news group and so where is it located ?

Secondly: I remember someone posted a routine a while ago which lets you do
hidden password entry.  Con somone repost it or sent me the sample ??

Thanks.
-Willem.

-- 
===============================================================================
Willem Scholten			Mail:       willem@lawmail.law.columbia.edu
Columbia Univ Law School	FedEx mail: willem@sparc-1.law.columbia.edu
Computer Center			Fax:	    1 212 854 7946
435 West 116th Street
Room 7W1			
New York,  NY 10027			
ph: 1 212 854 7938
===============================================================================
From: davek@informix.com (David Kosenko)
Newsgroups: comp.databases.informix
Subject: Re: Informix & Tuxedo
Date: 8 Jan 93 15:51:40 GMT
Organization: Informix Software, Inc.

Apostolos Dedes writes:
>Help!
>I need to get the 2-phase commit to work using Informix as the Database
>Manager & Tuxedo as the Transaction manager. If someone on the net has
>already done this I would appreciate a phone call or a personal message
>for a couple of questions that I have.

Note that two phase commit can only be accomplished using OnLine and the
TP/XA product. Two phase commit cannot be accomplished with SE. It
cannot be accomplished with OnLine *without* TP/XA.

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
Newsgroups: comp.databases.informix
From: riskit@x400gate.bnr.ca (Reg Foulkes)
Subject: Updating within a scrolling cursor
Followup-To: comp.databases.informix
Organization: Bell-Northern Research
Date: Thu, 7 Jan 1993 20:27:01 GMT

I would like to access the temporary file created by the a scrolling 
cursor. Anyone know how to do this (i.e. what is the mystery table name)? 
 
 Here is what I would like to do

  Declare scrolling cursor sel_stmt 
  Open sel_stmt
  RUN "insert into mystery_table VAULES (....) | isql database - -"
                   ^^^^^^^^^^^^^
  FETCH next sel_stmt


I am aware the I could create a scrolling cursor on an indexed column 
in a query set. And then do all FETCHES, UPDATES and DELETS on the actual
table using the scrolling cursor as an index into the database.

riskit@bnr.ca
phone (613) 763-4131
Ottawa, Ontario Canada.
From: jgordon@ssf-sys.DHL.COM (Jim Gordon)
Newsgroups: comp.databases.informix
Subject: Online 5.01
Date: 12 Jan 1993 19:38:06 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: jgordon@ssf-sys.DHL.COM (Jim Gordon)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1777>


Does anyone have any inside knowledge on when Informix is releasing
Online 5.01 for the HP 9000?  I am told the Sun port is available but
the best date we can get for HP is Q1.  We want to start using
Triggers on a new project which is about to go into design.

Cheers - Jim
--------------------------------------------------------------------
Name:     Jim Gordon               Internet: jgordon@ssf-sys.DHL.COM
Company:  DHL Systems Inc          Phone:    (415) 358-5911 (Work)
Address:  1700 S. Amphlett Blvd.             (415) 882-9728 (Home)
          San Mateo, CA 94402      Fax:      (415) 571-6429
--------------------------------------------------------------------
From: dave.snyder@snide.com (Dave Snyder)
Newsgroups: comp.databases.informix
Subject: Re: Slicing up big disk section
Date: 10 Jan 1993 22:58:05 -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.1767>

Quoting Helen C Payne...
} 
} We have a HP827 running HP/UX 8.02, using Informix Online 4.0 and 
} several 1.3Gb disks, with a default section 5 of approx 900Mb.
} 
} A particular application would like to live on a 200Mb partition.
} 
} Informix will allow me to configure database chunks specifying a 
} raw disk device and an offset, so there shouldn't be a problem 
} there.  (X-posting to comp.databases.informix in case someone
} knows otherwise)
} 
} I would like to configure a unix file system of roughly 200Mb
} on the first part of section 5, and a couple informix database 
} chunks on the last part.
} 
} I have tested this (in part) by using mkfs to make a "short" system 
} at the start of section 5.  'df' reported a file system of the 
} desired size.
} 
I'm not all that familar with HP systems, but if the hard disks are set
up similar to most other systems, I can give a simple suggestion.  Why
not make section 5 700Mb in size and create another section of 200Mb
for informix?  Doing it that way, you won't have to worry about filesystem
offsets.  This is how my harddisk is set up:

+---------------+---------------+--------+---+-------------+------------+
| Name          | Type          | New FS | # | First Block | Last Block |
+---------------+---------------+--------+---+-------------+------------+
| root          | EAFS          |  yes   | 0 |            0|      147604|
| swap          | NON FS        |  no    | 1 |       180373|      196372|
| ootdbs        | NON FS        |  no    | 2 |       147605|      180372|
|               | NOT USED      |  no    | 3 |            -|           -|
|               | NOT USED      |  no    | 4 |            -|           -|
|               | NOT USED      |  no    | 5 |            -|           -|
| recover       | NON FS        |  no    | 6 |       196373|      196382|
| hd0a          | WHOLE DISK    |  no    | 7 |            0|      196991|
+---------------+---------------+--------+---+-------------+------------+

Because of the size of the harddisk, I have only a root filesystem.  But
what I also have is a section specifically set aside for Informix-ONLINE.
The "ootdbs" is 32Mb in size and I don't have to do any offsetting because
it is on a different slice of the harddisk than the root filesystem.  BTW,
the reason the slice is called "ootdbs" is because block devices have an
'r' prepended to reference the corresponding character device, ie. "rootdbs".

DAS
-- 
David Snyder @ Snide Computer Services - Folcroft, PA          Current Release
                                                               is db4glgen-3.9
UUCP:  ..!uunet!das13!dave   INTERNET:  dave.snyder@snide.com
From: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
Newsgroups: comp.databases.informix
Subject: Negative PIDS, and SE/Online questions
Date: 11 Jan 1993 13:03:03 -0500
Organization: Mailing List Gateway
Distribution: world
Reply-To: anasaz!qip.naomi@enuucp.eas.asu.edu (Naomi Walker)
NNTP-Posting-Host: emory.mathcs.emory.edu
X-Informix-List-ID: <list.1769>


Hey, all you Informix gurus.....

I have two questions.  The following is an excerpt from the Informix error
log on a Pyramid MIS-S server, runing 4.1 UC1 Online and 4.1 UC1 ESQL/C.
I've seen these negative pid's and funky user numbers before, and sloughed
them off as programming boo-boos.  All I really know is that we had a
scheduled reboot of this machine, for another reason.  Anyone seen this
negative pid and user id before or have any comments?

Question #1
==============================================================================

Fri Jan  8 00:00:16 1993

19:55:40  Level 0 Archive Started
20:39:28  Level 0 Archive Completed
23:12:45  Shutdown Mode
23:12:56  Process Aborted Abnormally: pid=-1541 user=1002 us=11001fd8 flags=1
23:12:56  Process Aborted Abnormally: pid=-21712 user=-25536 us=1100211c flags=1
23:12:56  Process Aborted Abnormally: pid=-18047 user=-25536 us=11002704 flags=1
23:12:56  Process Aborted Abnormally: pid=-8545 user=-21525 us=110028b4 flags=1
23:12:56  Process Aborted Abnormally: pid=-23189 user=21708 us=11002920 flags=1
23:12:56  Process Aborted Abnormally: pid=-24163 user=-25536 us=11002cec flags=1
23:12:56  Quiescent Mode
23:12:58  INFORMIX-OnLine Stopped

Fri Jan  8 23:19:33 1993

23:19:33  INFORMIX-OnLine Initialized -- Shared Memory Initialized
23:19:33  Physical Recovery Started
23:19:33  Physical Recovery Complete: 0 Pages Restored
23:19:33  Logical Recovery Complete: 0 Committed, 0 Rolled Back
23:21:32  On-Line Mode
==============================================================================

Question #2

My next question is about SE.  I am very familiar with all the Informix
tools available to me when using Online.  I am not familiar with SE.
In general, are the same or equivalent tools available when using the
standard engine (tbcheck)?  How about all the sql statements, like 
$ SET EXPLAIN ON/OFF, and $ ALTER TABLE to change things like lock modes
and next extent?

-- 
  Naomi Walker  (aka N7FSA)     naomi%anasaz.UUCP@asuvax.eas.asu.edu

  Enthusiasm is caught,         In tennis, 
  not taught.                   love means nothing.
Newsgroups: comp.databases.informix