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.
Contents
- StreamSQL Overview
- 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