  FairCom ISQL - Developers Guide
  Quick Tour
Introductory Tutorial
Init
Define
Manage
Done
Additional Resources
Relationships
Init
Define
Manage
Done
Additional Resources
Record/Row Locking
Init
Define
Manage
Done
Additional Resources
Transaction Processing
Init
Define
Manage
Done
Additional Resources
ISQL Statements
Starting Interactive SQL
Statement History Support
Formatting Output of ISQL Queries
Formatting Column Display with the COLUMN Statement
Summarizing Data with DISPLAY, COMPUTE, and BREAK Statements
Adding Beginning and Concluding Titles with the TITLE Statement
The HELP and TABLE Statements
Transaction Support
Work Flow Control
ISQL Reference
@ (Execute)
BREAK
CLEAR
COLUMN
COMPUTE
DEFINE
DISPLAY
EDIT
EXIT or QUIT
GET
HELP
HISTORY
HOST or SH or !
IF [ NOT ] EXISTS
INDEXES
LIST
QUIT or EXIT
RUN
SAVE
SET
SHOW
SPOOL
START
TABLE
TITLE
FairCom DB SQL Built-in Stored Procedures
fc_add_db( )
fc_check_file_tran_state( )
fc_create_db( )
fc_create_user( )
fc_get_cachestats()
fc_get_connstats()
fc_get_dblist( )
fc_get_fcproclist( )
fc_get_filestats()
fc_get_hosttablename()
fc_get_iostats()
fc_get_isamstats()
fc_get_lockstats()
fc_get_memstats()
fc_get_min_card( )
fc_get_priority( )
fc_get_partbounds()
fc_get_replstats()
fc_get_selectivity( )
fc_get_server_version( )
fc_get_sqlstats()
fc_get_sysconfig()
fc_get_taskid( )
fc_get_transtats()
fc_get_userlist( )
fc_ptadmin_num()
fc_purge_db()
fc_set_blockinglock( )
fc_set_debug( )
fc_set_file_tran_state( )
fc_set_impersonation( )
fc_set_min_card( )
fc_set_nodename( )
fc_set_priority( )
fc_set_rowid_visible()
fc_set_selectivity( )
fc_set_sysconfig()
SQL Data Load Utility: dbload
Prerequisites for dbload
dbload Command-Line Syntax
Data File Formats
The Commands File
The DEFINE RECORD Statement
The FOR EACH Statement
Examples
dbload Errors
Compilation Errors
Fatal Errors
Data Unload Utility: dbdump
dbdump Command-Line Syntax
Data File Formats
The Commands File
The DEFINE RECORD Statement
The FOR RECORD Statement
Examples
Schema Export Utility: dbschema
Examples
FairCom Typographical Conventions
Copyright Notice
Index
|