TEXIS PROGRAMS

• TEXIS CORE PROGRAMS
  • Required Programs
    • monitor - Texis monitoring program
    • Texis Configuration file
      • Monitor texis.cnf Section
      • Chkind texis.cnf Section
      • Scheduler texis.cnf Section
      • Texis texis.cnf Section
      • Anytotx texis.cnf Section
      • Httpd texis.cnf Section
      • Httpd Fast CGI texis.cnf Section
    • texisd - The Texis Server Daemon
    • creatdb - Creating a new database
    • tsql - Texis Interactive SQL
    • texis - Texis Web Script (Vortex)
    • anytotx - Translate file formats to text
      • Formats Rule File
  • Maintenance Programs
    • chkind - Index Maintenance Daemon
    • ltest, dumplock - Lock Status Display
    • lockandrun - Lock Database and Run Command
    • rmlocks, wsem, monlock - Removing Stale Locks
    • kdbfchk - Check and repair a database file
    • cpdb - Copy a database across the network
    • copydb - Copy a database across the network
    • copydbf - Copy a database file
    • addtable - Add existing table to database
    • wordlist - Display words and frequencies from index
    • timport - General purpose Texis importer
  • Unsupported Goodies
    • txtoc, txtocf
    • xtree - sort / uniq tool
    • tac - reverse file cat
    • vhttpd - Texis Web Script web server
    • Perl DBI Driver
  • Third-Party Software
    • Antiword
    • Aspell
    • Catdoc xls2csv
    • Cole library
    • iconv
    • ppt2html, msg2html
    • SSL/HTTPS plugin
    • unrar
    • unzip
    • zlib
    • SpiderMonkey (JavaScript-C) Engine
    • PDF/anytotx plugin
    • thttpd - throttling HTTP server
    • prngd
    • GNU General Public License
    • GNU Lesser General Public License
    • GNU Library General Public License
    • Netscape Public License
• TIMPORT: TEXIS GENERAL PURPOSE DATA IMPORT TOOL
  • Overview
    • timport - General purpose Texis importer
  • Explanation
  • Requirements
  • Installation
  • Designing a Schema File
  • Preparing a Database and Table
  • Loading a Table with TIMPORT
  • Multiple Records Per File
  • Field Definitions
  • Loading Multiple Tables Per File
  • Handling Columnar Records
  • Handling Columnar Records (Another way)
  • Date Formats
  • Try It On Your Mailbox
  • Importing Comma Separated Values
  • XML Namespaces
  • Keyword Review
  • Example schemas
    • Example Schema: Comma Separated Values (csv)
    • Example Schema: Fixed Width Columnar Records
    • Example Schema: Fixed Width Columnar Records (Patent)
    • Example Schema: Columnar Records, Incrementing Numbers, Field Lengths
    • Example Schema: Variable Width Columns (Web Server Log)
    • Example Schema: Variable Width Columns (Combined Web Server Log)
    • Example Schema: Tagged Format Data (Mailbox)
    • Example Schema: Multiple Output Tables
    • Example Schema: Load Individual Fields From Named External Files
    • Example Schema: External Text Files (3DB)
    • Example Schema: dBase/FoxPro
    • Example Schema: Oracle EXPORT (oracle)
    • Example Schema: XML
    • Example Schema: XML with xmldatasetlevel
    • Example Schema: XML with namespaces
• THE TEXIS NETWORK CLIENT API
  • Overview
    • Texis Client Functions
  • Network API common functions
    • openserver() , closeserver() , serveruser() , servergroup() , serverpass() - Connect and disconnect from service
    • Metamorph control parameters
  • SQL Interface Version 2
    • Building Unix client applications with the Texis SQL API
    • n_opentsql(), n_closetsql() - Texis SQL API initialization and cleanup
    • n_settsql(), n_exectsql() - Prepare a SQL statement for processing
    • n_gettsql() - Get resultant rows from a SQL statement
    • n_dotsql() - Prepare and execute a SQL statement
    • n_resulttsql() - Control the behavior of SQL INSERT, DELETE
    • Formatting Codes for n_settsql() and n_gettsql()
  • Texis specific functions
    • n_regtexiscb() - Register hit callback function
    • n_getsrchlst(), n_freesrchlst(), n_srchinfo(), n_freesrchinfo(), n_fillsrchlst() - Hit information
    • n_xpminfo(), n_freexpmi() - Hit information
    • n_getindexcount() - Hit information
    • n_newindirect() - Object manipulation
    • n_rcopyto(), n_rcopyfrom() - File transfer
    • n_setXXX(), n_getXXX() - Texis control parameters
    • n_texis() - SQL interface
    • n_opentx(), n_duptx(), n_closetx() - SQL interface
    • n_settx(), n_runtx() - SQL interface
    • n_preptx(), n_exectx() - SQL interface
    • n_gettx() - SQL interface
    • n_settexisparam(), n_paramtx(), n_resetparamtx() - SQL interface
    • n_flushtx() - SQL interface
    • n_flushtx2() - SQL interface
    • n_offstx(),freemmoffs() - SQL interface
  • Modifying the server
    • adduserfuncs - Adding to the server
    • dbaddtype - Add a datatype
    • foaddfuncs - Add functions
    • fosetop - Add an operator
• TRIGGERS
  • Overview
  • Syntax
  • The External Command
  • Why would I use triggers?
  • What does my program need to do?
    • opentbl() - Open a TBL.
    • closetbl() - Close a TBL structure.
    • rewindtbl() - Rewind a table.
    • gettblrow() - Reads the next row in from a table.
    • getfld() - get a value from a field
    • nametofld() - Get a field from a TBL.
  • Notes
    • INSERT
    • UPDATE
    • DELETE
• TEXIS API EXAMPLE PROGRAMS
  • Example Programs
    • loader - Example Loader Program
    • netex3 - Example Lookup Program
• TEXIS DIRECT API
  • Overview
    • Data Dictionary functions
    • Table functions
    • Row and Field functions
  • Data Dictionary Functions
    • ddopen() - Open a data dictionary.
    • ddclose() - Close a data dictionary.
    • createdb() - Creates an empty database.
    • permstexis() - Set the security to Texis security.
  • Table level functions
    • opendbtbl() - Open a DBTBL.
    • closedbtbl() - Close a DBTBL structure.
    • createdbtbl() - Create a table, and add it to the data dictionary.
    • createindex - create an index
    • opendd() - create a new dd
    • closedd() - free a dd
    • rewinddbtbl() - Rewind a table.
  • Row and field level functions
    • getdbtblrow() - Reads the next row in from a table.
    • putdbtblrow() - Writes the current row in the table.
    • recidvalid() - determine if a RECID pointer is valid
    • getfld() - get a value from a field
    • putfld() - put a value into a field.
    • putdd() - adds a new field to an existing DD.
    • dbnametofld() - Get a field from a DBTBL.
    • getcounter() - Get a valid counter value
• The CGI API
  • Overview
  • CGI API functions
    • opencgi(), closecgi() - CGI initialization and cleanup
    • getcgi() - get CGI variable
    • cgivar() - enumerate CGI variables
    • cgistarthdrs(), cgiendhdrs() - start/end HTTP headers
    • putcgi() - set state variable
    • cgiwritestate() - save state variables to cookie or file
    • cgiputcookie() - print arbitrary cookie header
    • htpf() - printf with HTML extensions
      • Metamorph Hit Markup
    • htpf_setapicp() - set default APICP for htpf()
  • Miscellaneous CGI functions
    • cgigetstate() - get state variable cookie
    • cgireadstate() - read state variables
    • cgiprocenv() - parse environment variables
  • User-defined variable lists
    • opencgisl(), closecgisl() - create/delete user-defined variable list
    • cgisladdvar() - add user-defined variable to list
    • cgisladdstr() - add user-defined variables from URL string
    • getcgisl() - get variable from user-defined list
    • cgislvar() - enumerate user-defined variable list
    • cgislsetcmp() - set user-defined variable comparison function