SET

Overview

Removes the columns that found, or not found, in the comma-separated list of columns provided. The list of columns is case-insensitive and may include square brackets if desired. If columns are not found, no error or warning is thrown.

Syntax

Saves a value in a global variable and optionally creates it if needed. If the variable is already defined and is associated with an X.509 certificate, the new value will be encrypted. The value can be numeric or a string

SET 
	@variable = < '...' | <n> >
	{ WITH 
		{ CREATE }
		{ CONTINUE_ON_ERROR }
	}
;

CREATE	Creates the global variable if it doesn't exist in DataZen
CONTINUE_ON_ERROR	Continues processing even if errors are detected

Example 1

-- Get data from an RSS Feed
SELECT * FROM HTTP [Rss Feed] (GET /econi.xml) APPLY TX (//item);

-- Save the current date/time in a variable 
SET @lastRunDate = '#utcnow()';

MASK COLUMN 'category';

-- Save the current date/time in another variable 
-- create it if needed
SET @lastRunDate2 = '#utcnow()' WITH CREATE;