Navigator Systems Nexus SQL Database Server

Contents | Index 

Title

Overview

Overview

Introduction

Introduction

Why use a Client/Server database ?

Advantages of the NexusDB engine

SQL 2003

Technical Support

Zendesk Portal

Installation

Hardware Requirements

Server Memory Requirement Overview

FireWall Requirements

Software Requirments

Download and Product key

Installation Start

License Agreement

Installation Location

Short Cut

Installation Database Location

Installation Database Name

Trial or Full

Installation Product Key

Installation User

Installation Go

Trial request

Install Empty Database

Installation Finished

Running Updates

Upgrading from HireTrack Eclipse

Introduction

Installation

Starting the upgrade process

Progress Window

Prompt: Consignments

Prompt: Late Returns

Prompt: Documents & Emails

Ending the upgrade process

Troubleshooting

The Server in depth

Starting and Stopping the NXServer

The Server User Interface

Settings Page Overview

Statistics Page Overview

SQL Manager Page Overview

Server Extended Settings

AppServer - Web Scripts

How to write a web script

Aliases

Remote Admin

Server Engine

SQL Engine

Users

Autoupdate Manager

Database Manager

Live Backups

License Manager

Support Info

Remote Command Handler

Server Side Pascal Scripts and NxCommand

NxCommand

Remote Document Handler

Scheduled SQL

Version Manager

Transports

TCP/IPv4

Client Update FTP Downloader

Client Update FTP Server

Email Settings

Additional Server Information

Server Settings

Service Settings

Backing up your data

Moving your data (NLS)

Restoring autobacked-up data

NexusDB Guide

Management Tools

The Enterprise Manager

Introduction

Global Options

Using the Servers Window

Server Context Menu

The Database Context Menu

The Tables Context Menu

The Views/Triggers/Procedures/Constraints Context Menu

The Table Context Menu

Creating and Restructuring Tables

Regular Identifiers

Field Types

Table Structure Window

Field Descriptors

Index Descriptors

Record Engine

Locale Descriptor

File Descriptors

Encryption Engine

Blob Engine

AutoInc Engine

Custom Descriptors

Fulltext Descriptors

Referential Integrity Descriptors

Browsing Tables and Queries

Using the Data Grid

Browsing a Table

The Table Menu

The Table View Menu

The Table Options Menu

Using SQL

The Query Menu

The Query View Menu

The Query Options Menu

Importing CSV Files

Step One - File Type

Step Two - Delimiters

Step Three - Field Formats and Advanced Options

Printing Reports

SQL Reference

SQL Introduction

About NexusDB SQL Reference

SQL Language Elements

Keywords

Identifiers

Comments

Operators

Null Values

Literals

Numeric Literals

String Literals

DateTime Literals

Interval Literals

Boolean Literals

Parameters

SQL Data Types

Overview of Predefined Data Types

String Types

Numeric Types

Boolean Types

DateTime Types

Value Expressions

Numeric Value Expressions

String Value Expressions

DateTime Value Expressions

Boolean Value Expressions

Row Value Expressions

Subqueries

Case Expressions

Cast Specification

SQL Functions

Aggregate Functions

Numeric Value Functions

Position Expression

Extract Expression

Length Expression

Absolute Value Expression

Modulus Expression

Natural Logarithm

Exponential Function

Power Function

Square Root Function

Floor Function

Ceiling Function

Arctangent Function

Cosine Function

Sine Function

Ordinal Function

PI Function

Round Function

Random Function

LastAutoinc Function

String Value Functions

Substring Function

Fold Function

Trim Function

Char Function

Tostring Function

Tostringlen Function

DateTime Value Functions

Current Date Function

Current Time Function

Current Timestamp Function

System Functions

Predicates

Comparison Predicate

Between Predicate

In Predicate

Like Predicate

Null Predicate

Quantified Comparison Predicate

Exists Predicate

Unique Predicate

Match Predicate

Equivalent Predicate

Odd Predicate

Inserting Predicate

Updating Predicate

Deleting Predicate

Stored Procedures and Functions

Procedure Language

SQL-Invoked Routines

SQL Procedure Statements

SQL Statements

Prepared Statements

Statement Switches

Schema Statements

CREATE ALIAS statement

CREATE TABLE statement

CREATE INDEX statement

CREATE VIEW statement

CREATE TRIGGER statement

CREATE PROCEDURE statement

CREATE FUNCTION statement

CREATE ASSEMBLY statement

ALTER TABLE statement

UPDATE ALIAS statement

DROP ALIAS statement

DROP TABLE statement

DROP INDEX statement

DROP VIEW statement

DROP TRIGGER statement

DROP ROUTINE statement

DROP ASSEMBLY statement

Data Statements

SELECT statement

INSERT statement

UPDATE statement

DELETE statement

EXECUTE IMMEDIATE statement

DECLARE CURSOR statement

OPEN statement

FETCH statement

CLOSE statement

Transaction Statements

START TRANSACTION statement

COMMIT statement

ROLLBACK statement

Session Statements

SET PASSWORDS statement

Control Statements

CALL statement

RETURN statement

Compound statement

DECLARE variable statement

SET statement

IF statement

ITERATE statement

LEAVE statement

REPEAT statement

WHILE statement

SIGNAL statement

TRY statement

Special Statements

ASSERT TABLE statement

SQL Appendices

Core SQL:2003 Features

Additional SQL:2003 Features

System Tables

© 2019 Navigator Systems Ltd