StreamSQL Guide

TIBCO StreamSQL is the TIBCO StreamBase text-based language for writing applications to query streams of data. StreamSQL applications are analogous to graphical EventFlow applications, but are stored in files with an ssql extension.

This guide is primarily a language reference that describes how to use the StreamSQL language elements. For general concepts and primitive operations common to both EventFlow and StreamSQL applications, look for references to appropriate topics in the Authoring Guide.

Reference Pages

StreamBase Environment Variables
StreamBase Java Properties
StreamBase Expression Language Functions

Contents

StreamSQL Overview
StreamSQL Guide Conventions
StreamSQL Tutorial
Converting EventFlow to StreamSQL
Wildcard Rules in StreamSQL SELECT Statements
StreamSQL Reserved Words
StreamSQL DDL
CREATE SCHEMA Statement
CREATE INPUT STREAM Statement
CREATE OUTPUT STREAM Statement
CREATE STREAM Statement
CREATE ERROR INPUT STREAM Statement
CREATE ERROR OUTPUT STREAM Statement
CREATE TABLE Statement
CREATE INDEX Statement
CREATE WINDOW Statement
CREATE MATERIALIZED WINDOW Statement
CREATE LOCKSET Statement
CREATE METRONOME Statement
CREATE PARAMETERS Statement
DECLARE Statement
USING Statement
StreamSQL DML
DELETE Statement
INSERT Statement
INSERT/UPDATE Statement
REPLACE Statement
TRUNCATE Statement
UPDATE Statement
APPLY Statement
BSORT Statement
GATHER Statement
HEARTBEAT Statement
LOCK/UNLOCK Statements
MERGE Statement
SELECT Statement
Tuple Join
UNION Statement
VJOIN Statement