next up previous contents
Up: Ovrimos version 3.0 On-line Previous: 22. Ovrimos Error Messages


Index

_CHAR
_CHAR(integer_expression) | _CHAR(integer_expression) | _CHAR(integer_expression)
_HOUR
_HOUR(time_expression) | _HOUR(time_expression) | _HOUR(time_expression)
_INSERT
_INSERT(string_expression1, start, length, string_expression2) | _INSERT(string_expression1, start, length, string_expression2) | _INSERT(string_expression1, start, length, string_expression2)
_LEFT
_LEFT(string_expression, count) | _LEFT(string_expression, count) | _LEFT(string_expression, count)
_MINUTE
_MINUTE(time_expression) | _MINUTE(time_expression) | _MINUTE(time_expression)
_MONTH
_MONTH(date_expression) | _MONTH(date_expression) | _MONTH(date_expression)
_RIGHT
_RIGHT(string_expression, count) | _RIGHT(string_expression, count) | _RIGHT(string_expression, count)
_SECOND
_SECOND(time_expression) | _SECOND(time_expression) | _SECOND(time_expression)
_SUBSTRING
_SUBSTRING(string_expression, start, length) | _SUBSTRING(string_expression, start, length) | _SUBSTRING(string_expression, start, length)
_YEAR
_YEAR(date_expression) | _YEAR(date_expression) | _YEAR(date_expression)
Abnormal Termination
12.2 Database Recovery | 13.1.2.0.1 Transactions
ABS
ABS(numeric_expression) | ABS(numeric_expression) | ABS(numeric_expression)
Access Mode
5.2.1 SQL transactions
Accessing Database Manager
4.3 Accessing Database Manager
ACOS
ACOS(float_expression) | ACOS(float_expression) | ACOS(float_expression)
Administrator Console
3.2.6 Administrator Console | 7.1 Overview
Administrator Id
17.11.3 Initial Users
Administrator Password
3.2.4 SQL Terminal | 5.2 Operating SQL Terminal | 6.1 Overview | 7.2 Operation | 8.8 Demo bookstore: An | 9.2 Operating SQL Query | 13.4.2 Passwords and Password | 17.11.3 Initial Users
AGI
10.5 Stored Procedures
AGI Directory
4.8 Database Creation | 14.2.2 Database Parameters
AGIDIR, parameter
14.2.2 Database Parameters
Alter Table
Alter Table | Alter Table | Alter Table
Another Gateway Interface
10.5 Stored Procedures
API
1.2 Salient Features | 10.5 Stored Procedures
ASCII
ASCII(string_expression) | ASCII(string_expression) | ASCII(string_expression)
ascii_expression
ascii_expression | ascii_expression | ascii_expression
ASIN
ASIN(float_expression) | ASIN(float_expression) | ASIN(float_expression)
ATAN
ATAN(float_expression) | ATAN(float_expression) | ATAN(float_expression)
ATAN2
ATAN2(float_expression1, float_expression2) | ATAN2(float_expression1, float_expression2) | ATAN2(float_expression1, float_expression2)
Atomicity
13.1.2 Transaction Atomicity
B-trees
4.9.4 Fine Tuning Parameters | 14.2.2 Database Parameters
BACKCOMPAT, parameter
14.2.2 Database Parameters
Backup
12.1 Database Backup
Backup Directory
4.8 Database Creation | 4.8.1 How to create | 12.1 Database Backup | 14.2.2 Database Parameters
BACKUPDIR, parameter
12.2 Database Recovery | 14.2.2 Database Parameters
Backward Compatibility
4.9.1 SQL Server Parameters | 14.2.2 Database Parameters
binary_expression
binary_expression | binary_expression | binary_expression
BLOB Reference Manipulation Functions
17.9.1 BLOB Reference Manipulation
BLOBs
1.2 Salient Features | 17.9 BLOBs and the
BTREENODECACHE, parameter
14.2.2 Database Parameters
BTREENUM, parameter
14.2.2 Database Parameters
Build Client Library
14.1 Files that Ovrimos
Bulk Updates
1.2 Salient Features | 17.12 Bulk Updates
C, C++
3.6.1 C, C++
C, C++ Example
20.2 C and C++
C, C++ Stored Procedures
20.2.1 C, C++ Stored
Cached B-Tree Nodes
4.9.4 Fine Tuning Parameters | 14.2.2 Database Parameters
Cached Tables
4.9.4 Fine Tuning Parameters | 14.2.2 Database Parameters
Call
Call | Call | Call
Candidate keys
13.1.1.0.4 Candidate keys
CASE
CASE | CASE | CASE
CAST
CAST | CAST | CAST
CEILING
CEILING(numeric_expression) | CEILING(numeric_expression) | CEILING(numeric_expression)
Certificate Manager
4.5 Certificate Manager
CGI
8.5.4 CGI 1.2
CGI Environment Variables
8.5.6 CGI 1.2 environment | 8.5.6 CGI 1.2 environment
cgi script directives
9.2 Operating SQL Query
CHAR_LENGTH
CHAR_LENGTH(string_expression) | CHAR_LENGTH(string_expression) | CHAR_LENGTH(string_expression)
CHARACHER_LENGTH
CHARACTER_LENGTH(string_expression) | CHARACTER_LENGTH(string_expression) | CHARACTER_LENGTH(string_expression)
Character Set
4.9.2 HTTP Server Parameters | 14.2.2 Database Parameters
CHARSET
17.10.1 Inserting Unicode data | 17.10.2 Displaying Unicode data | 17.10.2 Displaying Unicode data
CHARSET, parameter
14.2.2 Database Parameters
Check constraints
13.1.1.0.3 Check constraints
Cipher
14.2.2 Database Parameters
Cipher Example
20.1 User-provided ciphers
CIPHER, parameter
14.2.2 Database Parameters
Client Library, build
14.1 Files that Ovrimos
COALESCE
COALESCE(expression1, expression2, ...) | COALESCE(expression1, expression2, ...) | COALESCE(expression1, expression2, ...)
Commit
Commit | Commit | Commit
CONCAT
CONCAT(string_expression, string_expression) | CONCAT(string_expression, string_expression) | CONCAT(string_expression, string_expression)
Configuration data
14.2.1 Global Parameters
Configure Database
4.9 Database Configuration
connection
3. Ovrimos Components
Connections
1.2 Salient Features | 3.7 Database Connections | 7.2.2 Connections
Connectivity
1.2 Salient Features | 10. Connectivity
Console
3.2.6 Administrator Console | 7. Administrator's Console
Conventions
1.1 Documentation Conventions | 15. Ovrimos SQL | 16. Ovrimos SQL | 17. Ovrimos SQL
COS
COS(float_expression) | COS(float_expression) | COS(float_expression)
COT
COT(float_expression) | COT(float_expression) | COT(float_expression)
Create Database
4.8.1 How to create
Create Domain
Create Domain | Create Domain | Create Domain
Create Index
Create Index | Create Index | Create Index
Create Table
Create Table | Create Table | Create Table
Create User
Create User | Create User | Create User
Create View
Create View | Create View | Create View
CRYPTOKEY, parameter
14.2.2 Database Parameters
CURDATE
CURDATE() | CURDATE() | CURDATE()
cursor directive
9.2 Operating SQL Query
Cursor Operations
Cursor Operations | Cursor Operations | Cursor Operations
Cursors
9.5 Cursors and Navigation | Cursor Operations | Cursor Operations | Cursor Operations
Cursors and Navigation
9.5 Cursors and Navigation
CURTIME
CURTIME() | CURTIME() | CURTIME()
CURTIMESTAMP
CURTIMESTAMP() | CURTIMESTAMP() | CURTIMESTAMP()
Data Definition
3.2.4 SQL Terminal | 13.1.2 Transaction Atomicity
Data Definition, Statements
Data Definition Statements | Data Definition Statements | Data Definition Statements
Data Definition, Types
15.1 Supported Data Types | 16.1 Supported Data Types | 17.1 Supported Data Types
Data Definition, Unicode
17.10 Storage and Retrieval
Data Encryption
13.3 Data Encryption
Data Integrity
13.1 Data Integrity
Data Manipulation
3.2.4 SQL Terminal | 13.1.2 Transaction Atomicity
Data Manipulation, Statements
Data Manipulation Statements | Data Manipulation Statements | Data Manipulation Statements
Data Recovery
13.2 Data Recovery
Data Types
15.1 Supported Data Types | 16.1 Supported Data Types | 17.1 Supported Data Types
DATABASE
DATABASE() | DATABASE() | DATABASE()
Database Catalog Objects
6.2 Viewing information on
Database Configuration
4.9 Database Configuration
Database Creation
4.8 Database Creation | 4.8.1 How to create
Database Deletion
4.10 Database Deletion
Database Directory
4.8 Database Creation | 4.8.1 How to create | 14.2.2 Database Parameters
Database Disconnect
5.3 Disconnecting and Reconnecting
Database Home Directory
4.8 Database Creation | 4.8.1 How to create | 14.2.2 Database Parameters
Database Maintenance
12. Database Maintenance
Database Manager
3.2.3 Database Manager | 4. Database Manager
Database Manager Configuration
4.6 Database Manager Configuration
Database Manager Error Log
4.13 Database Manager Error
Database Manager Initial Password
14.2.1 Global Parameters
Database Manager Password
3.2.3 Database Manager | 4.3 Accessing Database Manager | 13.4.1 Login Authentication | 14.2.1 Global Parameters
Database Manager Port
14.2.1 Global Parameters
Database Manager SSL
4.4 Database Manager and
Database Manager, Accessing
4.3 Accessing Database Manager
Database Manager, Start
4.2 Starting and Stopping
Database Manager, Stop
4.2 Starting and Stopping
Database Parameters
14.2.2 Database Parameters
Database Reconnect
5.3 Disconnecting and Reconnecting
Database Start
4.7 Starting up and
Database Stop
4.7 Starting up and
DATE
timestamp_expression | timestamp_expression | timestamp_expression
Date and Time functions
15.6.2 Date and Time | 16.6.2 Date and Time | 17.6.2 Date and Time
date_expression
date_expression | date_expression | date_expression
DAYNAME
DAYNAME(date_expression) | DAYNAME(date_expression) | DAYNAME(date_expression)
DAYOFMONTH
DAYOFMONTH(date_expression) | DAYOFMONTH(date_expression) | DAYOFMONTH(date_expression)
DAYOFWEEK
DAYOFWEEK(date_expression) | DAYOFWEEK(date_expression) | DAYOFWEEK(date_expression)
DAYOFYEAR
DAYOFYEAR(date_expression) | DAYOFYEAR(date_expression) | DAYOFYEAR(date_expression)
DBI
10.3 DBI
DBMANHTTPPORT, parameter
14.2.1 Global Parameters
DBMANPASSWD, parameter
14.2.1 Global Parameters
DBMANTRUSTEDCAS, parameter
14.2.1 Global Parameters
DBMCORE, parameter
14.2.1 Global Parameters
DBMTLSAUTHENTICATION, parameter
14.2.1 Global Parameters
DBMTLSCIPHERSUITES, parameter
14.2.1 Global Parameters
DBMTLSCREDENTIALS, parameter
14.2.1 Global Parameters
deadlock
Serializable prevents Phantom appearance
Deadlock prevention
Serializable prevents Phantom appearance
DEGREES
DEGREES(numeric_expression) | DEGREES(numeric_expression) | DEGREES(numeric_expression)
Delete Database
4.10 Database Deletion
Delete Positioned
Delete Positioned | Delete Positioned | Delete Positioned
Delete Searched
Delete Searched | Delete Searched | Delete Searched
Demonstration Database
14.2.1 Global Parameters | 15.3 Sample Data | 16.3 Sample Data | 17.3 Sample Data
DIR, parameter
14.2.2 Database Parameters
Directive
9.2 Operating SQL Query
Dirty File
12.2 Database Recovery
Dirty Read
13.1.2.0.2 Isolation levels
Disconnect
5.3 Disconnecting and Reconnecting
Domain constraints
13.1.1.0.1 Domain constraints
Drop Domain
Drop Domain | Drop Domain | Drop Domain
Drop Index
Drop Index | Drop Index | Drop Index
Drop Table
Drop Table | Drop Table | Drop Table
Drop User
Drop User | Drop User | Drop User
Drop View
Drop View | Drop View | Drop View
Dynamic External Resources
8.5 Dynamic External Resources
Dynamic Internal Resources
5.2 Operating SQL Terminal | 8.4 Dynamic Internal Resources
ECA
13.5.1 Local Certification Authorities
Encryption
1.2 Salient Features | 13.3 Data Encryption | 14.2.2 Database Parameters
Error Log
7.2.1 Error Log | 12.3 Periodic Maintenance
EXECEXT, parameter
14.2.2 Database Parameters
Executable Extensions
4.9.2 HTTP Server Parameters | 8.5.4 CGI 1.2 | 14.2.2 Database Parameters
EXP
EXP(float_expression) | EXP(float_expression) | EXP(float_expression)
Extract
2.1 Unix Installation | EXTRACT(keyword FROM value) | EXTRACT(keyword FROM value) | EXTRACT(keyword FROM value)
Fibers
4.9.4 Fine Tuning Parameters | 7.2.4 Fibers
Files
14. Ovrimos Files and
Fine Tuning Parameters
4.9.4 Fine Tuning Parameters | 14.2.2 Database Parameters
float_expression
float_expression | float_expression | float_expression
FLOOR
FLOOR(numeric_expression) | FLOOR(numeric_expression) | FLOOR(numeric_expression)
Foreign keys
13.1.1.0.5 Foreign keys
FreeBSD
2.1.1 FreeBSD Installation
Global Parameters
14.2.1 Global Parameters
Grant
Grant | Grant | Grant
Host Name
4.9.5 Miscellaneous Parameters
HOSTNAME, parameter
14.2.2 Database Parameters
HTML Interface
1.2 Salient Features | 2.1 Unix Installation | 4.1 Overview | 5.2 Operating SQL Terminal | 6.1 Overview | 7.2 Operation
HTMLREF
HTMLREF(long_expression, ascii_expression)
HTTP Fibers
4.9.4 Fine Tuning Parameters
HTTP Log
8.7 HTTP Log | 8.7 HTTP Log
HTTP Log File
4.8 Database Creation | 14.2.2 Database Parameters
HTTP Port
4.9.2 HTTP Server Parameters
HTTP resources
8.2 Ovrimos URL-space
HTTP Root Directory
4.8 Database Creation | 14.2.2 Database Parameters
HTTP Server
3.2.2 The HTTP Server | 8. The HTTP server
HTTP Server Parameters
4.9.2 HTTP Server Parameters | 14.2.2 Database Parameters
HTTP Session Timeout
4.9.2 HTTP Server Parameters
HTTP Sessions
7.2.3 HTTP Sessions
HTTP Shared Directory
14.2.1 Global Parameters
HTTPLOGFILE, parameter
14.2.2 Database Parameters
HTTPPORT, parameter
14.2.2 Database Parameters
HTTPROOTDIR, parameter
14.2.2 Database Parameters
HTTPSESSIONTIMEOUT, parameter
14.2.2 Database Parameters
HTTPSHAREDDIR, parameter
14.2.1 Global Parameters
HTTPTHREADS, parameter
14.2.2 Database Parameters
IDENTITY
IDENTITY(numeric_expression1, numeric_expression2) | IDENTITY(numeric_expression1, numeric_expression2) | IDENTITY(numeric_expression1, numeric_expression2)
IFNUL
IFNUL(expression, value) | IFNUL(expression, value) | IFNUL(expression, value)
IMAGE
IMAGE(long_expression)
info directive
9.2 Operating SQL Query
Initial Password
3.2.3 Database Manager | 3.2.4 SQL Terminal | 4.3 Accessing Database Manager | 5.2 Operating SQL Terminal | 6.1 Overview | 7.2 Operation | 8.8 Demo bookstore: An | 9.2 Operating SQL Query | 13.4.1 Login Authentication | 13.4.2 Passwords and Password | 14.2.1 Global Parameters | 17.11.3 Initial Users
Initial Users
17.11.3 Initial Users
Insert
Insert | Insert | Insert
Installation
1.2 Salient Features | 2. Installation
integer_expression
integer_expression | integer_expression | integer_expression
Internet Queries
5.2.3 Internet queries in
Isolation Level
5.2.1 SQL transactions
Isolation Levels
13.1.2.0.2 Isolation levels
Java Example
10.2.1 A JDBC example
JDBC
3.5 The JDBC Interface | 10.2 JDBC
JDBC driver
10.2 JDBC
Keywords
15.2 Keywords | 16.2 Keywords | 17.2 Keywords
LCA
13.5.1 Local Certification Authorities
LCASE
LCASE(string_expression) | LCASE(string_expression) | LCASE(string_expression)
LENGTH
LENGTH(string_expression) | LENGTH(string_expression) | LENGTH(string_expression)
License
2.3.4 Ovrimos registration and | 3.7 Database Connections | 4.12 Editing the serial | 14.2.1 Global Parameters
LICENSE, parameter
14.2.1 Global Parameters
Local Certification Authorities
13.5.1 Local Certification Authorities
LOCATE
LOCATE(string_expression1, string_expression2 [, start]) | LOCATE(string_expression1, string_expression2 [, start]) | LOCATE(string_expression1, string_expression2 [, start])
Lock Wait Times
4.9.4 Fine Tuning Parameters
LOCKWAITTIME, parameter
14.2.2 Database Parameters
log
13.2 Data Recovery | LOG(float_expression) | LOG(float_expression) | LOG(float_expression)
Log File
4.8 Database Creation | 4.8.1 How to create | 14.2.2 Database Parameters
LOG10
LOG10(float_expression) | LOG10(float_expression) | LOG10(float_expression)
LOGFILE, parameter
12.2 Database Recovery | 14.2.2 Database Parameters
Login Authentication
13.4.1 Login Authentication
Logins
13.4.3 Unauthorized Logins
long_expression
long_expression | long_expression | long_expression
LOWER
LOWER(string_expression) | LOWER(string_expression) | LOWER(string_expression)
LTRIM
LTRIM(string_expression) | LTRIM(string_expression) | LTRIM(string_expression)
MAILSERVER, parameter
14.2.2 Database Parameters
Main Server
4.9.5 Miscellaneous Parameters
MAPFILENUM, parameter
14.2.2 Database Parameters
MAPPAGEFACTOR, parameter
14.2.2 Database Parameters
MAPPAGENUM, parameter
14.2.2 Database Parameters
Mapped Region Size
4.9.4 Fine Tuning Parameters | 14.2.2 Database Parameters
Mapped Regions Per Table
4.9.4 Fine Tuning Parameters
Mathematical functions
15.6.1 Mathematical functions | 16.6.1 Mathematical functions | 17.6.1 Mathematical functions
MIME Types
14.2.1 Global Parameters | 14.2.2 Database Parameters
MIME Types File
4.9.2 HTTP Server Parameters
MIMETYPE
MIMETYPE(long_expression)
MIMETYPES, parameter
14.2.2 Database Parameters
MIMETYPES, parameters
14.2.1 Global Parameters
Miscellaneous
14.2.2 Database Parameters
Miscellaneous Parameters
4.9.5 Miscellaneous Parameters
MOD
MOD(integer_expression1, integer_expression2) | MOD(integer_expression1, integer_expression2) | MOD(integer_expression1, integer_expression2)
MONTHNAME
MONTHNAME(date_expression) | MONTHNAME(date_expression) | MONTHNAME(date_expression)
navigation directive
9.2 Operating SQL Query | 9.5 Cursors and Navigation
Nested Transactions
13.1.2.0.4 Nested Transactions
New Features
1.3 New Features
Non-cursor Operations
Non-cursor Operations | Non-cursor Operations | Non-cursor Operations
Non-repeatable Read
13.1.2.0.2 Isolation levels
Normal Termination
13.1.2.0.1 Transactions
NOW
NOW() | NOW() | NOW()
NULLIF
NULLIF (expression1, expression2 ) | NULLIF (expression1, expression2 ) | NULLIF (expression1, expression2 )
numeric_expression
numeric_expression | numeric_expression | numeric_expression
ODBC
3.4 The ODBC Interface | 10.1 ODBC
ODBC driver
10.1.1 ODBC driver installation
On-line Backup
12.1 Database Backup
On-line documentation
14.1 Files that Ovrimos
OPENSSL, parameter
14.2.1 Global Parameters
Ovrimos Registration
2.3.4 Ovrimos registration and
Ovrimos Users
3.1 Ovrimos at a
Ovrimos Users
1.5 Types of users
Parameters
14. Ovrimos Files and | 14.2 Configuration Parameters
Password
3.2.4 SQL Terminal | 4.3 Accessing Database Manager | 5.2 Operating SQL Terminal | 6.1 Overview | 8.8 Demo bookstore: An | 9.2 Operating SQL Query | 13.4 Authentication
Password Parameters
4.9.3 Password Parameters | 14.2.2 Database Parameters
Password Policy
1.3 New Features | 13.4.2 Passwords and Password
Passwords
13.4.2 Passwords and Password
pause directive
9.2 Operating SQL Query
Periodic Maintenance
12.3 Periodic Maintenance
Perl
3.6.2 Perl | 10.3 DBI
Perl Example
10.3.1 A Perl example
Persistent Scripts
8.5.2.2 Persistent Scheme Scripts
Persistent Sessions
1.2 Salient Features | 8.5.3 HTTP Server and
Persistent Stored Modules
18. Persistent Stored Modules
Phantoms
13.1.2.0.2 Isolation levels
Physical Page Size
4.9.4 Fine Tuning Parameters
PI
PI() | PI() | PI()
PLAYBACK, parameter
12.2 Database Recovery | 14.2.1 Global Parameters
POSITION
POSITION | POSITION | POSITION
Post-Installation
2.3 Post-installation tasks
POWER
POWER(numeric_expression, integer_expression) | POWER(numeric_expression, integer_expression) | POWER(numeric_expression, integer_expression)
Primary key
13.1.1.0.4 Candidate keys
Privilege Inheritance
13.4.5 Privilege Inheritance
PSM
1.3 New Features
QUARTER
QUARTER(date_expression) | QUARTER(date_expression) | QUARTER(date_expression)
RADIANS
RADIANS(numeric_expression) | RADIANS(numeric_expression) | RADIANS(numeric_expression)
RAND
RAND([integer_expression]) | RAND([integer_expression]) | RAND([integer_expression])
READ COMMITTED
13.1.2.0.2 Isolation levels
READ UNCOMMITTED
13.1.2.0.2 Isolation levels
read-lock
13.1.2.0.2 Isolation levels
Realms
7.2.3 HTTP Sessions
Reconnect
5.3 Disconnecting and Reconnecting
Recovery
12.2 Database Recovery
REGEXP
REGEXP(string, pattern [,position]) | REGEXP(string, pattern [,position]) | REGEXP(string, pattern [,position])
REGEXPCOUNT
REGEXPCOUNT(expression, pattern [,position]) | REGEXPCOUNT(expression, pattern [,position]) | REGEXPCOUNT(expression, pattern [,position])
REGEXPCOUNTICASE
REGEXPCOUNTICASE(expression, pattern [,potition]) | REGEXPCOUNTICASE(expression, pattern [,potition]) | REGEXPCOUNTICASE(expression, pattern [,potition])
REGEXPICASE
REGEXPICASE(expression, pattern [,position]) | REGEXPICASE(expression, pattern [,position]) | REGEXPICASE(expression, pattern [,position])
Registration
2.3.4 Ovrimos registration and
Regular Expression functions
15.8 Regular Expression functions | 16.8 Regular Expression functions | 17.8 Regular Expression functions
REPEATABLE READ
13.1.2.0.2 Isolation levels
REPLACE
REPLACE(string_expression1, string_expression2, string_expression3) | REPLACE(string_expression1, string_expression2, string_expression3) | REPLACE(string_expression1, string_expression2, string_expression3)
Replication
11. Replication
Replicator
1.3 New Features
Replicator Directory
4.8 Database Creation
REPLICATOR Fibers
4.9.4 Fine Tuning Parameters
Replicator Port
4.9.1 SQL Server Parameters
REPLICATOR, parameter
14.2.1 Global Parameters
REPLICATORDIR, parameter
14.2.2 Database Parameters
REPLICATORPORT, parameter
14.2.2 Database Parameters
REPLICATORTHREADS, parameter
14.2.2 Database Parameters
Reserved words
15.2 Keywords | 16.2 Keywords | 17.2 Keywords
Resource Monitoring
1.2 Salient Features | 7. Administrator's Console
Resources
8.2 Ovrimos URL-space
Resources, HTTP
8.2 Ovrimos URL-space
Resources, Web
9.6.1 How to produce SQL Tool | 14.1 Files that Ovrimos
Result Set
Cursor Operations | Cursor Operations | Cursor Operations
Revoke
Revoke | Revoke | Revoke
Roadmap
3.2.5 Roadmap | 6. Roadmap
Rollback
Rollback | Rollback | Rollback
ROUND
ROUND(numeric_expression, integer_expression) | ROUND(numeric_expression, integer_expression) | ROUND(numeric_expression, integer_expression)
Rowset size
5.2 Operating SQL Terminal
RTRIM
RTRIM(string_expression) | RTRIM(string_expression) | RTRIM(string_expression)
Salient Features
1.2 Salient Features
schema
17.11.1 Database schemas
Scheme
3.6.3 Scheme
Scheme Handler File
14.2.2 Database Parameters
Scheme Handlers
4.9.2 HTTP Server Parameters
Scheme Initialization File
14.2.1 Global Parameters
Scheme Interpreter
8.5.2 Scheme Scripts
Scheme Library File
4.9.2 HTTP Server Parameters | 14.2.2 Database Parameters
Scheme Scripts
8.5.2 Scheme Scripts
Scheme Types
8.6 Appendix: Scheme
SCHEMEHANDLERS, parameter
14.2.2 Database Parameters
SCHEMEINIT, parameter
14.2.1 Global Parameters | 14.2.2 Database Parameters
Script Execution
9.4 Executing SQL scripts
Script Upload
5.2.2 Uploading SQL Scripts
Secure Socket Layer
13.5 Secure Socket Layer
Security
13. Database Security
Select
Select | Select | Select
Select for Update
Select for Update | Select for Update | Select for Update
Semantic Integrity
13.1.1 Semantic Integrity
Semaphore Key
4.9.1 SQL Server Parameters
SEMKEY, parameter
14.2.2 Database Parameters
Serial Number
14.2.1 Global Parameters
SERIALIZABLE
13.1.2.0.2 Isolation levels
SERIALNUMBER, parameter
14.2.1 Global Parameters
Set Time Zone
Set Time Zone | Set Time Zone | Set Time Zone
Set Transaction
Set Transaction | Set Transaction | Set Transaction
Shared Memory Key
4.9.1 SQL Server Parameters
SHMEMKEY, parameter
14.2.2 Database Parameters
Shut down Database
4.7 Starting up and
SIGN
SIGN(numeric_expression) | SIGN(numeric_expression) | SIGN(numeric_expression)
SIN
SIN(float_expression) | SIN(float_expression) | SIN(float_expression)
SQL dynamic parameters
15.1.2 SQL parameters | 16.1.2 SQL parameters | 17.1.2 SQL parameters
SQL Fibers
4.9.4 Fine Tuning Parameters
SQL Functions
15.5 Standard SQL Functions | 16.5 Standard SQL Functions | 17.5 Standard SQL Functions
SQL parameters
15.1.2 SQL parameters | 16.1.2 SQL parameters | 17.1.2 SQL parameters
SQL Port
4.9.1 SQL Server Parameters
SQL Query Tool
3.3 The SQL Query | 9. SQL Query Tool
SQL script uploading
5.2 Operating SQL Terminal | 5.2.2 Uploading SQL Scripts
SQL Scripts
8.5.1 SQL Scripts
SQL Server
3.2.1 The SQL Server
SQL Server Parameters
4.9.1 SQL Server Parameters | 14.2.2 Database Parameters
SQL Statements
15. Ovrimos SQL | 15.4 Supported SQL Statements | 16. Ovrimos SQL | 16.4 Supported SQL Statements | 17. Ovrimos SQL | 17.4 Supported SQL Statements
SQL Terminal
3.2.4 SQL Terminal | 5. SQL Terminal
SQL Transactions
5.2.1 SQL transactions
SQLAPP4, parameter
14.2.1 Global Parameters
SQLCORE, parameter
14.2.1 Global Parameters
SQLPORT, parameter
14.2.2 Database Parameters
SQLTHREADS, parameter
14.2.2 Database Parameters
SQRT
SQRT(float_expression) | SQRT(float_expression) | SQRT(float_expression)
SSL
1.3 New Features
SSL Parameters
4.9.6 SSL Parameters
Start Database
4.7 Starting up and
Start Database Manager
4.2 Starting and Stopping
Stateless Scripts
8.5.2.1 Stateless Scheme Scripts
Static Resources
8.3 Static Web Content
Static Web Content
8.3 Static Web Content
Stop Database Manager
4.2 Starting and Stopping
Stored Procedures
1.2 Salient Features | 10.5 Stored Procedures
String manipulation functions
15.6.3 String manipulation functions | 16.6.3 String manipulation functions | 17.6.3 String manipulation functions
string_expression
integer_expression | integer_expression | integer_expression
SUBSTRING
SUBSTRING | SUBSTRING | SUBSTRING
System functions
15.7 System functions | 16.7 System functions | 17.7 System functions
System Requirements
1.2 Salient Features | 2. Installation
System Tables
17.11.2 System tables
Table constraints
13.1.1.0.2 Table constraints
TAN
TAN(float_expression) | TAN(float_expression) | TAN(float_expression)
TCP/IP
2. Installation | 10.2 JDBC
TEMPDIR, parameter
14.2.2 Database Parameters
Temporary Directory
4.8 Database Creation | 14.2.2 Database Parameters
testbase
2.1 Unix Installation | 2.3.1 Populating testbase (optional) | 8.8 Demo bookstore: An | 9.6 HTML output from | 14.2.1 Global Parameters | 15.3 Sample Data | 16.3 Sample Data | 17.3 Sample Data
TIME
timestamp_expression | timestamp_expression | timestamp_expression
time_expression
time_expression | time_expression | time_expression
TIMESTAMP
timestamp_expression | timestamp_expression | timestamp_expression
timestamp_expression
timestamp_expression | timestamp_expression | timestamp_expression
TIMESTAMPADD
TIMESTAMPADD(interval, integer_expression, timestamp_expression) | TIMESTAMPADD(interval, integer_expression, timestamp_expression) | TIMESTAMPADD(interval, integer_expression, timestamp_expression)
TIMESTAMPDIFF
TIMESTAMPDIFF(interval, timestamp_expression1, timestamp_expression2) | TIMESTAMPDIFF(interval, timestamp_expression1, timestamp_expression2) | TIMESTAMPDIFF(interval, timestamp_expression1, timestamp_expression2)
TLS Parameters
14.2.2 Database Parameters
TLSAUTHENTICATION, parameter
14.2.2 Database Parameters
TLSCIPHERSUITES, parameter
14.2.2 Database Parameters
TLSCREDENTIALS, parameter
14.2.2 Database Parameters
TLSTRUSTEDCAS, parameter
14.2.2 Database Parameters
Transactions
5.2.1 SQL transactions | 13.1.2 Transaction Atomicity
Triggers
1.3 New Features
TRIM
TRIM | TRIM | TRIM
TRUNCATE
TRUNCATE(numeric_expression, integer_expression) | TRUNCATE(numeric_expression, integer_expression) | TRUNCATE(numeric_expression, integer_expression)
UCASE
UCASE(string_expression) | UCASE(string_expression) | UCASE(string_expression)
Unicode
1.2 Salient Features | Unicode Strings | 15.6.3 String manipulation functions | Unicode Strings | 16.6.3 String manipulation functions | Unicode Strings | 17.6.3 String manipulation functions
Unicode Data
Table Uni | Table Uni | Table Uni | 17.10 Storage and Retrieval
unicode_expression
unicode_expression | unicode_expression | unicode_expression
Uninstall
2.5 Uninstalling Ovrimos
Unix Installation
2.1 Unix Installation
Update Positioned
Update Positioned | Update Positioned | Update Positioned
Update Searched
Update Searched | Update Searched | Update Searched
Update User
Update User | Update User | Update User
Upgrade Installation
2.4 Upgrade Installation
UPPER
UPPER(string_expression) | UPPER(string_expression) | UPPER(string_expression)
URI
URI(long_expression)
URI function
17.9 BLOBs and the
URL space
8.2 Ovrimos URL-space
USER
USER | USER | USER
User Authentication
5.2 Operating SQL Terminal | 6.1 Overview
User Name
3.2.3 Database Manager | 3.2.4 SQL Terminal | 4.3 Accessing Database Manager | 5.2 Operating SQL Terminal | 6.1 Overview | 8.8 Demo bookstore: An | 9.2 Operating SQL Query | 13.4 Authentication
User Privileges
13.4.4 User Privileges
USERPOLICY, parameter
14.2.2 Database Parameters
Web Server
8.1 Overview
WEEK
WEEK(date_expression) | WEEK(date_expression) | WEEK(date_expression)
Windows NT Installation
2.2 Windows NT /
write-lock
13.1.2.0.2 Isolation levels