IBM PureData System for Analytics, Version 7.1

Changes to Netezza SQL commands

This section describes the changes in IBM® Netezza® SQL commands.

The following table describes the commands supported.

Table 1. Netezza SQL commands
Command	Description	See
ALTER CATEGORY	Changes the name of the category.	ALTER CATEGORY
ALTER COHORT	Changes the name or the hierarchy position of the cohort.	ALTER COHORT
ALTER DATABASE ... COLLECT HISTORY	Assigns the collect history to the database object.	ALTER DATABASE
ALTER GROUP	Changes the security label and audit categories, the collect history, concurrent session, and access time attributes of the group.	ALTER GROUP
ALTER HISTORY CONFIGURATION	Modifies the configuration of query or audit history logging.	ALTER HISTORY CONFIGURATION
ALTER SECURITY LEVEL	Changes the name or value of a security level.	ALTER SECURITY LEVEL
ALTER USER	Changes the security label and audit categories, the collect history, concurrent session, and access time attributes of the user object.	ALTER USER
CREATE CATEGORY	Creates a security category.	CREATE CATEGORY
CREATE COHORT	Creates a security cohort.	CREATE COHORT.
CREATE DATABASE ... COLLECT HISTORY	Assigns the collect history to the database object.	CREATE DATABASE
CREATE GROUP	Assigns the security label and audit categories, the collect history, concurrent session, and access time attributes to the group.	CREATE GROUP
CREATE HISTORY CONFIGURATION	Creates a history configuration.	CREATE HISTORY CONFIGURATION
CREATE SECURITY LEVEL	Creates a security level.	CREATE SECURITY LEVEL
CREATE TABLE ... ROW SECURITY	Specifies the table is created with row security support.	CREATE TABLE
CREATE USER	Assigns the security label and audit categories, the collect history, concurrent session, and access time attributes to the user object.	CREATE USER
DROP CATEGORY	Removes the category from the label security configuration.	DROP CATEGORY
DROP COHORT	Removes the cohort from the label security configuration.	DROP COHORT
DROP HISTORY CONFIGURATION	Drop the configuration for query or audit history logging.	DROP HISTORY CONFIGURATION
DROP SECURITY LEVEL	Removes a security level from the label security configuration.	DROP SECURITY LEVEL
EXECUTE AS...	Allows a suitably privileged user to set the CURRENT USER of their session to a different user.	EXECUTE AS
REVERT	Reverses the action of the last EXECUTE AS statement.	REVERT
SET HISTORY CONFIGURATION	Sets the current history configuration to the named configuration.	SET HISTORY CONFIGURATION
SHOW CATEGORY	Displays one or more categories.	SHOW CATEGORY
SHOW COHORT	Displays one or more cohorts or the cohort hierarchy.	SHOW COHORT
SHOW HISTORY CONFIGURATION	Displays the query or audit history configuration settings.	SHOW HISTORY CONFIGURATION
SHOW SECURITY LEVEL	Displays one or all security levels.	SHOW SECURITY LEVEL