63
Building Streams
Setting SQL logging and record status options for streams
These settings include various options controlling the display of SQL statements generated by the
stream, and the display of the number of records processed by the stream.
Figure 5-20
SettingSQL loggi ng and record status options for a stream
DisplaySQL in the messag esl og 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.
DisplaySQL. Specifies whether any SQL that is displayed 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 implemented. For
example, this control would have no effect for SQL Server.