Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!utgpu!water!watmath!clyde!rutgers!mit-eddie!uw-beaver!tikal!slovax!flak From: flak@slovax.UUCP Newsgroups: comp.databases Subject: Informix User's Group Message-ID: <445@slovax.UUCP> Date: Tue, 26-May-87 17:51:08 EDT Article-I.D.: slovax.445 Posted: Tue May 26 17:51:08 1987 Date-Received: Thu, 28-May-87 04:17:52 EDT Organization: R & D Associates., Tacoma, WA Lines: 631 Nothing much new this month. Still working on the flight planning program. This note from rossw@nezsupp: (note the new address also). " I have also spotted a problem in I4GL version 1.0. If you have an alpha (char type) field that is being used with a picture field as follows PICTURE="AAAAAAAAAA AAAAAAAAAA AAAAAAAAAA AAAAAAAAA AAAAAAAAAA" and try to INPUT into it, the user can not use any of the editing functions. This includes toggling from insert to overtype, deleting characters, and deleting the rest of the field. " The same problem exists in PERFORM in version 3.30 (plain vanilla Informix). You can only overtype data if *any* kind of a picture is involved. Attempting anything else gives you the error message: "You cannot use this editing function because a picture exists". at the bottom of the screen. We seem to be stuck with it. I've also encountered a different problem with using Informix across systems. The good news is that Informix Databases developed on a WICAT will work on HP 320's. (Simply uucp the files over!). I'm still skeptical about this, but it appears to be working so far. The bad news is that ACE programs aceprep'ed on one machine will not acego on the other. We have an application where users can mail reports around, and when they crossed from one system to another, we got a message about the version numbers being incompatible when running acego. The easy solution would be to have the user recompile the source on the target system, but this option is not available in our setup. Fortunately, we have the source and the license for WICAT Informix. We were able to determine that the problem was caused by round off error in the version numbers and made the appropriate patch. I imagine that there's a similar problem with formbuild and perform. We don't use them across systems in our applications so I wouldn't know. This month's mailing list: =========================================================================== flak Dan Flak ix01 Path: %s!flak R & D Associates 3625 Perkins Lane SW Tacoma, Wa 98466 Informix Types: 3.00 3.30 OS: Version 7, BSD 4.2, System V HARDWARE: Microvax II, Wicat, HP310, HP 320 ---------------------------------------------------------------- tron Dave Barker ix02 Path: %s!tron R & D Associates 3625 Perkins Lane SW Tacoma, Wa 98466 Informix Types: 3.00 3.30 SQL OS: BSD 4.2, System V, MS-DOS HARDWARE: Microvax II, HP 310, HP 320, AT&T 3B2, IBM PC ---------------------------------------------------------------- ewing Jeff Ewing ix03 Path: tikal!fluke!allegra!ihnp4!killer!lngnck!ewing Informix Types: ---------------------------------------------------------------- jmc jmc ix04 Path: tikal!uw-beaver!nike!ptsfa!jmc Pacific Bell San Ramon, Ca Informix Types: SQL ---------------------------------------------------------------- george George M. Sipe ix05 Path: logico!ism780c!seismo!gatech!rebel!george Tolerant Systems 6961 Peachtree Industrial Norcross, Ga 30071 Informix Types: SQL ESQL/C ESQL/COBOL C-ISAM 2.00 OS: TX 5.2 (BSD 4.2 compatable) HARDWARE: Tolerant Eternity P200 ---------------------------------------------------------------- paddock Steve Paddock ix06 Path: logico!ism780c!seismo!ut-sally!ut-ngp!melpad!paddock Gibson, Melven & Paddock CPA's Informix Types: ---------------------------------------------------------------- ludwigs Helmut Ludwigs ix07 Path: logico!ism780c!seismo!unido!quando!ludwigs Quantum GmbH Emil-Figge-Str. 83 D-4600 Dortmund 50 Informix Types: ---------------------------------------------------------------- gunnar Gunnar Stefansson ix08 Path: logico!ism780c!seismo!mcvax!hafro!gunnar Marine Research Institute Reykjavik Informix Types: ---------------------------------------------------------------- lasse Lars Hammarstrand ix09 Path: logico!ism780!seismo!enea!daab!lasse Datorisering AB Stockholm Sweden Informix Types: 3.00 3.30 SQL OS: UNIX Sys V, MS-DOS, CROMIX HARDWARE: Arete, Cromemco, IBM PC ---------------------------------------------------------------- dps2 David Silberberg ix10 Path: logico!ism780c!seismo!ulysses!gamma!dps2 Bell Communications Research Red Bank New Jersey Informix Types: ---------------------------------------------------------------- yost Brian Yost ix11 Path: logico!ism780c!seismo!bellcore!motown!bty!yost MBA-RDDR, Inc One Maple Avenue Netcong, New Jersey 07857 Informix Types: 3.30 OS: XENIX 3.x HARDWARE: Altos 586, 986, 2086 - AT&T PC ---------------------------------------------------------------- stu Stu Heiss ix12 Path: logico!ism780c!seismo!ihnp4!jpusa1!stu JPUSA 4707 N. Malden Chicago, Il 60640 Informix Types: 3.30 OS: UNIX SYS V, MS-DOS HARDWARE: Vyasin 68000, IBM-AT ---------------------------------------------------------------- steve Steve Harrison ix13 Path: tikal!uww-beaver!rutgers!sdcsvax!wolf!steve Systems 'n' Software Informix Types: ---------------------------------------------------------------- kristjan Kristjan Jonasson ix14 Path: tikal!uw-beaver!nike!seismo!mcvax!keilir!kristjan University of Iceland (RHI) Informix Types: HARDWARE: HP-9000 ---------------------------------------------------------------- mts Martin Stanley ix15 Path: tikal!uw-beaver!nike!seismo!utai!ms!mts Univerisity of Tronto AI Group Informix Types: ---------------------------------------------------------------- will Will Nelson ix16 Path: tikal!uw-beaver!nike!oliveb!cygnet!will Informix Types: ---------------------------------------------------------------- leo Leo Wilson ix17 Path: tikal!uw-beaver!seismo!kitty!sunybcs!leo Niagra Paper Company 99 Bud-Mil Drive Buffalo, N.Y. 14206 Informix Types: ---------------------------------------------------------------- richa Rich Ahrendt ix18 Path: tikal!uw-beaver!tektronix!tekecs!richa Tektronix Informix Types: 3.30 OS: UNIX BSD 4.2 ---------------------------------------------------------------- rick Rick Dhaenens ix19 Path: logico!ism780c!seismo!gatech!rdm!rick Informix Types: 3.30 SQL OS: UNIPLUS+ SYS V Release 2 HARDWARE: Cromemco System 420 ---------------------------------------------------------------- rjm Richard Malarcher ix20 Path: logico!ism780c!seismo!gatech!rdm!rjm Informix Types: 3.30 SQL OS: UNIPLUS+ SYS V Release 2 HARDWARE: Cromemco System 420 ---------------------------------------------------------------- per Per Ericson ix21 Path: logico!ism780!seismo!enea!daab!per Datorisering AB Stockholm Sweden Informix Types: 3.00 3.30 SQL OS: UNIX Sys V, MS-DOS, CROMIX HARDWARE: Arete, Cromemco, IBM PC ---------------------------------------------------------------- ries Marc Reis ix22 Path: logico!trwrb!ries TRW Operations and Spt Group Informix Types: SQL HARDWARE: Pyramid 98X ---------------------------------------------------------------- bobbyo Bob Ollerton ix23 Path: tikal!uw-beaver!rutgers!sdcsvax!celerity!bobbyo Celerity Computing 9692 Via Excelencia San Diego, Ca 92126 Informix Types: Fileit, C-ISAM HARDWARE: Celerity Systems ---------------------------------------------------------------- andrews Murray Andrews ix24 Path: logico!ism780c!seismo!munnari!trldeity.oz!andrews Telematic and Message Service Center Telecom Australia Research Labs P.O. Box 249 Clayton, Victoria 3168, Australia Informix Types: OS: Unix SYS V, Unix SYS III, Xenix HARDWARE: AT&T 3B2 ---------------------------------------------------------------- scott Scott ix25 Path: logico!psivax!sdcrdcf!hplabs!parcax!cdp!scott Informix Types: SQL ISQL HARDWARE: Plexus P/60, SysVr2, 68000 ---------------------------------------------------------------- mlt1l H. Dudley Winn II ix26 Path: tikal!uw-beaver!tektronix!decvax!seismo!sundc!nears!oktext!mlt1l SWBT Oklahoma MLT Facilities Informix Types: SQL HARDWARE: AT&T 3B20, Pyramid ---------------------------------------------------------------- asv Stan Voket ix27 Path: tikal!fluke!allegra!ihnp4!msudoc!edstb!gaboon!asv Informix Types: SQL OS: Xenix V.2 HARDWARE: IBM AT ---------------------------------------------------------------- metro Metro T. Super, Jr ix28 Path: tikal!uw-beaver!nike!siesmo!bpa!assi!metro Assessment Systems, Inc 210 South Fourth Street Philidelphia, Pa 19106 Informix Types: ---------------------------------------------------------------- al Al Gettier ix29 Path: logico!ism780c!seismo!ihnp4!infosw!al Teknekron Infoswitch 1784 Firman Drive Richardson, Texas 75081 Informix Types: OS: Unix Sys V HARDWARE: Arete ---------------------------------------------------------------- ray Ray Tripamer ix30 Path: logico!psivax!sdcrdcf!otto!jimi!asci!ray Applied Systems Consultants, Inc Las Vegas Informix Types: SQL SQL 1.1, 2.0 & ESQL 1.1, 2.0 OS: Xenix 3.2f, Xenix 3.1a, Xenix 3.4 HARDWARE: Altos 886, Altos 486 ---------------------------------------------------------------- johnc John Ciccarelli ix31 Path: tikal!fluke!sun!plx!zaphod!johnc Plexus Computers Inc. 3833 N. First Street San Jose, Ca 95134 Informix Types: ---------------------------------------------------------------- warren Warren Burstein ix33 Path: logico!ism780c!seismo!rutgers!pyrnj!pluto!warren Industrial Automation Systems New York New York Informix Types: HARDWARE: Pyramid 90-X ---------------------------------------------------------------- pds Peter Smith ix34 Path: logico!psivax!csun!titan!pds Computer Science CSUN 18111 Nordhoff St Northridge, Ca 91330 Informix Types: HARDWARE: IBM PC/XT ---------------------------------------------------------------- horton Kurt H. Horton ix35 Path: logico!psivax!ihnp4!erc3ba!horton AT&T Engineering Research Center P.O. Box 900 Princeton, N.J. 08540 Informix Types: SQL OS: Unix SYS V HARDWARE: AT&T 3B20 & 3B2 ---------------------------------------------------------------- dmw10 Dale Wells Sansing ix36 Path: logico!ism780c!amdahl!dmw10 Amdahl Corporation Columbia, Md 21044 Informix Types: OS: UTS (SYS V, R2 & R3) HARDWARE: Amdahl 580 (5870, 5860) ---------------------------------------------------------------- jty Jyrki Yli-Nokari ix37 Path: logico!ism780c!seismo!mcvax!intrin!jty Intrinsic Oy SF-33100 Tampere Finland Informix Types: SQL 4GL OS: HPUX, PC-DOS HARDWARE: HP 9500, 9300 & HP Vectra (AT clone) ---------------------------------------------------------------- demasi Michael C. DeMasi ix38 Path: logico!ism780c!seismo!decuac!grebyn!paisana!demasi AT&T Communications 3702 Pender Drive Oakton, Va 22030 Informix Types: 3.30 SQL HARDWARE: AT&T 3B2/400 ---------------------------------------------------------------- phm Peter Mabey ix39 Path: logico!ism780c!stl.stc.co.uk!phm STL Harlow, U.K. Informix Types: SQL OS: Unix SYS V HARDWARE: ICL DRS-300 ---------------------------------------------------------------- rossw Ross Wakelin ix40 Path: logico!ism780c!seismo!mnetor!utcs!utai!calgari!vuwcomp!nezsupp!rossw ICL (NZ) Ltd P.O. Box 394 Wellington New Zealand Informix Types: SQL ESQL - (4GL soon) OS: Unix Sys V HARDWARE: ICL Clan 3 ---------------------------------------------------------------- phcch Chuck Chesser ix41 Path: logico!psivax!ihnp4!akgua!phuxa!phuxc!phcch AT&T Network Systems P.O. Box 13369 Phonenix, Az 85002 Informix Types: 3.30 SQL SQL 1.1 & 2.0, 4GL, ESQL/C OS: Unix SYS V HARDWARE: 3B2 ---------------------------------------------------------------- cindy Cindy Vaughan ix42 Path: logico!trwrb!scgvaxd!cbosgd!cbatt!ihnp4!akgua!usfvax2!pdn!cindy LF-207 Paradune Corp. 8550 Ulmerton Road Largo, Fl 33541 Informix Types: ---------------------------------------------------------------- neighorn Steven C. Neighorn ix43 Path: tikal!uw-beaver!tektronix!reed!psu-cs!qiclab!neighorn Portland Public Schools 501 N. Dixon Portland, Oregon 97227 Informix Types: 3.01.09 (network version) OS: PC-DOS 3.2 HARDWARE: IBM PC/XT & PC/AT w/3COM File Server ---------------------------------------------------------------- domq Dominique Emerson ix44 Path: logico!ism780c!seismo!pyramid!ctnews!mitisft!domq 174 Preston Dr Mountain View, Ca 94040 Informix Types: ---------------------------------------------------------------- pete Pete Rourke ix45 Path: logico!ism780c!pbox!pete MicroAge Tulsa, OK Informix Types: 3.30 SQL OS: Xenix, DOS HARDWARE: AT&T 3B1, IMB PC/AT, Compaq 386/130, Altos 3086 ---------------------------------------------------------------- rm2w Randy Magliozzi ix46 Path: logico!ism780c!watt.acc.virgina.edu!rm2w University of Virginia Academic Computing Center, Gilmer Hall Charlottesville, Va 22903 Informix Types: 3.30 SQL OS: Unix SYS V 3.0 HARDWARE: ATT 3B5/3B2 ---------------------------------------------------------------- colsmith Marcia Colsmith ix47 Path: logico!ism780c!seismo!moss!ihu1e!colsmith AT&T Information Systems Informix Types: SQL ESQL HARDWARE: AT&T 3B2 ---------------------------------------------------------------- kwan Choi Kwan ix48 Path: tikal!uw-beaver!ihnp4!mhuxa!kwan Informix Types: OS: Unix Sys V HARDWARE: AT&T 3B2 ---------------------------------------------------------------- dab Dave Burke ix49 Path: logico!psivax!hoptoad!ptsfa!gladys!mtune!barak!dab AT&T Informations Systems Informix Types: SQL SQL 2.0, 4GL 1.0, ESQL-C OS: Unix SYS V HARDWARE: AT&T 3B1 ---------------------------------------------------------------- jeff Jeff Dean ix50 Path: tikal!hplsa!hplabs!cdp!jeff Informix Types: ---------------------------------------------------------------- -- {psivax,ism780}!logico!slovax!flak : {hplsla,uw-beaver}!tikal!slovax!flak Dan Flak-R & D Associates,3625 Perkins Lane SW,Tacoma,Wa 98466,206-581-1322