How to find size used for the storage of BLOB or CLOB variable
lobsize returns the size (in bytes) used for the storage of BLOB or CLOB variable. Syntax: lobsize(BLOB_CLOB) Example: # How much space spent for a clob? Local Clbfile MY_CLOB(0) MY_SIZE=lobsize(MY_CLOB) : # Returns 1016 (stores 508 characters) My_CLOB=string$(50,space$(10))+space$(9) : # Assign a 509 character string MY_SIZE=lobsize(MY_CLOB) : # Returns 66550 (MY_CLOB has been automatically enlarged)… Read More »