CLBFILE

Summary


Clbfile is used to declare the variables of the type clob.

Syntax

   [ Local | Global | Extern ] Clbfile list_var_dim

Parameters

Element

Description

Restrictions

list_var_dim

List of var_dim separated by the character ','.

None.

var_dim

Name of a variable expressed in one of the following forms :
name'(' maxlen ')'
name'(' maxlen ')' '(' lis_dim ')'

None.

name

variable_name.

None

maxlen

Maximum admissible name for the clob file

Integer expression
between 0 and 20

lis_dim

List of exp_dim separated by the character ','.

Number limited to 4.

exp_dim

Integer expression representing the number of elements in the variable  (from 0 to exp_dim-1)
or
2 integer expressions separated by the 2 characters '..' representing the interval for the possible indexes for the variable

 

Examples

   # Declaration of a clob variable with default length
   Local Clbfile WWCLOB

   # Declaration of a clob variable with length 3 ( maximum 4094 characters)
   Local Clbfile WWCLOB( 3 )

   # Declaration of a grid with 2 clobs of a length 3
   Local Clbfile WWCLOB( 3 ) ( 2 )

   # Declaration of a grid with 2 clobs of a length 3
   Local Clbfile WWCLOB( 3 ) ( 0..1)

Description and comments

Clbfile is used to declare variables of the type Clob by assigning to them a maximum length. The clob type is used to store the texts with variable length in the format "rtf" or "txt".

In the case where the number of characters in the string is not given, the clob is created with a maximum length of 0.

It is necessary to specify a maximum length of the clob according to the following :

Length

memory size

Maximum characters

0

1020

510

1

2044

1022

2

4092

2046

3

8188

4094

n

1024*(2^n) -4

512*(2^n) -2

It is possible to declare a clob type grid, but in this case, keep an eye on the memory !

Associated errors

Error

Description

 

 

Associated keywords

SHORTINT - INTEGER - INTEGER - DECIMAL - CHAR - DATE - LIBELLE - BLBFILE - SETLOB - GLOBAL - LOCAL - EXTERN


SUMMARY


Copyright © Sage 1999 - 2007