SETLOB |
Setlob is used to assign a clob to a character variable sized and vice versa.
Setlobexp_name1 With exp_name2
|
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. |
# 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)
"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.
|
Error |
Description |
|
|
|
|
|