Deprecated Documentation
Starting with StreamBase 10.0, the StreamSQL language is deprecated, and is not supported for building new StreamBase solutions. Existing StreamSQL modules are supported in an application you are porting from a previous StreamBase release.
This StreamSQL Guide is provided on disk for reference when maintaining previously written StreamSQL modules, but has not been changed at all from its StreamBase 7 edition. The StreamSQL Guide is not linked from the menus of the StreamBase Studio Help system.
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 METRONOME Statement
- CREATE PARAMETERS Statement
- DECLARE Statement
- USING Statement
- StreamSQL DML