The names of streams from which to dequeue. The default is to dequeue from all output streams (that is, all streams that do not feed into the input ports of other operators). You can specify a simple stream name as reported by sbc list, or you can specify a stream name qualified by its container name. Thus, the following commands are equivalent:

sbc deq BestAsks

sbc deq default.BestAsks

If the running application is structured with modules, and one or more output streams in a module were declared public (that is, the streams were exposed for dequeuing regardless of module depth), then you can also dequeue from such streams. In this case, qualify the stream name with its containing outer module name, then the inner module name, then stream name. For example:

sbc deq outer.inner.innerOutputStream

If you need to distinguish identically named streams in separate containers, you can prefix the container name of interest:

sbc deq container2.outer.inner.innerOutputStream

Use logical-name as a logical name from the preceding stream specified on the sbc command line. No two logical names can be identical.

Dequeue from all streams in the specified container (including input, intermediate, and output streams), or in the default container if unspecified. Use the -u option to specify a particular container; -u is required if the running application does not have a primary container named default. With the optional modifier =input, streams are limited to all input streams. Likewise, specifying --all=output shows all the output streams. The default, without an = modifier, is to show both input and output streams.

Dequeue from all streams in all containers. Use the -u option to specify a particular container; -u is required if the running application does not have a primary container named default. This option takes the same =input and =output modifiers as --all.

Use delim (a single character, or the literal string tab) as a field separator. The default field separator is a comma.

Write a header at the beginning of the output. This option is valid only when exactly one stream is specified.

Write out informational lines, such as when all streams have been subscribed to. Informational lines begin with an asterisk and two quotation marks (which is an invalid CSV line) so they can be distinguished from other output.

Use quotechar (a single character) as a quotation mark. The default quotechar is a double quote.

Output the current timestamp, optionally formatted according to a quoted format string. If the format string is omitted, format-string defaults to "YYYY-MM-DD HH:mm:ss.SSS[+/-]TTTT" (for example, 2014-09-02 13:50:50.8-0400).

When this command is invoked as sbc, the allowable format strings are based on the ISO C standard strftime API for UNIX platforms and on the Microsoft strftime API for Windows platforms.

When invoked as jsbc, The allowable string formats are the same as those accepted by the expression language's format_time() function, which are based on the java.text.SimpleDateFormat class.

Output human-readable tuples, showing the stream name, a tuple ID number, then each field name and value. By default, tuple IDs are all 0. To obtain zero-based sequence numbers for tuple IDs, set the Java system property streambase.appgen.tupleid to sequential. The sequence of IDs resets for each new sbd server instance. For example, the following line might be output from sbc deq with its default settings: 33620,NCC,30.5. With the -v option, this same line shows as follows:

BestAsks: (tupleid=643,time=33620,symbol="NCC",best_ask=30.5)

You can also set streambase.appgen.tupleid=hash. Doing so reports hashed values instead of sequential values. Hashed values are not guaranteed to be unique or repeatable. Use the --json option to output tuples in JSON format.

Apply the expression condition as a predicate expression to narrow or select data from the preceding stream specified on the sbc command line. For example, for a stream named outstream that has a field named symbol:

sbc deq outstream --where "symbol='IBM'"

The --where clause can contain the name of a named schema, such as when specifying the schema of a field of type tuple. For example, for a stream whose field named Bids is defined as having type Transaction:

sbc deq outstream --where "Bids=Transaction(1000,'IBM',243.32)" 

A no-fields tuple is the input format you send to an input stream defined with an empty schema, as described in Using Empty Schemas. Send a no-fields tuple as a line with one or more spaces or tabs, or, when using the --json option, as one or more spaces or tabs surrounded by braces.

To specify a field of type list, enclose the list in quoted square brackets. For example: "[1, 2, 3]" or "[alpha, beta, gamma]". You only need to quote each element of a list(string) if an element contains the field separator character (comma by default).

To specify a field of type tuple, use quotes to surround the tuple field. For example, for the schema string, tuple(int, int, int), enter lines in the following format:

IBM, "12, 45, 87"

For deeper nesting, use doubled quotes to specify a literal quote character. For example, for the schema double, tuple(string, tuple(int, int, int)) (which has two fields, a double and a tuple), enter lines like the following:

3.14159, " IBM, ""12, 45, 87"" "

A no-fields tuple is the input format you send to an input stream defined with an empty schema, as described in Using Empty Schemas. To enqueue a no-fields tuple with sbc enqueue, send the following commands:

The name of the stream on which to enqueue data. If no stream name is provided, the first input field for each line on stdin must be the stream name to receive that input line.

If the running application is structured with modules, and the definition of an input stream in a module exposes that stream for enqueuing regardless of module depth, then you can enqueue to such a stream. In this case, qualify the stream name with its containing outer module names. For example:

sbc enq outer.inner.innerInputStream

If you need to distinguish identically named streams in separate containers, prefix the container name of interest:

sbc enq container2.outer.inner.innerInputStream

Use size to indicate the number of tuples to buffer. The default is no buffering.

Use delim (a single character, or the literal string tab) as a field separator. The default field separator is a comma.

Specify the order of fields in the input. The first column in the input is field1 in the input stream, and so on. This option ismuch the same only valid when a stream name is provided.

Use interval to specify the enqueuing flush interval in milliseconds. If buffering was not enabled, defaults to 250 milliseconds.

Consider a field to be null when null-string is specified as a value. The default string to indicate a null field is null.

Use quotechar (a single character) as a quotation mark. The default quotechar is a double quote.

Produces a list of all streams, containers, schemas, and tables in the connected application, including intermediate streams, but not including any system streams. The -a list option presumes the -c option, and always shows container names.

Includes container names as a prefix to the entity names in the resulting list.

Lists the streams and operators for the specified container. For example, the following command lists the contents of the container named mainapp on the default server and port:

sbc list -C mainapp

Includes module references. Modules can be explicitly referenced in the application, or referenced implicitly by StreamBase. That is, when a component runs in multiple parallel regions, StreamBase creates an implicit module for each running instance.

Shows all container connections.

Read and display all table rows with --all or specify a row limit. The default is --limit 10.

Use delim (a single character, or the literal string tab) as the displayed field separator. The default is a comma. This option only affects the display of table rows, not how they are read.

These options are mutually exclusive; by default, both options are omitted. Specify --header to write a header line at the beginning of the output that shows each field name, like the following example:

key,city,papers
3,Boston,"[The Globe,void]"
2,Paris,"[Le Monde,Le Figaro,La Croix]"

As an alternative, specify -v (verbose) to emit more information for each row, like the following example. The -v option cannot be used with --header.

Table: SimpleTable
(tupleid=0,key=3,city="Boston",papers="[\"The Globe\",null]")
(tupleid=0,key=2,city="Paris",papers="[\"Le Monde\",\"Le Figaro\",\"La Croix\"]"
)
Result set size: 2 limit: 2

Specify the string you want to display when a table field is read as null. The default string to indicate a null field is null.

Use quotechar (a single character) as a quotation mark when the emitted display requires quotes. The default quotechar is a double quote.

Instead of server status, displays the status of any Java operators or embedded adapters in the server. Optionally narrows the status to any Java operators or embedded adapters in the specified container. The status for each Java operator or embedded adapter has possible values of NOT_YET_STARTED, STARTED, SUSPENDED_AND_DROPPING_TUPLES, SUSPENDED_AND_PROCESSING_TUPLES, and SHUTDOWN.