REGISTER STREAM::=REGISTERSTREAM
stream-name
schema-specification-character-strings
schema-specification-character-strings::='('column-nametype-name[,column-name
type-name]...')'
Defines a stream.
This clause registers a stream to the system catalog areas that store stream management tables, and causes the system to begin accepting the stream.
stream-name
For a stream (input stream), specify any name that is unique within the stream data processing system. For details about specifying names, see 3.2.4 Specifying names.
schema-specification-character-strings
For the stream defined by the stream name, specify column names and their type names.
Specify all schema specification character strings in a single definition. For example, when defining a stream named s1, specify all of the necessary schema specification character strings as shown in Example 1.
REGISTER STREAM s1(id INT, name VARCHAR(10));
When defining a stream named s1, if schema specification character strings are specified separately as shown in Example 2, two streams having the same name end up being specified, resulting in an error.
REGISTER STREAM s1 (id INT);
REGISTER STREAM s1 (name VARCHAR(10));
None.
As a schema, a stream named s1, having a column named id of type INT and a column named name consisting of character data of one to ten characters in length, is defined in the system catalog.
REGISTER STREAM s1(id INT, name VARCHAR(10));