Normal syntax for LOB fields: Difference between revisions

From m204wiki
Jump to navigation Jump to search
mNo edit summary
 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
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.
Starting with version 7.5 of Model 204, most "normal field reference syntax" can be used to access <var>BLOB</var> and <var>CLOB</var> fields.


For example:
For example:
Line 6: Line 6:
begin
begin
store record
store record
   LONGSTUFF = 'How now, brown cow?')
   LONGSTUFF = 'How now, brown cow?'
end store
end store
fr
fr
Line 16: Line 16:
In this request, notice how the LOB field is updated directly (in the <var>Store Record</var> block) and retrieved directly (in the <var>Print</var> statement).  In general, references to LOB fields can be made in this direct fashion, without utilizing the Universal Buffer.
In this request, notice how the LOB field is updated directly (in the <var>Store Record</var> block) and retrieved directly (in the <var>Print</var> 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 only construct which does not allow such direct reference to the value of a LOB field is the <var>[[Note statement|Note]]</var> statement.
<ul>
 
<li>The <var>Note</var> statement
This feature is disabled by setting the <var>[[LSTRLOB parameter|LSTRLOB]]</var> system parameter to 0 (the default is 1). The [[LSTRLOB parameter#Description|LSTRLOB description]] also illustrates examples of "normal field reference syntax."
<!-- need to research .. references to SIRLSAV, e.g., preclucing Note is done in CMPJ. -->
 
</ul>
==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]]
[[Category:User Language syntax enhancements]]

Latest revision as of 19:35, 20 July 2018

Starting with version 7.5 of Model 204, most "normal field reference 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.

The only construct which does not allow such direct reference to the value of a LOB field is the Note statement.

This feature is disabled by setting the LSTRLOB system parameter to 0 (the default is 1). The LSTRLOB description also illustrates examples of "normal field reference syntax."

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: