SETLOB

Summary


Setlob is used to assign a clob to a character variable sized and vice versa. 

Syntax

Setlobexp_name1 With exp_name2

Parameters

Element

Description

Restrictions

exp_name1

Expression of the type Char where the result is the name of a variable.

The variable must exist.

exp_name2

Expression of the type Char where the result is the name of a variable.

The variable must exist.

Examples

# All the lines for the variable TEXT by the contents of the clob  
Local Char TEXT (250)(1..100)
Setlob
TEXT With [M:XXX]CLOB

# All the line 2 for the variable TEXT by the contents of the clob  
Local Char TEXT (250)(1..100)
Setlob
TEXT (2) With [M:XXX]CLOB


# recovery of the text (all the lines) from the clob ( in UCS2 ) in the TEXT variable.
Local Char TEXT (250)(1..100)
Setlob
[M:XXX]CLOB With TEXT(1..100)

Description and comments

"Setlob " is used to assign a variable (previously declared)  for a clob text or vice versa.

The first parameter describes the element that will be loaded.

The second parameter describes the element that will serve for the loading of the first parameter.

These two parameters can be dimensioned variables. If the dimension of these variables is not specified, all the grid is taken into account. For the first parameter, there is the possibility to taken into account the whole of the grid (by specifying nothing) or a line.
For the second parameter, there is the possibility to take into account all the grid ( by specifying nothing or by specifying the start and end range) or one or several lines.

# this syntax is prohibited ( warning ! only the first line is loaded ) 
Local Char TEXT (250)(1..100)
Setlob
TEXT(1..100) With [M:XXX]CLOB

When a variable is loaded by a clob containing a rich text, the text and attributes are copied into the variable.

Associated errors

Error

Description

 

 

Associated keywords

CLBFILE 


SUMMARY


Copyright © Sage 1999 - 2007