Toggle navigation
+1 216-820-2200
+1 216-820-2200
Toggle navigation
Products
Solutions
How to Buy
Support
Contact Us
News
About
Texis Programs
Texis Core Programs
Required Programs
monitor
- Texis monitoring program
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
Supported File Formats
Formats Rule File
Maintenance Programs
chkind
- Index Maintenance Daemon
dumplock
,
ltest
- 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 / unique tool
tac
- reverse file cat
vhttpd
- Texis Web Script web server
Texis Servlet
Java JDBC Driver
Perl DBI Driver
Configuration and Reference
Texis Configuration file
Monitor
conf/texis.ini
Section
Chkind
conf/texis.ini
Section
Scheduler
conf/texis.ini
Section
License Update
conf/texis.ini
Section
Texis
conf/texis.ini
Section
Apicp
conf/texis.ini
Section
Anytotx
conf/texis.ini
Section
Httpd
conf/texis.ini
Section
Proxy Module
conf/texis.ini
Section
Auth Proxy
conf/texis.ini
Section
Httpd Fast CGI
conf/texis.ini
Section
Exit Codes
Version Differences
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
Copyright © Thunderstone Software
Last updated: Apr 15 2024
Texis Manual
Top
Up: List of Tables
Next: Texis Core Programs
Back: freelst() freelstlst() - Support
PDF
Contact
Submit Request
Copyright © 2024 Thunderstone Software LLC. All rights reserved.