SUPPORT / SAMPLES & SAS NOTES
Usage Note 20338: PRINTLOG option added to SPD Server to log SQL statements from client
 |  |  |  |  |
The PRINTLOG option has been added to SPD Server 4.4 TSM2 to allow you to see SQL text coming from the client. Prior to TSM2, there was not a way to log SQL text coming from a client.
The following SQL RESET options have been added to turn on/off printing of SQL statements to the SPD Server log:
execute (reset printlog) by sasspds; /* turns on printing */
execute (reset noprintlog) by sasspds; /* turns off printing */
You can also set the PRINTLOG option in the spdsserv.parm file:
SQLOPTS="reset printlog";
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Solaris | 4.4 | 9.1 TS1M3 | ||
| Solaris for x64 | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled Solaris | 4.4 | 9.1 TS1M3 | ||||
| HP-UX | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled HP-UX | 4.4 | 9.1 TS1M3 | ||||
| HP-UX IPF | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled AIX | 4.4 | 9.1 TS1M3 | ||||
| Tru64 UNIX | 4.4 | 9.1 TS1M3 | ||||
| AIX | 4.4 | 9.1 TS1M3 | ||||