You are here:
Contents
Contents
Getting Started
Obtain a copy of Scimore
Install the ScimoreDB
Instructions on how to install servers
Running Programs as Administrator
Scimore Windows Service
How to cluster servers together
Using embedded database
Redistributables
Uninstalling ScimoreDB
Uninstall server instances
Scimore Requirements
Administration Guide
Database Settings
Import and Export Data
Backup and Restore Databases
Table Statistics
Architecture
ScimoreDB Architecture Overview
DQL - Distributed Query Language
File Locations
Network Communications
The Partition Column
The Identity Column
Transaction Support
System database
syscatalogs
systables
syscolumns
sysindexes
sysprocedures
sysinstances
sysconfig
msessions
mprocesses
mnetwork
mtables
mprocedures
mtransactionlog
mtransactions
mlocks
mpagecache
Full-Text Indexing
Lucene integration overview
Create full-text index
Linking full-text index with a DB table
Unlinking full-text index
Removing full-text index
Alter full-text index
Truncate full-text index
Full-text index rebuild
Full-text search
Get matched document’s content
Scale-out Lucene full-text
Example full-Text Indexing
SQL Reference
Scimore SQL Data Types
SQL Comments
Data Definition
CREATE DATABASE
DROP DATABASE
ALTER CLUSTER
CREATE TABLE
DROP TABLE
ALTER TABLE
CREATE PROCEDURE
DROP PROCEDURE
Data Manipulation
SELECT
Table Sources
Search Clauses
INSERT
UPDATE
DELETE
TRUNCATE
USE
BACKUP
RESTORE
REBUILD
EXECUTE
GENERATE STATISTICS
USER PROCEDURES
Transaction Statements
BEGIN TRANSACTION
COMMIT
ROLLBACK
GO
SET FLUSH LOG
Control Flow Operators
CASE
IF...ELSE
WHILE
RAISE EXCEPTION
SQL Functions and Operators
Grouping Functions
COUNT
SUM
AVG
MIN
MAX
Date Functions
GETDATE
DATEADD
DATEDIFF
DATEPART
String Functions
CONCAT
REPLACE
LEN
SUBSTRING
RTRIM
LTRIM
RPAD
LPAD
MD5
PATINDEX
Mathematical Functions and Operators
Arithmetic Operators
Mathematical Functions
ABS
CEIL
EXP
FLOOR
LOG
LOG10
MOD
POW
ROUND
SQRT
Trigonometric Functions
ACOS
ASIN
ATAN
ATAN2
COS
SIN
TAN
Scope Functions
AUTOIDENTITY
LAST_ROW
SCOPE_IDENTITY
@@ROWCOUNT
Other Functions
Comparative Operators
CONVERT
RAND
BITAND
BITOR
Troubleshooting
Symbol Reference
Types
UDI_ENTRY Type
Interfacing
C++ Client Interface
Setting up with Visual Studio
Examples C++ Client Interface
Simple Query
Simple Asynchronous
Simple RecordSet
Transaction
Prepared SQL statement
Procedure
User Defined Procedure
scdriver Namespace
Classes
CBulkExportFile Class
CBulkExportFile Members
~CBulkExportFile Destructor
CBulkExportFile Constructor
CBulkExportFile Methods
Export Method
get_class_size Method
OnSave Method
CBulkImportFile Class
CBulkImportFile Members
~CBulkImportFile Destructor
CBulkImportFile Constructor
CBulkImportFile Methods
get_class_size Method
Import Method
OnRead Method
CCommand Class
CCommand Members
~CCommand Destructor
CCommand Constructor
CCommand Methods
AddParameter Method
AddParameter Method (const char *, const DBPARAMETER_DIRECTION, const DATA_TYPE)
AddParameter Method (const char *, const DBPARAMETER_DIRECTION, const DATA_TYPE, void *, const int)
Execute Method
GetParameter Method
Open Method
PrepareProcedure Method
PrepareText Method
CConnection Class
CConnection Members
~CConnection Destructor
CConnection Constructor
CConnection Data Members
m_irecv Data Member
CConnection Methods
AbortTransaction Method
BeginTransaction Method
Cancel Method
Close Method
CommitTransaction Method
Connect Method
Connect Method (const char *)
Connect Method (const char *, const int, const long)
Execute Method
FireEvent Method
get_class_size Method
get_driver Method
get_return Method
GetCompletionStatus Method
ResetConnectionStateCallback Method
SetConnectionStateCallback Method
SetLanguage Method
SetTimeout Method
ShowDQL Method
CConnection Friends
class c_connector Friend
class CBulkExport Friend
class CBulkImport Friend
class CCommand Friend
class CFieldStream Friend
class CRecordset Friend
CEmbeddedDB Class
CEmbeddedDB Members
CEmbeddedDB Constructor
CEmbeddedDB Methods
Close Method
Connect Method
Create Method
get_class_size Method
OpenInProcess Method
OpenShared Method
Shutdown Method
CFieldStream Class
CFieldStream Members
~CFieldStream Destructor
CFieldStream Constructor
CFieldStream Methods
GetFieldSize Method
IsNull Method
IsNull Method ()
IsNull Method ()
ReadField Method
SetField Method
CFieldStream Friends
class CRecordset Friend
CRecordset Class
CRecordset Members
~CRecordset Destructor
CRecordset Constructor
CRecordset Methods
alloc_fields Method
Free Method
get_class_size Method
GetFieldCount Method
GetFieldCount Method ()
GetFieldCount Method ()
GetFieldInfo Method
GetFieldInfo Method (const char *)
GetFieldInfo Method (const int)
GetFieldInfoByIndex Method
GetFieldInfoByName Method
GetFieldStreamByIndex Method
GetFieldStreamByName Method
GetSchemaInfo Method
IsEOF Method
Next Method
Open Method
Open Method (CConnection *, const char *)
Open Method (CServerConnection *, const char *)
read_schema Method
CRecordset Friends
class CCommand Friend
FIELD_INFO Structure
FIELD_INFO Members
FIELD_INFO Data Members
data Data Member
id Data Member
name Data Member
table_id Data Member
type Data Member
vtype Data Member
FIELD_INFO Operators
() Operator
Structs, Records, Enums
CONNECTION_EVENT Enumeration
CONNECTION_LANG Enumeration
DATA_TYPE Enumeration
DBPARAMETER_DIRECTION Enumeration
TRAN_ISOLATION_LEVEL Enumeration
.NET provider
Connection String
Scimore::Data::ScimoreClient Namespace
Classes
ScimoreCommand Class
ScimoreCommand Members
~ScimoreCommand Destructor
ScimoreCommand Constructor
ScimoreCommand Constructor ()
ScimoreCommand Data Members
WM_ASYNC_EXECUTE_DONE Data Member
WM_ASYNC_EXECUTE_ERROR Data Member
ScimoreCommand Methods
Cancel Method
CreateDbParameter Method
CreateParameter Method
DefaultCommandType Method
DefaultUpdatedRowSource Method
ExecuteAsynchronous Method
ExecuteDbDataReader Method
ExecuteNonQuery Method
ExecuteReader Method
ExecuteReader Method ()
ExecuteReader Method (CommandBehavior)
ExecuteScalar Method
Prepare Method
ResetParameters Method
SetBuilder Method
UpdateRow Method
ScimoreCommand Properties
ActiveReader Property
AsyncErrorMessage Property
CommandText Property
CommandTimeout Property
CommandType Property
Connection Property
DbConnection Property
DbParameterCollection Property
DbTransaction Property
DesignTimeVisible Property
Parameters Property
Transaction Property
UpdatedRowSource Property
ScimoreCommand Delegates
QueryDoneDelegate Delegate
ScimoreConnection Class
ScimoreConnection Members
~ScimoreConnection Destructor
ScimoreConnection Constructor
ScimoreConnection Constructor ()
ScimoreConnection Constructor (String^)
ScimoreConnection Classes
InvalidConnectionString Class
ScimoreConnection Data Members
sdkConnection Data Member
ScimoreConnection Methods
AutoInstance Method
BeginDbTransaction Method
BeginTransaction Method
BeginTransaction Method ()
BeginTransaction Method (IsolationLevel)
ChangeDatabase Method
ChangeState Method
Close Method
CreateCommand Method
CreateDbCommand Method
DefaultIsolationLevel Method
DefaultLanguage Method
DefaultPort Method
ExportData Method
GetExecutionPlan Method
GetSchema Method
GetSchema Method ()
GetSchema Method (String^)
GetSchema Method (String^, array<String^>^)
ImportData Method
Open Method
ScimoreConnection Properties
ConnectionString Property
ConnectionTimeout Property
Database Property
DataSource Property
Host Property
Instance Property
Language Property
Port Property
ServerVersion Property
State Property
ScimoreDataAdapter Class
ScimoreDataAdapter Members
~ScimoreDataAdapter Destructor
ScimoreDataAdapter Constructor
ScimoreDataAdapter Constructor ()
ScimoreDataAdapter Methods
CreateRowUpdatedEvent Method
CreateRowUpdatingEvent Method
Fill Method
Fill Method (DataSet^)
Fill Method (DataSet^, String^)
Fill Method (DataSet^, int, int, String^)
Fill Method (DataTable^)
Fill Method (DataTable^, IDataReader^)
OnRowUpdated Method
OnRowUpdating Method
Update Method
ScimoreDataAdapter Properties
SelectCommand Property
ScimoreDataReader Class
ScimoreDataReader Members
~ScimoreDataReader Destructor
ScimoreDataReader Constructor
ScimoreDataReader Methods
Close Method
GetBoolean Method
GetByte Method
GetBytes Method
GetChar Method
GetChars Method
GetData Method
GetDataTypeName Method
GetDateTime Method
GetDecimal Method
GetDouble Method
GetEnumerator Method
GetFieldSize Method
GetFieldType Method
GetFloat Method
GetGuid Method
GetInt16 Method
GetInt32 Method
GetInt64 Method
GetName Method
GetOrdinal Method
GetSchemaTable Method
GetString Method
GetValue Method
GetValues Method
IsDBNull Method
NextResult Method
Read Method
ReadFields Method
ScimoreDataReader Properties
AllowAdd Property
AllowDelete Property
AllowEdit Property
Depth Property
FieldCount Property
Fields Property
HasRows Property
IsClosed Property
Item Property
RecordsAffected Property
VisibleFieldCount Property
ScimoreDbField Class
ScimoreDbField Members
ScimoreDbField Constructor
ScimoreDbField Methods
SystemTypeFromScimoreDataType Method
ScimoreDbField Properties
BaseName Property
DataTypeName Property
FieldName Property
FieldScimoreType Property
FieldSize Property
FieldType Property
IsDefault Property
IsNull Property
IsNullable Property
IsPartitionField Property
IsPrimaryKey Property
Ordinal Property
TableOrdinal Property
Value Property
Visible Property
ScimoreEmbedded Class
ScimoreEmbedded Members
~ScimoreEmbedded Destructor
ScimoreEmbedded Constructor
ScimoreEmbedded Methods
Close Method
Create Method
CreateConnection Method
Open Method
Shutdown Method
ScimoreEmbedded Properties
MaxConnections Property
MaxLocks Property
MemoryPages Property
ScimoreParameter Class
ScimoreParameter Members
ScimoreParameter Constructor
ScimoreParameter Constructor ()
ScimoreParameter Properties
_Direction Property
DbType Property
Direction Property
IsNullable Property
ParameterName Property
