Filter
Top Products
63
Building Streams
Setting SQL logging and record status options for streams
These settings include various options co ntrolling th e display of SQL statem ents generated by the
stream, and the display of the number of rec ords processed by the stream.
Figure 5-20
Setting SQL logging and record status options for a stream
Display SQL in the messages log during stream execution.
Specifies whether SQL generated while
running the stream is passed to the message log.
Display SQL generation details in the messages log during stream preparation.
During stream
preview, specifies whether a preview of the SQL that would be generated is passed to the
messages log.
Display SQL.
Specifies whether any SQL that is displaye d in the log should contain native SQL
functions or standard ODBC functions of the form {fn FUNC(…)}, as generate d by IBM® SPSS®
Modeler. The former relies on ODBC driver functionality that may not be implemente d. For
example, this control would have no effect for S QL Server.