Normal syntax for LOB fields: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
<var class="product">Sirius Mods</var> with [[Longstrings]] support allows use of most "normal" <var class="product">User Language</var> syntax to access <var>BLOB</var> and <var>CLOB</var> fields. This feature is generally available as of version V7R5 of <var class="product">Model 204</var>.
Starting with version 7.5 of Model 204, 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 22:15, 25 March 2015

Starting with version 7.5 of Model 204, 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

This feature is disabled by setting the LSTRLOB system parameter to 0 (the default is 1). See the LSTRLOB description for further details.

Access to LOB fields prior to Model 204 version 7.5

Prior to version 7.5 of Model 204, access to LOB fields required the Sirius Mods, with one of the following products:

  • Fast/Unload User Language Interface
  • Janus SOAP
  • Janus Sockets
  • Janus Web Server
  • Sirius Functions
Retrieved from "https://m204wiki.rocketsoftware.com/index.php?title=Normal_syntax_for_LOB_fields&oldid=76699"