Name

DELETE-SQL-STREAM — Remove a component from the broadcast streams used for recording SQL commands or results.Function

Syntax

      delete-sql-stream stream &KEY type database => result

Arguments and Values

stream

A stream or T.

stream

A stream or T.

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

The added stream.

Description

Removes the supplied stream stream from the recording broadcast stream for the SQL recording type specified by type on database which defaults to *default-database*. type must be one of :commands, :results, or :both, defaulting to :commands, depending on whether the stream is to be added for recording SQL commands, results or both.

Examples

(list-sql-streams :type :both)
=> (#<Stream for descriptor 7> #<Stream for descriptor 7>)
(delete-sql-stream *standard-output* :type :results)
=> #<Stream for descriptor 7>
(list-sql-streams :type :both)
=> (#<Stream for descriptor 7>)
      

Side Effects

The specified broadcast stream(s) associated with database are modified.

Affected by

None.

Exceptional Situations

None.

See Also

start-sql-recording
stop-sql-recording
sql-recording-p
sql-stream
add-sql-stream
delete-sql-stream
list-sql-streams

Notes

None.