Monthly Posting from Snide Computer Services 
Author Message
 Monthly Posting from Snide Computer Services

Last-Modified: Thu Nov 18 10:33:13 EST 1993

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

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.

dbform

This package generates "quick & dirty" data forms.  It requires that
Informix-SQL be installed on your machine.

dbinfo

This program provides information about an Informix-SQL table.  It formats its
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.

dblookup

This package generates 4GL code and 4GL forms for pop-up style lookup
windows.

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.

dbsyntax

This program checks the syntax of SQL statements without actually executing
them.  If a file is not specified on the command line, stdin is used instead.

vie

Vie will allow you to view and correct an Informix-4GL source/form error
file using "vi".

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.

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:

  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.

DAS
--

                                                              is db4glgen-3.17



Mon, 10 Jun 1996 11:22:02 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Monthly Posting from Snide Computer Services

2. Monthly Posting from Snide Computer Services

3. Monthly Posting from Snide Computer Services

4. Monthly Posting from Snide Computer Services

5. Monthly Posting from Snide Computer Services

6. Monthly Posting from Snide Computer Services

7. Monthly Posting from Snide Computer Services

8. Monthly Posting from Snide Computer Services

9. Monthly Posting from Snide Computer Services

10. Monthly Posting from Snide Computer Services

11. Monthly Posting from Snide Computer Services

12. Monthly Posting from Snide Computer Services


 
Powered by phpBB® Forum Software