IBM PureData System for Analytics, Version 7.1

Read-only sessions

The IBM® Netezza® SQL provides SQL commands that define sessions as read-only:

SET SESSION { READ ONLY | READ WRITE }

Read-only sessions are efficient and reduce the overhead in processing SQL commands. If you define a session as read-only and the system encounters an insert, update, delete, truncate SQL, a DDL, or DCL command, it generates an error.