SAND CDBMS Documentation Library
Index

Tip:
Use your browser's Find command to search for the term you want.

Special Characters - A - B - C - D - E - F- G - H - I - J - K - L - M - N - O - P - Q - R- S - T - U - V - W - Y


Special Characters

% (modulus) operator (NDL++)
* (multiplication) operator (NDL++)
* (multiplication) operator (SQL)
+ (addition) operator (NDL++)
+ (addition) operator (SQL)
– (subtraction) operator (NDL++)
– (subtraction) operator (SQL)
/ (division) operator (NDL++)
/ (division) operator (SQL)
|| (concatenation) operator (SQL)

.DATA (nisqlm system command)
.EXIT
(nisqlm system command)

.EXPORT (nisqlm system command)
.HELP (nisqlm system command)
.HEX (nisqlm system command)
.INDEX (nisqlm system command)
.INTERVAL (nisqlm system command)

.MAXLENGTH (nisqlm system command)
.MAXROWS (nisqlm system command)
.MEASURE (nisqlm system command)
.NULLS (nisqlm system command)
.OUTPUT (nisqlm system command)
.PROMPT (nisqlm system command)
.QUIET (nisqlm system command)
.RUN (nisqlm system command)
.SESS (nisqlm system command)
.SQL (nisqlm system command)
.STARTROW (nisqml system command)

.STATS (nisqml system command)
.SYSTEM (nisqlm system command)
.TIME (nisqlm system command)
.TITLES (nisqlm system command)
.WARNINGS (nisqlm system command)

-? (nisqlm option flag)
-? (nserv option flag)
-b (ndlm option flag)
-c (ndlm option flag)
-c (nmerge option flag)
-c (octorefresh option flag)
-d (ndlm option flag)
-d (nisqlm option flag)
-d (nmerge option flag)
-e (ndlm option flag)
-e (nisqlm option flag)
-e (nmerge option flag)
-e (octorefresh option flag)
-f (ndlm option flag)
-f (nisqlm option flag)
-g (ndlm option flag)
-g (nmerge option flag)
-h (ndlm option flag)
-h (nisqlm option flag)
-h (nmerge option flag)
-h (nserv option flag)
-i (ndlm option flag)
-j (ndlm option flag)
-k (ndlm option flag)
-l (ndlm option flag)
-l (nisqlm option flag)
-l (nmerge option flag)
-m (ndlm option flag)
-m (nmerge option flag)
-n (ndlm option flag)
-o (ndlm option flag)
-o (nisqlm option flag)
-p (ndlm option flag)
-p (nisqlm option flag)
-p (nmerge option flag)

-q (ndlm option flag)
-q (nisqlm option flag)
-r (nmerge option flag)
-s (ndlm option flag)
-s (nmerge option flag)
-s (nserv option flag)
-s (octorefresh option flag)
-t (ndlm option flag)
-t (nisqlm option flag)
-t (nmerge option flag)
-u (ndlm option flag)
-u (nmerge option flag)
-v (ndlm option flag)
-v (nmerge option flag)
-v (octorefresh option flag)

-w (ndlm option flag)
-w (nisqlm option flag)
-w (nmerge option flag)
-z (ndlm option flag)


A

ABS (NDL++ function)

ABS (SQL function)

ACOS (SQL function)

ACOSD (SQL function)

ACOSH (SQL function)

Add a Database Drive command (nconfig)

ADD COLUMN (SQL ALTER TABLE option)

ADD CONSTRAINT (SQL ALTER TABLE option)

ADD DIMENSION (SQL ALTER TABLE option)

Addition Operator: + (NDL++)

Addition Operator: + (SQL)

Aggregate functions (SQL)

ALL PRIVILEGES (database privilege)

ALTER AUTHORIZATION (SQL command)

ALTER DOMAIN (SQL command)

ALTER SESSION ALTER DIVISION (SQL command)

ALTER SESSION DROP CONTEXT (Octopus command)

ALTER SESSION EXECUTE RENUMBER (SQL command)

ALTER SESSION SET CONTEXT (Octopus command)

ALTER SESSION SET DOMINDEX (SQL command)

ALTER TABLE (SQL command)

APPEND (SQL ALTER TABLE option)

Appending records

APPLY CHANGE (nserv invocation option)

ASC (SQL ORDER BY option)

ASIN (SQL function)

ASIND (SQL function)

ASINH (SQL function)

ATAN (SQL function)

ATAN2 (SQL function)

ATAN2D (SQL function)

ATAND (SQL function)

ATANH (SQL function)

ATN (NDL++ function)

AutoStart (nucleus.ini file - Octopus)

AVG (SQL function)


B

"Bag of Words" search (SQL)

Batch execution (ndlm)

BETWEEN predicate (SQL)

BindToAdaptors (nucleus.ini file - Octopus)
-
Octopus configuration
- Agent configuration

BLOB (data type)

Boolean value expressions

BoundUserExclusiveTimeOut (nucleus.ini file - Octopus)

BoundUserTimeOut (nucleus.ini file - Octopus)

Bulk fetch (nisqlm .EXPORT option)


C

Cache (nucleus.ini file - Database)

Cache (nucleus.ini file - Subclass)

CASE expressions

Cast functions (SQL)

CEILING (SQL function)

CENTMOMn (SQL function)

CHAR/CHARACTER (data type)

CHAR (SQL function)

Check_SCT (nucleus.ini file - DCL)

Classes (nucleus.ini file - Octopus)

CLIENT section (nucleus.ini file)

CMP (NDL++ function)

COALESCE (SQL function)

Columns
- Adding (ALTER TABLE command)
-
Dropping (ALTER TABLE command)
-
Renaming (ALTER TABLE command)

Command line installation on Windows systems

COMMIT [WORK] (SQL command)

Compacted Tables, SAND

Compacting a database

Compress_SCT (nucleus.ini file - DCL)

CONCAT (SQL function)

Concatenation Operator: || (SQL)

Concept text search (SQL)

Configuration, database file structure
with nconfig (command line)

CONNECT (nisqlm SESS mode command)

CONNECT (SAND Enterprise Service script command)

Connecting/logging in to a database
with nisqlm (command line)

CONNECTION section (nucleus.ini file)

Connection (nucleus.ini file - Octopus)

Connection string (ODBC)
-
on a UNIX system
- on a Windows system

Constants, special (SQL)

CONVERTDATE (NDL++ function)

CONVERTTIME (NDL++ function)

CONVERTTS (NDL++ function)

COS (NDL++ function)

COS (SQL function)

COSD (SQL function)

COSH (SQL function)

COUNT (SQL function)

CREATE AUTHORIZATION (SQL command)

CREATE CONNECTION (SQL command)

CREATE DOMAIN (SQL command)

CREATE LOCAL DOMAIN (SQL command)

CREATE LOCAL TABLE (SQL command)

CREATE PARTITION TABLE (SQL command)

CREATE SCHEMA (SQL command)

CREATE SNAPSHOP TABLE (SQL command)

CREATE TABLE (SQL command)

CREATE TABLE...WITH CONNECTION (SQL command)

CREATE VIEW (SQL command)

CStatFile (nucleus.ini file - Octopus)

CSV file format

CSVFORMAT (ndlm keyword)

CUME_DIST (SQL function)

CURRENT DATE (SQL special constant)

CURRENT SERVER (SQL special constant)

CURRENT SQLID (SQL special constant)

CURRENT TIME (SQL special constant)

CURRENT TIMESTAMP (SQL special constant)

Custom library functions (NDL++)


D

Data Definition
- DDL commands:
    --  Domains
    --  Passwords, Changing (see ALTER AUTHORIZATION)
    --  Passwords, Setting (see CREATE AUTHORIZATION)
    --  Schemas
    --  Tables
    --  User Authorizations (see CREATE AUTHORIZATION)
    --  Views (see CREATE VIEW)
- SAND Data Types

Data structure (see Data Definition)

Data type declaration (import specification file)

Data Types
- compatibility of data types
- data types resulting from operations
- characteristics of numeric data types

Database (see also Server)
- Compacting
Configuring File Structure:
- with nconfig
Creating:
- with nconfig
-
with nserv
Starting:
- with nserv

Database federation

DATABASE section (nucleus.ini file)

DatabaseName (nucleus.ini file - Octopus)

DatabasePath (nucleus.ini file - Database)

DatabasePath (nucleus.ini file)
- Node Configuration
- Octopus Configuration

DATE (data type)

DATE (NDL++ function)

DATE (SQL cast function)

DATE (SQL date/time function)

Date/Time arithmetic (SQL)

Date/Time functions (SQL)

DatePic (nucleus.ini file - Client)

DAY (SQL function)

DBA
- Database Administrator
- database privilege

DCL section (nucleus.ini file)

DDL (nucleus.ini file - DCL)

DDLFILE (ndlm option)

DEC / DECIMAL (data type)

DEC / DECIMAL (SQL function)

Default configuration command (nconfig)

Default partition

DELETE
- database privilege
-
SQL command

DeltaPath (nucleus.ini file - Database, Virtual/Persistent Mode)

DeltaPath (nucleus.ini file - Subclass)

DENSE_RANK (SQL function)

DESC (SQL ORDER BY option)

DIGITS (SQL function)

DIMENSION OF (SQL ALTER TABLE option)

DIMENSION OF (SQL CREATE DOMAIN option)

Dimension table

DirectIO (nucleus.ini file - Database)

DISABLE CONSTRAINT (SQL ALTER TABLE option)

DISCONNECT (nisqlm SESS mode command)

DISCONNECT (SAND Enterprise Service script command)

Distributed domain

Division Operator: / (NDL++)

Division Operator: / (SQL)

DOUBLE PRECISION (data type)

DROP (SQL command)

DROP COLUMN (SQL ALTER TABLE option)

DROP CONSTRAINT (SQL ALTER TABLE option)

DROP DIMENSION (SQL ALTER TABLE option)

DURATION (nisqlm SESS mode command)

Dynamic pass-through query


E

ENABLE CONSTRAINT (SQL ALTER TABLE option)

ENF functions (NDL++)
-
ENFTONF
- ISENF
-
NFTOENF
-
STRENF
-
VALENF
-
VALENI

ENFTONF (NDL++ function)

Environment variable (NUCLEUS variable)

ERRINC (ndlm option)

Error messages

Exact Match text search (SQL)

EXECSQL (ndlm command)

EXECUTE (SQL command)

EXIT (SAND Enterprise Service script command)

Exit Codes
-
ndlm
- nisqlm
-
nserv

EXISTS predicate (SQL)

EXP (NDL++ function)

EXP (SQL function)

EXPORT  (ndlm command)

EXTRACT (SQL function)

EXTRACTWORD (NDL++ function)

European Number Format (ENF)


F

FACTORIAL (SQL function)

Federated databases

FETCH FIRST...ONLY (SQL SELECT clause)

FetchTimeout (nucleus.ini file - Octopus)

File configuration command (nconfig)

File types, SAND CDBMS

Filtering text searches on relevance (SQL)

FLOAT
-
data type
-
SQL function

FLOOR (SQL function)

FULL [OUTER] JOIN (SQL clause)

Functions (NDL++)
- Custom functions
- Math functions

- String functions

Functions (SQL)
- Aggregate
- Cast

- Date/Time

- Math
- OLAP
- String

Fuzzy text search (SQL)


G

GCD (SQL function)

GENKEY (NDL++ function)

GENKEY (SQL function)

GENKEYCOL (NDL++ function)

GRANT (SQL command)

GROUP BY (SQL SELECT clause)


H

Hash (MPP partitioning option)

HAVING (SQL SELECT clause)

Head node

HELP (SAND Enterprise Service script command)

Hexadecimal characters (SQL)

Host (nucleus.ini file - Connection)

Host (nucleus.ini file - Node)

HOUR (SQL function)


I

IFNULL (SQL function)

IGNORE (ndlm option)

IMPORT (ndlm command)

Import specification (ndl) file

IN predicate (SQL)

INIT section (ndlm import specification file)

INNER JOIN (SQL clause)

INSERT
- database privilege
SQL command

Installation

Installation, from the Windows command line

INSTR (NDL++ function)

INSTRREV (NDL++ function)

INT / INTEGER (data type)

INT / INTEGER (SQL function)

IntegerDivisionScale (nucleus.ini file - Connection)

IntegerDivisionScale (nucleus.ini file - Octopus)

Interval (SQL)

ISENF (NDL++ function)

ISNULL (NDL++ function)

ISNUMERIC (NDL++ function)


J

Joins (SQL)
- INNER JOIN
-
OUTER JOINS:    
    --  FULL [OUTER] JOIN

    --  LEFT [OUTER] JOIN
    --  RIGHT [OUTER] JOIN
- MATCH JOINS:
    --  LEFT MATCH JOIN
    --  RIGHT MATCH JOIN
- Nested Joins

JoinLimit (nucleus.ini file - Connection)


K

Keywords (SQL)

KILL (SAND Enterprise Service script command)

KURTOSIS (SQL function)


L

Labeled duration (SQL)

LCASE (NDL++ function)

LCASE / LOWER (SQL function)

LCM (SQL function)

LDAP Servers

LDAPBaseDN (nucleus.ini file)
- Database section
- Octopus section

LDAPBindings (nucleus.ini file)
- Database section
- Octopus section

LDAPCNAlias (nucleus.ini file)
- Database section
- Octopus section

LDAPDomain (nucleus.ini file)
- Database section
- Octopus section

LDAPHost (nucleus.ini file)
- Database section
- Octopus section

LDAPMode (nucleus.ini file)
- Database section
- Octopus section

LDAPPath (nucleus.ini file)
- Database section
- Octopus section

LDAPRole (nucleus.ini file)
- Database section
- Octopus section

LDAPServicePassword (nucleus.ini file)
- Database section
- Octopus section

LDAPServiceUser (nucleus.ini file)
- Database section
- Octopus section

LEFT (SQL function)

LEFT MATCH JOIN (SQL clause)

LEFT [OUTER] JOIN (SQL clause)

LEN (NDL++ function)

LEN / LENGTH (SQL function)

Library functions, custom (NDL++)

LIBRARY section (ndlm import specification file)

LICENSE section (nucleus.ini file)

LicenseFileLocation (nucleus.ini file - License)

LicenseFileName (nucleus.ini file - License)

Licensing error messages

LIKE (CREATE TABLE clause) (SQL)

LIKE predicate (SQL)

LIMIT (nisqlm option)

Linked tables

LN (SQL function)

LOAD (ndlm option)

Load (nucleus.ini file - DCL)

Loading Data (see also ndlm)
- with ndlm(command line):
    --  ndl command options
    --  ndl command reference
    --  ndl load specification file
    --  NDL++ load scripting functions
- Virtual Mode

LocalNode (Octopus)

LOG (SQL function)

LOG10 (SQL function)

LogFile (nucleus.ini file - Octopus)
- Agent Configuration

- Octopus Configuration

Logging (Octopus)

LoginClass (nucleus.ini file - Octopus)

Login Class (Octopus)

LOGN (NDL++ function)

LOOKUP (NDL++ function)

LOWER / LCASE (SQL function)

LSDB (SAND Enterprise Service script command)

LSDRV (SAND Enterprise Service script command)

LSINS (SAND Enterprise Service script command)

LSNODE (SAND Enterprise Service script command)

LSSUB (SAND Enterprise Service script command)

LTRIM (SQL function)


M

Massively Parallel Processing (MPP)

MATCH JOINS (SQL)
- LEFT MATCH JOIN
-
RIGHT MATCH JOIN

MATCHES predicate (Text Analytics) (SQL)
- Standard (Exact Match) Search
- Phonic ("Sounds Like") Search
- Fuzzy ("Spelled Like") Search
- Concept (Synonym) Search
- Stem Search
- Numeric Range Search
- Proximity Searches
- Nesting of Text Searches Within Proximity Searches
- Boolean Searches
- "Bag of Words" Search

Math functions (ndlm import specification file)

Math functions (SQL)

MAX (SQL function)

MaxDeltaFileRatio
- nucleus.ini file - Database, Virtual/Persistent Mode
- nucleus.ini file - Subclass

MaxDeltaFileSize
- nucleus.ini file - Database, Virtual/Persistent Mode
- nucleus.ini file - Subclass

MAXERR (ndlm option)

MaxVMem (nucleus.ini file - Database)

MaxVMem (nucleus.ini file - Octopus)

MEANDEV (SQL function)

MEDIAN (SQL function)

MICROSECOND (SQL function)

MIN (SQL function)

MINUTE (SQL function)

MISSINGIF clause (ndlm import specification file)

MKDB (SAND Enterprise Service script command)

MKINS (SAND Enterprise Service script command)

MKNODE (SAND Enterprise Service script command)

MKSUB (SAND Enterprise Service script command)

MPP (Massively Parallel Processing)

MPP mode

MOD (SQL function)

Modulus operator: % (NDL++)

Modify a Database Drive command (nconfig)

MONTH (SQL function)

Multiplication Operator: * (NDL++)

Multiplication Operator: * (SQL)


N

nconfig (see also Configuration)
- Command reference

ndlm (see also Loading Data)
-
Batch execution
-
Command reference
    --  ndlm load specification file
    --  option flags
- CSVFORMAT Script
- Domain indexing
- EXECSQL Script
- EXPORT Script
- IMPORT Script
- NDL++ load scripting functions
- NULLIF and MISSINGIF Clauses
- Parallel Loader
- PIC Clause
- SCTEXPORT Script
- SCTIMPORT Script
- SKIPIF Clause
- Transferring data via named pipes

Nested Joins (SQL)

Nested Table Expressions (SQL)

NFTOENF (NDL++ function)

nisqlm (see also Connecting; Querying)
- Command reference
-
Command modes:
    --  SESS
    --  SQL
- LIMIT option

nmerge (see also Time Travel)

Nodes
- Configuration (Octopus architectural component)
- Head node (MPP)
- Partition node (MPP)

Nodes
(nucleus.ini file - Octopus)

Non-persistent updates (Octopus)

NonPersistentChangeUsers (nucleus.ini file - Octopus)

NonPersistentChangeUsersConfigFile (nucleus.ini file - Octopus)

NPUOnHeaviestClassOnly (nucleus.ini file - Octopus)

NROOT (SQL function)

nserv (see also Server)
- Command reference
- Operating Modes
- Starting
- Stopping

NTILE (SQL function)

nucleus.ini file

NULL (ndlm option)

NULL predicate (SQL)

NULLIF (SQL function)

NULLIF clause (import specification file)

NULLS FIRST (SQL ORDER BY option)

NULLS LAST (SQL ORDER BY option)

NumberOfEngines (nucleus.ini file - Subclass)

NUMERIC (data type)

Numeric range text search (SQL)


O

OctoEng (architectural component)

OctoInfo program

OctoKill program

OCTOPS program

Octopus
(architectural component)
- Basic Configuration
- Multi-Node Configuration
- Optional Parameters
- Required Parameters

Octopus Agent
- Starting manually

Octopus Daemon/Service
- Process Behaviour
    --  Registering Configuration Changes
    --  Startup

    --  Shutdown
- Removing the Octopus Daemon/Service
- Starting the Octopus Daemon/Service
- Stopping the Octopus Daemon/Service

OCTOPUS section (nucleus.ini file)
- Basic Configuration
- Multi-Node Configuration

Octopus System
- Architectural Components
- Classes of Service
- Classes and Subclasses
- Configuration
- Connecting
- Execution Modes
    --  Private Update
    --  Public Update
    --  Read-Only
    --  ODDB
- Installing
- Limits
- Loading Data with ndlm
- Saving Database Changes
- Shutting Down
- Starting

OctoRefresh program
- Reconfiguring Subclasses Dynamically

OctoRollLog program

OctoRunMode (nucleus.ini file - Octopus)

OCTOSHUTDOWN (SAND Enterprise Service script command)

OctoShutdown program

OctoStartup program

ODBC (see also Connecting; Connection string)
- ODBC driver for UNIX clients
-
ODBC driver for Windows clients

ODBCIMPORT (ndlm command)

ODDB (Octopus)

ODDBCache (nucleus.ini file - Octopus)

ODDBDatabases (nucleus.ini file - Octopus)

ODDBDeltaPath (nucleus.ini file - Octopus)

ODDBKeepAlive (nucleus.ini file - Octopus)

ODDBKeepAliveTimeout (nucleus.ini file - Octopus)

ODDBLogLevel (nucleus.ini file - Octopus)

ODDBMaxCache (nucleus.ini file - Octopus)

ODDBMaxCache (nucleus.ini file - Octopus Agent)

ODDBMaxDeltaFileRatio (nucleus.ini file - Octopus)

ODDBMaxDeltaFileSize (nucleus.ini file - Octopus)

ODDBMaxServer (nucleus.ini file - Octopus)

ODDBMaxServer (nucleus.ini file - Octopus Agent)

ODDBMaxVMem (nucleus.ini file - Octopus)

ODDBPreferredNode (nucleus.ini file - Database)

ODDBPriority (nucleus.ini file - Octopus)

ODDBPriorityGroup (nucleus.ini file - Octopus)

ODDBPublic (nucleus.ini file - Octopus)

ODDBPriorityGroup (nucleus.ini file - Octopus)

ODDBShareDB (nucleus.ini file - Octopus)

ODDBSubclass (nucleus.ini file - Octopus)

ODDBWaitForCacheFit (nucleus.ini file - Octopus Agent)

OLAP functions (SQL)

On-Demand Database (Octopus)

ONEOF (SQL function)

Operators, NDL++

Operators, SQL

ORDER BY (SQL SELECT clause)

OUTER JOINS (SQL)
- FULL [OUTER] JOIN
-
LEFT [OUTER] JOIN
-
RIGHT [OUTER] JOIN

OWNER (database privilege)


P

Parallel Loader (ndlm)

Partition node

Partitioned table

Partitioning option (MPP)
- Hash
- Range
- Round Robin

Pass-through query (static)

PassEnv (nucleus.ini file - Octopus)

PERCENT_RANK (SQL function)

Persistent Mode (see Time Travel)

PI (SQL function)

PIC clause (ndlm import specification file)

Pipes, Named (ndlm data source or destination)

Phonic text search (SQL)

Port (nucleus.ini file - Connection)

Port (nucleus.ini parameter)
- Agent Configuration
- Node Configuration
- Octopus Port Usage

POSITION / POSSTR (SQL function)

POW (NDL++ function)

POWER (SQL function)

Primary database file (nconfig)

PrimaryDB (nucleus.ini file - Database, Virtual/Persistent Mode)

PrimaryDB (nucleus.ini file - Octopus)

Private Update (Octopus Execution Mode)

PrivateUpdateExclusiveTimeout (nucleus.ini file - Octopus)

PrivateUpdateTimeout (nucleus.ini file - Octopus)

Privileges (database security)

PROCESS (ndlm option)

Proximity text searches (SQL)

Public Update (Octopus Execution Mode)  


Q

Querying the database
- with nisqlm (command line)

Quit (nconfig command)

QUIT (SAND Enterprise Service script command)


R

Range (MPP partitioning option)

RANK (SQL function)

Read File command (nconfig)

Read-Only (Octopus Execution Mode)

Records
- appending
- renumbering

RECORD section (ndlm import specification file)

Recover (nucleus.ini file - Octopus)

REFRESH (SAND Enterprise Service script command)

REFRESH DIMENSION TABLE (SQL function)

REFRESH SNAPSHOT TABLE (SQL command)

RELEVANCE (SQL function)

RENAME COLUMN (SQL ALTER TABLE option)

RENAME DOMAIN (SQL command)

RENAME TABLE (SQL command)

Renumbering records

RescheduleTimeout (nucleus.ini file - Subclass)

Reserved words

REVOKE (SQL command)

RIGHT (SQL function)

RIGHT MATCH JOIN (SQL clause)

RIGHT [OUTER] JOIN (SQL clause)

RMDB (SAND Enterprise Service script command)

RMINS (SAND Enterprise Service script command)

RMNODE (SAND Enterprise Service script command)

RMSUB (SAND Enterprise Service script command)

ROLLBACK [WORK] (SQL command)

ROLLLOG (SAND Enterprise Service script command)

ROUND (NDL++ function)

ROUND (SQL function)

Round Robin (MPP partitioning option)

ROW_NUMBER (SQL function)

RTRIM (SQL function)

RunMode (nucleus.ini file - Database)


S

SAND CDBMS File Types

SAND Enterprise Service
- SES scripting language

SAVE (SAND Enterprise Service script command)

Scalar subqueries

Schemas (see also Data Definition)

SCT (SAND Compacted Table)

SCTEXPORT (ndlm command)

SCTFILE (ndlm option)

SCTFile (nucleus.ini file - DCL)

SCTIMPORT (ndlm command)

Searched CASE

SECOND (SQL function)

Secondary database file (nconfig)

Secure Sockets Layer (SSL)

SecurityLevel (nucleus.ini file - Octopus)

SELECT
- database privilege
-
SQL command

sescmd (SAND Enterprise Service Scripting client)

sesop (SAND Enterprise Service Scripting client)

SessionAdmin (nucleus.ini file - Octopus)

SET CURRENT
- SET UPDATE clause (Octopus)
- SHUTDOWN clause (SQL)

SET SCHEMA (SQL command)

SET TRANSACTION (SQL command)

SET UPDATE EXCLUSIVE (Octopus command)

SET UPDATE KEEP CHANGE (Octopus command)

SET UPDATE NON-PERSISTENT (Octopus command)

SET UPDATE NORMAL (Octopus command)

SET UPDATE PUBLIC (Octopus command)

SET UPDATE REFRESH USER LIST (Octopus command)

SET UPDATE STATUS (Octopus command)

SET UPDATE UNBIND (Octopus command)

SETINS (SAND Enterprise Service script command)

Server (see also Database)
- nserv command reference
- Shutting down with nserv (command line)

- Starting with nserv (command line)

ShareServer (nucleus.ini file - Octopus)

SHUTDOWN (SAND Enterprise Service script command)

SHUTDOWN (SQL command)

SIGN (NDL++ function)

SIGN (SQL function)

Simple CASE

SIN (NDL++ function)

SIN (SQL function)

SIND (SQL function)

SINH (SQL function)

SKEWNESS (SQL function)

SKIP (ndlm option)

SKIPHEADER (ndlm option)

SKIPIF clause (ndlm import specification file)

Snapshot (nucleus.ini file - Octopus)

Snapshot Administration Utility (nmerge) (see also Time Travel)

Snapshot Tables (SQL)

SnapshotPath (nucleus.ini file - Database, Virtual/Persistent Mode)

Snapshots (see Time Travel)

SOUNDS LIKE predicate (SQL)

SPACE (NDL++ function)

Special constants (SQL)

SPELLED LIKE predicate (SQL)

SQL mode (nisqlm)

SQR (NDL++ function)

SQRT (SQL function)

SSL (nucleus.ini file - Connection)

Standard text search (SQL)

START (SAND Enterprise Service script command)

StartOctoEngTimeOut (nucleus.ini file - Octopus)

StartPort (nucleus.ini file - Octopus)

Starting a Database Instance (nserv command line)

StatInterval (nucleus.ini file - Octopus)

StatFile (nucleus.ini file - Octopus)

Statistics (Octopus)
- Cumulative Statistics
- Detailed Statistics

Statistics Database (Octopus)
- DDL Script
- NDL Scripts

StatType (nucleus.ini file - Octopus)

STDDEV (SQL function)

Stem text search (SQL)

STR (NDL++ function)

STRENF (NDL++ function)

String functions (ndlm import specification file)

String functions (SQL)

Subclasses (Octopus architectural component)
- Basic Configuration
- Dynamic Reconfiguration
- Multi-Node Configuration

Subqueries

SUBSTR / SUBSTRING (SQL function)

Subtraction Operator: – (NDL++)

Subtraction Operator: – (SQL)

SUM (SQL function)

SUMCUBE (SQL function)

SUMQUAD (SQL function)

SUMSQ (SQL function)

SUPPORT Directory
- Setting in the Environment Variable

Synonym text search (SQL)

System limits


T

Table section (ndlm import specification file)

Tables (see also Data Definition)

TAN (NDL++ function)

TAN (SQL function)

TAND (SQL function)

TANH (SQL function)

TEMPCACHE (Parallel Loader parameter)

TEMPDRIVE (Parallel Loader parameter)

Temporary File (nconfig)

Text Analytics (see MATCHES predicate (SQL))

TEMPPAGE (Parallel Loader parameter)

TIME (data type)

TIME (NDL++ function)

TIME (SQL function)

TIMEOUT (SQL SET TRANSACTION clause)

TIMESTAMP
- data type
-
SQL function

TimePic (nucleus.ini file - Client)

Time functions (SQL)

Time Travel (Persistent Mode)
- Enabling Time Travel Operation
-
KEEP CHANGE
-
Merging Database Snapshots
-
nucleus.ini file /NUCLEUS variable entries
-
Snapshots

TmpAutoDel (nucleus.ini file - Octopus)

TODAY (SQL function)

TraceFile (nucleus.ini file - Octopus)  

Transactions

TRIM (SQL function)

TRUNC (NDL++ function)

TUOnHeaviestClassOnly (nucleus.ini file - Octopus)


U

UCASE (NDL++ function)

UCASE / UPPER (SQL function)

UNION (SQL SELECT key word)

Updatable Class (Octopus)

UNSIGNED (data type)

UPDATE
- database privilege
-
SQL command

Update File

UPPER / UCASE (SQL function)

USAGE (database privilege)

USE (nisqlm SESS mode command)

USER (SQL special constant)


V

VALENF (NDL++ function)

VALENI (NDL++ function)

VALF (NDL++ function

VALI (NDL++ function

Variable declaration (ndlm import specification file)

VARIANCE (SQL function)

Virtual Mode
- APPLY
-
Starting an instance in Virtual Mode
-
Enabling Virtual mode
-
KEEP CHANGE
-
Loading data in Virtual Mode
-
nucleus.ini file/NUCLEUS variable entries
-
Overview
-
Performance considerations
-
The Update File

View Configuration command (nconfig)

Views (see also Data Definition)


W

WITH SAMPLE OF (SQL SELECT clause)

Write File command (nconfig)


Y

YEAR (SQL function)