StreamSQL Guide

Topics

• General Information

  • StreamSQL Guide Conventions

  • Using StreamSQL

  • Wildcard Rules

  • Using the SBAPP-to-SSQL Conversion Assistant

  • StreamSQL Editor (related topic in the StreamBase Studio Reference)

• StreamSQL Data Definition Language

  • 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

• StreamSQL Data Manipulation Language

  • 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