Warehouse Release 2.08.0090

10/17/2003

The features in the 2.08.0090 release are:


Oracle COPY hint : added an append hint for COPY statements to an Oracle target. The syntax is:

COPY rec TO db-tag.target-table (HINT APPEND)

Using the append hint adds the APPEND hint to the Oracle INSERT statement used to copy the data and may increase
the performance when writing to an Oracle table. See the Oracle SQL Reference Manual for more information.

NNOT : added an NNOT unary operator. The NNOT operator does a logical NOT on a boolean expression and is the same as NOT except that NNOT returns true for a null operand. Example:

Given these definitions
DEFINE A : ODBC CHAR(10) ALLOW NULLS VALUE "A"
DEFINE B : ODBC CHAR(10) ALLOW NULLS VALUE "B"
DEFINE N : ODBC CHAR(10) ALLOW NULLS VALUE $NULL

The results are:

Expression      Value
NNOT (A < B)  False
NNOT (A < N)  True
NOT (A < B)    False
NOT (A < N)    Unknown

TOKEN function:  TOKEN function has been added that parses a string and returns the Nth token within the string. The syntax is:

token = TOKEN(source-string, token-number, "delimiters-flags")

source-string is the string to be parsed.

token-number is the token number to be returned with 1 being the first token in the string. If token number is less than 1 or greater than the number of tokens in source-string a string of zero length is returned.

delimiters-flags is a constant string enclosed in quotation marks that indicate the parsing delimiters and flags. The delimiters may be any special characters such as comma, colon, semicolon and space. In addition to special characters the S and Q flags are available.

S flag - Indicates that leading a trailing spaces are stripped from the token.
Q flag - Indicates that tokens may be  enclosed in quotation marks.

Examples:
A = 'one;two,"three,four";five, six , seven,'
B = ' alpha beta|gamma delta'

Expression            Result
TOKEN(A, 1, ",")    one;two
TOKEN(A, 1, ";")    one
TOKEN(A, 2, ";")    two,"three,four"
TOKEN(A, 2, ",q")   three,four
TOKEN(A, 2, ",;")   two
TOKEN(A, 4, ",;")   four"
TOKEN(A, 4, ",;q")  five
TOKEN(A, 5, ",;q")  six
TOKEN(A, 5, ",;qs") six
TOKEN(B, 1, " ")
TOKEN(B, 1, " s")    alpha
TOKEN(B, 3, " s")    delta
TOKEN(B, 3, " |s")   gamma


Release 2.08.0090 is available now on all supported platforms.