SQL_ADD_LOB_CHUNK_UC¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to add additional chunks to the buffer before saving the record. After SQL_SET_LOB_UC has been called SQL_ADD_LOB_CHUNK_UC can be called as many times as needed to add additional chunks of data before a save. It can also be called independent of SQL_SET_LOB_UC to append data to an existing LOB column. NOTE: Unlike the previous call LOB_APPEND, this call does not perform the save. This must be done separately.

Syntax

SQL_ADD_LOB_CHUNK_UC {FileName.FieldName} to {variable}

Parameter	Description
FileName	The name of the file containing the LOB field
FieldName	The name of the LOB field being set
variable	The variable to add as the LOB chunk. Must be a uChar[]

Example

uChar[] ucData

Clear Customer
   Move iID to Customer.ID
Find Eq Customer by Index.1
If (Found) Begin
   Direct_Input "C:\bigFile.xml"
   Reread Customer
      set_channel_position 0 to -1
      get_channel_position 0 to iSize
      Read_Block ucData iSize
      SQL_ADD_LOB_CHUNK_UC Customer.Comments to ucData
   Saverecord Customer
   Unlock
   Close_Input
End