HOME   UP  

picture

CERA Software: Table Tools

This Site contains tools (SQL and AIX/ksh scripts) to maintain and handle the recursive hierarchical CERA Tables LOCATION and TOPIC.

For both Tables you find:
*_sheet: an SQL script generating a view on the hierarchical recursive table that gives for every ENTRY its related TOPICs/LOCATIONs with the _id and the path (=all _acronyms/_names on higher levels in the same table) leading to it.
make*list.sql: an SQL script generating the ASCII file *1.lst
make*list: an AIX/ksh script converting a *1.lst file to the ASCII file *3.lst, which gives an overview on the table *.
Jun 21 1999 : GENlocation_sheet.sql ( 8572 Bytes )

Nov 01 1999 : GENtopic_sheet.sql ( 7715 Bytes )

Apr 27 1999 : makeLOCATIONlist ( 4083 Bytes )

Apr 27 1999 : makeLOCATIONlist.sql ( 1395 Bytes )

Apr 27 1999 : makeTOPIClist ( 3485 Bytes )

Apr 27 1999 : makeTOPIClist.sql ( 1026 Bytes )

Pages are optimized for NETSCAPE. For comments and suggestions contact CERA Admin.

Last change: Mon Jul 23 15:39:06 NFT 2001