Sybase ADAPTIVE SERVER IQ 12.4.0 Manual de usuario descargar pdf (Pagina 33)

Adaptive Server IQ 12.4.0 String function REPEAT is supported

Release Bulletin for Digital UNIX 33

{ SELECT * FROM CUSTOMERS }

Note This syntax is not currently supported on Digital UNIX.

9.4.8 String function REPEAT is supported

The string function REPEAT is supported in Adaptive Server IQ version 12.x.

It is documented as follows:

REPEAT function

[String]

Function

Returns a string composed of integer-expression instances of string-

expression, concatenated together.

Syntax

REPEAT ( string-expression, numeric-expression )

Parameters

string-expression The string-expression to be repeated.

integer-expression The 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

1 2 ... 28 29 30 31 32 33 34 35 36 37 38 ... 51 52

Sin comentarios

Sybase ADAPTIVE SERVER IQ 12.4.0 Manual de usuario Pagina 33