Additional LOB columns
This applies to PC Other Files when has been selected.
At file build time, additional columns will be added to your table to allow the storage of BLOB and CLOB as per LANSA files. For each BLOB or CLOB field, a filename column will be added, with the initial value of NULL. When an Insert or Update of a file is carried out by LANSA, a filename value will be stored into this column.
When reading rows back from the file, if the BLOB or CLOB is not NULL, but the filename column is NULL (as LANSA did not do the insert, and has not updated the row), a random filename will be generated. The filename will have the extension .txt for a CLOB, and .bin for a BLOB, and will be unique in its directory.
If the filename column has a value at read time, that filename will be used when creating the file. This is a useful feature when you want to know what the filename will be at read time.
Also See