SQL_SET_LOB_NULL

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to set a LOB column to null. Often LOB columns should either contain data or be null. A “blank” LOB column often doesn’t appear empty in other environments, so settings it back to null is best.

Syntax

SQL_SET_LOB_NULL    {FileName.FieldName}

Parameter

Description

FileName

The name of the file containing the LOB field

FieldName

The name of the specified LOB field

Example

/
Clear Customer
Move iID to Customer.ID
Find Eq Customer by Index.1
If (Found) Begin
   Reread Customer
       SQL_SET_LOB_NULL Customer.Comments
       Saverecord Customer
   Unlock
End