DB4GLGEN-3.7 and other things

Do you believe it? The one month that my monthly posting doesn't go out because of a typo on my part... I get a zillion letters asking me where to get db4glgen and/or what is it. So here goes the monthly posting done manually. BTW, soon to come... dblookup - A sharp little utility that produces field validation and field lookup code (ala pop-up windows) dbform - A lame (but very useful) utility that creates temporary, generic data entry forms for quick access to a table These two utilities are waiting for man pages and then they'll be available. If you feel bold and want to try them without a man page, let me know. Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip Last-Modified: June 20 1992 This is a monthly posting from Dave Snyder, keeper of db4glgen. Although this is probably old information for alot of you, I find that about once a month or so, I'm asked, "What is db4glgen?"... "Where can I get dbinfo?" Well here are descriptions of all the Informix tools that I've written and how to get them. Please send all questions and comments about this posting or my Informix tools to dave@snide.com (das13!dave). db4glgen This program is the PD Informix 4GL code generator hacked together by Dave Snyder. dbbeauty This program will capitalize all Informix key words in an Informix-4GL program. Comments and keywords inside double quotes will not be changed. dberror This program prints the error message for an Informix-SQL error code. It also handles ALL-II and SystemV error codes. dbinfo This program provides information about an Informix-SQL table. It formats it's output like the SQL command "info". dblist This program dumps the contents of an Informix-SQL table to stdout. It has the ability to select an index to sort by and also provides the ability to start at a specific place in the file. dbloader & dbunloader This program generates SQL statements to load "unloaded" Informix-SQL tables into a database. When compiled, dbloader should be linked to dbunloader. The dbunloader program generates SQL statements to unload Informix-SQL tables. dbports.sh This archive contains two shell scripts... dbexport and dbimport. If you have Informix 4.00 products then you don't need these scripts. DBEXPORT will create a database schema, unload all tables in your database, and create a script to re-load the unloaded tables. DBIMPORT will create a database with tables from the schema and load all the tables. These scripts require dbschema (from Informix) and dbloader/dbunloader (from archive-server). dbrepair This program will update the "dirpath" column of the Informix-SQL table "systables" from an absolute path name to a relative one. This can only be used if your database engine is Informix-SE. dbreserved This program will scan an Informix-SQL table and print all reserved words to stdout. There are currently 400+ words that are checked. The above programs are available from the machines "das13" and "mathcs". You can reach "das13" through the archive-server or ANONUUCP (ANONFTP is available through "mathcs.emory.edu"), the info you need follows... ANONFTP: If you've never used anonymous ftp, here is a quick primer, in the form of a sample session, with comments in {}. Lines with a "<<<" at the end are where you type something. % ftp mathcs.emory.edu {IP Address = 128.140.2.1} <<< Connected to mathcs.emory.edu. 220 emory FTP server (SunOS 4.1) ready. Name (mathcs.emory.edu:dave): anonymous <<< 331 Guest login ok, send ident as password. Password: dave@snide.com {use your name and host here} <<< 230 Guest login ok, access restrictions apply. ftp> cd pub/informix <<< 250 CWD command successful. ftp> get ls-lR <<< 200 PORT command successful. 226 ASCII Transfer complete. ftp> cd das13 <<< 250 CWD command successful. ftp> get Index <<< 200 PORT command successful. 226 ASCII Transfer complete. . . {repeat this step for each file you want} . ftp> quit <<< 221 Goodbye. % ANONUUCP: Create one or more of the following entries in your Systems (or L.sys) file: das13 Any;1 FAST 9600 1-2154614007 "" \\r\\c in:-\\r-in: anonuucp das13 Any;1 ACU 2400 1-2154614007 "" \\r\\d\\r\\c in:-\\r-in: anonuucp das13 Any;1 ACU 1200 1-2154614007 "" \\r\\d\\r\\d\\r\\c in:-\\r-in: anonuucp This is a call to Philadelphia, PA USA If you've never used anonymous uucp, try this for your first command... uucp das13!~/ls-lR /usr/spool/uucppublic ARCHIVE-SERVER: To access the archive-server, send mail to: archive-server@das13.snide.com In the Subject: put the word "help" (w/o the quotes). Leave the rest of your mail blank since it'll be ignored anyway. You will receive mail back explaining in detail what the archive-server is and how to use it. Here --------- Snip Here --------- Snip Here --------- Snip Here --------- Snip DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.7 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com