Normal syntax for LOB fields: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Created page with "Starting with version V7R2 of <var class="product">Model 204</var>, when the <var class="product">Sirius Mods</var> with Longstrins support, most "normal" <var class="product...")
 
mNo edit summary
Line 1: Line 1:
Starting with version V7R2 of <var class="product">Model 204</var>, when the <var class="product">Sirius Mods</var> with [[Longstrins]] support, most "normal" <var class="product">User Language</var> syntax can be used to access <var>BLOB</var> and <var>CLOB</var> fields.
Starting with version V7R2 of <var class="product">Model 204</var>, when the <var class="product">Sirius Mods</var> with [[Longstrings]] support, most "normal" <var class="product">User Language</var> syntax can be used to access <var>BLOB</var> and <var>CLOB</var> fields.


For example:
For example:

Revision as of 03:07, 22 May 2012

Starting with version V7R2 of Model 204, when the Sirius Mods with Longstrings support, most "normal" User Language syntax can be used to access BLOB and CLOB fields.

For example:

DEFINE FIELD LONGSTUFF WITH BLOB ... begin store record LONGSTUFF = 'How now, brown cow?') end store fr print LONGSTUFF end for end

In this request, notice how the LOB field is updated directly (in the Store Record block) and retrieved directly (in the Print statement). In general, references to LOB fields can be made in this direct fashion, without utilizing the Universal Buffer.

There are a few exceptions to this; the following constructs do not allow such direct reference to the value of a LOB field:

  • The Note statement