Sybase IQ 12.4.0 String function Repeat is supported, Correction to Char function

Adaptive Server IQ 12.4.0 String function REPEAT is supported

{ SELECT * FROM CUSTOMERS }

Note This syntax is not currently supported on Digital UNIX.

9.4.8 String function REPEAT is supported

REPEAT function [String]

The string function REPEAT is supported in Adaptive Server IQ version 12.x. It is documented as follows:

Function

Returns a string composed of integer-expression instances of string- expression, concatenated together.

Syntax

REPEAT ( string-expression, numeric-expression )

Parameters

string-expressionThe string-expression to be repeated.

integer-expressionThe number of times the string-expression will be repeated.

Examples

The statement

SELECT REPEAT( ’repeat’, 3 )

returns the value repeatrepeatrepeat.

Standards and compatibility

SQL/92 Vendor extension.

Sybase REPEAT is not supported in Adaptive Server Enterprise, but

REPLICATE provides the same capabilities.

9.4.9 Correction to CHAR function

The Adaptive Server IQ Reference Manual incorrectly lists the CHAR function as accepting a string-expr argument. The correct syntax is

CHAR ( integer-expr )

9.4.10 Number(*) function not supported

Release Bulletin for Digital UNIX 33