GDBase

Table of Contents

Preface

43. GDBase Command Reference

Introduction

ALTER TABLE

CHECK TABLE

COMMENT

CREATE INDEX

CREATE/REPLACE TABLE

CREATE TABLE ... TRANSFORM

The __vars__ dictionary

Skipping rows

Processing in groups

The __save__ function

Referring to previous rows

Using sql inside TRANSFORM

CREATE TRIGGER

The RAISE function

CREATE VIEW

DELETE

DROP INDEX

DROP TABLE

DROP TRIGGER

DROP VIEW

GET

INSERT

MERGE

ON CONFLICT

REPLACE INTO

SELECT

DISTINCT

KEEP and DROP

FROM

WHERE

GROUP BY

ORDER BY

LIMIT

UNION, UNION ALL, APPEND, EXCEPT, INTERSECT

JOIN

SAMPLE

Order of execution in SELECT statements

TRANSACTION

UPDATE

Data types

Expressions

Unary operators

Binary operators

Column names

SELECT statement in expressions

CAST statement

Additional information

GDBase core functions

Simple functions

Aggregate Functions

Window functions

Quoting

GDBase keywords

Special characters

Nulls handling

Comments in SQL code

44. Importing and exporting data

Importing and exporting between GDBase databases

Importing from a local GDBase database

Importing from a remote GDBase database

Exporting to the local GDBase database

Exporting to a remote GDBase database

Importing and exporting using ODBC drivers

IMPORT ... USING ODBC

EXPORT ... USING ODBC

Data types in imported tables

45. GDBase Administration

General information

GDBase setup

Database log-in

Default user

Administrator accounts

Creating an administartor account

Changing the administrator password

Users

Adding new users

User properties

Changing user properties

Displaying user properties

Table ownership

User Privileges

Changing user password

Deleting users

Access Control

Determining access privileges

Default Table Properies

Controlling queries

SHOW PROCESS

KILL PROCESS

PAUSE PROCESS

RESUME PROCESS

Commands available from user interface level

Additional information

Resetting user privileges

C. GDBase Keywords