User's Manual

63
Building Streams
Setting SQL logging and record status options for streams
These setting s include various options controlling the display of SQL statements 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 whethe r SQL generated while
running the stream is passed to the message log.
Display SQL generation details in the messages log during stream preparation. During s tream
preview, specifies whether a preview of the SQL that would be generated is passed to the
messages log.
Display SQL. Specifies wheth er any SQL that is displayed in the log should contain native SQL
functions or standard ODBC functions of the form {fn FUNC(…)}, as g enerated by IBM® SPSS®
Modeler. The former relies on O DBC driver functionality th at may not be implemented. For
example, this control would have no effect for SQL Server.