Element "UpdateCLOBFieldProcess"

UpdateCLOBFieldProcess should be used inside a process form. It is used to load big amount of text data into the CLOB type fields of the tables.

Parameters

Connection Name (Accept MScript)

The name of the JDBC connection defined with RelDBConnection element in the Global Definitions page.

Query (SQL) (Accept MScript)

This property should include a query to select the  records whose CLOB type fields to be updated. All the primary key fields and the CLOB fields to be updated need to be selected to include them in the result set.

Example:

SELECT PRODUCT_DESCRIPTION FROM PRODUCT WHERE ID = @vof(ID) FOR UPDATE
In this example ID field is chosen since in is the primary key and PRODUCT_DESCRIPTION fields are chosen since ID is the primary key and PRODUCT_DESCRIPTION is the column to be updated.

CLOB Assignments (Accept MScript)

This property can be given one or more CLOB field assignments by defining each one on a separate line.

The syntax for each line:

CLOB_FIELD_NAME = MSCRIPT_SYMBOL_NAME

CLOB_FIELD_NAME 

The name of a BLOB field that exists in the result set.

MSCRIPT_SYMBOL_NAME 

The name of the MScript symbol that contains the text to transfer to the CLOB field.
Example:

PRODUCT_DESCRIPTION = f:PROD_DESC