TS_INT_ARRAY Function [Scalar]

Syntax

TS_INT_ARRAY(int1, int2, int3, int4, [ … [ ,  int10] …] ])

Licensing prerequisites

Available only with RAP – The Trading Edition Enterprise.

Parameters

• int1 ... int10 – a set of constant integer values. If the model parameter of TS_AUTO_ARIMA is specified, then supply four integers. Ten integers is the maximum value for the set.
  Note: Integer values are required. Passing noninteger values to the function may cause unexpected results.

Usage

Returns a varbinary value that encodes the specified integer input elements as a logical array of values.

IMSL mapping

If you supply four integers and pass the result to TS_AUTO_ARIMA or TS_AUTO_ARIMA_OUTLIER, then TS_INT_ARRAY maps to method 3 of the (IMSLS_METHOD, int method) input argument of imsls_d_auto_arima in the IMSL libraries.

Example

See the example for TS_AUTO_ARIMA.

Standards and compatibility

• SQL – ISO/ANSI SQL compliant
• Sybase – not compatible with SQL Anywhere or Adaptive Server Enterprise

See also