Use the Bindings tab to create bindings between an input or output data stream and a stream in another query module, and to override the default values for parameters.
To bind an input stream to a stream in a parent query module, enter the name of the input data stream in the Formal Name box of the Input Streams section and the name of the data stream to which it is bound in the Connection box. When binding an input stream to a stream in an unrelated module, the Connection specified in the binding must be the full stream URI. The stream URI is listed in the stream’s properties.
To bind an output stream to a stream in the project or parent query module, enter the name of the output data stream in the Formal Name box of the Output Streams section of this tab and the name of the parent data stream to which it is bound in the Connection box. When binding an output stream to a stream in an unrelated module, the Connection specified in the binding must be the full stream URI of the stream. The stream URI is listed in the stream’s properties.
Any parameters defined under the Parameters tab also appear in the Parameters section of the Bindings tab. To override the default value of a parameter, set the value for the parameter in the Value column on the Bindings tab.
When binding between data streams within a single project, the schema of the stream in the parent module must be a superset of the schema of the stream in the child module, matching all columns in the child schema by name and data type.
When binding between data streams in separate projects, Sybase CEP Engine matches the data based on column name and data type, regardless of number and order. Columns present in the publishing stream that are not present in the subscribing stream are ignored, while columns present in the subscribing stream that are not present in the publishing stream are set to NULL.
For example, assume stream A is defined with two columns - Symbol, type String, and Price, type Long - while stream B is defined in a separate project with three columns - Price, type Long; Volume, type Integer; and Symbol, type String. If you bind these two streams together, with stream A publishing to Stream B, the values from stream A's Symbol and Price columns are placed in the matching columns of stream B, while stream B's Volume column is set to NULL. If you bind the streams with B publishing to A, then A receives the values from the Symbol and Price columns in stream B, while the Volume column is ignored.