LIST-SQL-STREAMS
Prev | SQL I/O Recording | Next

## Name

LIST-SQL-STREAMS — List the components of the broadcast streams used for recording SQL commands or results.Function

## Syntax

          list-sql-streams &key type database => result

## Arguments and Values

`type`

  One of the following keyword symbols: :commands, :results or :both, defaulting to :commands.

`database`

  A database object. This will default to *default-database*.

`result`

  A list.

## Description

Returns the list of component streams for the broadcast stream recording SQL commands sent to and/or results returned from `database` which defaults to *default-database*. `type` must be one of :commands, :results, or :both, defaulting to :commands, and determines whether the listed streams contain those recording SQL commands, results or both.

## Examples

    (list-sql-streams :type :both)
    => NIL
    (start-sql-recording :type :both)
    =>
    (list-sql-streams :type :both)
    => (#<Stream for descriptor 7> #<Stream for descriptor 7>)

## Side Effects

None.

## Affected by

`add-sql-stream`
`delete-sql-stream`

## Exceptional Situations

An error is signalled if `type` is passed a value other than :commands, :results or :both.

## See Also

`sql-stream`
`add-sql-stream`
`delete-sql-stream`

## Notes

None.

Prev | Up | Next
DELETE-SQL-STREAM | Home | CLSQL Condition System