Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Name Modified Size InfoDownloads / Week
Parent folder
equipment.sql 2020-05-11 554 Bytes
equipment.unl 2020-05-11 278 Bytes
i_equip.4gl 2020-05-11 32.3 kB
i_equip.hlp 2020-05-11 3.6 kB
i_equip.per 2020-05-11 818 Bytes
i_equipb.per 2020-05-11 733 Bytes
lu_equip.4gl 2020-05-11 7.3 kB
lu_equip.per 2020-05-11 539 Bytes
Makefile 2020-05-11 2.4 kB
o_equip.4gl 2020-05-11 4.8 kB
o_equip.hlp 2020-05-11 754 Bytes
o_equip.per 2020-05-11 662 Bytes
README 2020-05-11 1.7 kB
recursive.ec 2020-05-11 3.3 kB
usr_funcs.c 2020-05-11 4.5 kB
Totals: 15 Items   64.3 kB 0
From: dave@nfs.ee.vill.edu (Dave Snyder)
Subject: Recursion
To: informix-list@rmy.emory.edu (INFORMIX Mailing list)
Date: Mon, 4 Dec 1995 08:12:31 -0500 (EST)

Several people have asked me for my examples of true recursion in 4GL.  One
even suggested posting it to the list so it gets auto-archived at Emory.

Anyway, I'm not into giving out proprietary code so this past weekend I
whipped up this little demo.  If you don't already have the "stores" database
on your system, create it.  Build the "equipment" table by typing the
following:
  dbaccess stores equipment.sql

After the table is built and loaded, compile the program by typing:
  make

That's all there is to it.  RDS only people, you'll have to build a custom
runner for this sucker.  Grab my "db4glgen" program for help in making it.

The i_equip.4ge program is fully functional.  It can do Queries, Adds,
Updates, Removes, Lookups, and a whole bunch of other stuff.  The program
relies on the constraints attached to the equipment table for data validation.
The only data validation the program does itself is for recursive loops.
(Someone want to help me write a trigger :-)

The o_equip.4ge program is a simple report program.  Provide an id along with
the direction you want to go and it dumps the explosion (or implosion?) to a
file called "report.out".

I've documented the ESQL/C recursion routines somewhat.  It may look messy
but there's nothing really complicated going on (remember I'm NOT a regular C
programmer).  I've documented the recursive loop routine extensively.  If it
sounds complicated, that's because it is!

If you have any questions, send me email.  If you have some suggestions,
please let me know about them.  Enjoy!
Source: README, updated 2020-05-11