Normal syntax for LOB fields - Revision history

JAL: /* Access to LOB fields prior to Model 204 version 7.5 */ add link

2018-07-20T19:35:03Z

Access to LOB fields prior to Model 204 version 7.5: add link

← Older revision		Revision as of 19:35, 20 July 2018
Line 26:		Line 26:
	* [[Janus Sockets]]		* [[Janus Sockets]]
	* [[Janus Web Server]]		* [[Janus Web Server]]
	* Sirius Functions		* [[Sirius Functions]]

	[[Category:User Language syntax enhancements]]		[[Category:User Language syntax enhancements]]

JAL: misc cleanup

2015-03-26T16:12:56Z

misc cleanup

← Older revision		Revision as of 16:12, 26 March 2015
Line 18:		Line 18:
	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.		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.

	This feature is disabled by setting the <var>[[LSTRLOB parameter\|LSTRLOB]]</var> system parameter to 0 (the default is 1). The ~~<var>~~[[LSTRLOB parameter#Description\|LSTRLOB description]]~~</var>~~ also illustrates examples of "normal field reference syntax".		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."

	==Access to LOB fields prior to Model 204 version 7.5==		==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:
	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]]
	* ''Fast/Unload User Language Interface''		* [[Janus SOAP]]
	*'' Janus SOAP''		* [[Janus Sockets]]
	* ''Janus Sockets''		* [[Janus Web Server]]
	* ''Janus Web Server''		* Sirius Functions
	* ''Sirius Functions''

	[[Category:User Language syntax enhancements]]		[[Category:User Language syntax enhancements]]

Dme at 00:10, 26 March 2015

2015-03-26T00:10:41Z

← Older revision		Revision as of 00:10, 26 March 2015
Line 1:		Line 1:
	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.		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 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
	~~<!-- need to research .~~. ~~references to SIRLSAV, e.g., precluding Note is done in CMPJ. -->~~
	~~</ul>~~

	This feature is disabled by setting the <var>LSTRLOB</var> system parameter to 0 (the default is 1). ~~See the~~ <var>[[LSTRLOB parameter#Description\|LSTRLOB]]</var> ~~description for further details~~.		This feature is disabled by setting the <var>[[LSTRLOB parameter\|LSTRLOB]]</var> system parameter to 0 (the default is 1). The <var>[[LSTRLOB parameter#Description\|LSTRLOB description]]</var> also illustrates examples of "normal field reference syntax".
	==Access to LOB fields prior to Model 204 version 7.5==		==Access to LOB fields prior to Model 204 version 7.5==

ELowell at 22:15, 25 March 2015

2015-03-25T22:15:14Z

← Older revision		Revision as of 22:15, 25 March 2015
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:

ELowell: /* Access to LOB fields prior to Model 204 version 7.5 */

2015-03-25T22:11:47Z

Access to LOB fields prior to Model 204 version 7.5

← Older revision		Revision as of 22:11, 25 March 2015
Line 25:		Line 25:
	==Access to LOB fields prior to Model 204 version 7.5==		==Access to LOB fields prior to Model 204 version 7.5==

	Prior to version 7.5 of Model 204, ~~using normal syntax for~~ LOB fields required the Sirius Mods, with one of the following products:		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''		* ''Fast/Unload User Language Interface''
	*'' Janus SOAP''		*'' Janus SOAP''

ELowell: /* Authorizing products */

2015-03-25T22:07:07Z

Authorizing products

← Older revision		Revision as of 22:07, 25 March 2015
Line 23:		Line 23:

	This feature is disabled by setting the <var>LSTRLOB</var> system parameter to 0 (the default is 1). See the <var>[[LSTRLOB parameter#Description\|LSTRLOB]]</var> description for further details.		This feature is disabled by setting the <var>LSTRLOB</var> system parameter to 0 (the default is 1). See the <var>[[LSTRLOB parameter#Description\|LSTRLOB]]</var> description for further details.
	==~~Authorizing products~~==		==Access to LOB fields prior to Model 204 version 7.5==

	~~Normal~~ syntax for LOB fields ~~is available to any customer who owns any~~ of the following products:		Prior to version 7.5 of Model 204, using normal syntax for LOB fields required the Sirius Mods, with one of the following products:
	* ''Fast/Unload User Language Interface''		* ''Fast/Unload User Language Interface''
	*'' Janus SOAP''		*'' Janus SOAP''

ELowell at 20:59, 7 April 2014

2014-04-07T20:59:37Z

← Older revision		Revision as of 20:59, 7 April 2014
Line 1:		Line 1:
	~~Starting with version V7R2 of <var class="product">Model 204</var>, the~~ <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.		<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>.

	For example:		For example:

Admin at 15:41, 17 January 2013

2013-01-17T15:41:42Z

← Older revision		Revision as of 15:41, 17 January 2013
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

Dme at 19:07, 22 June 2012

2012-06-22T19:07:03Z

← Older revision		Revision as of 19:07, 22 June 2012
Line 19:		Line 19:
	<ul>		<ul>
	<li>The <var>Note</var> statement		<li>The <var>Note</var> statement
	<!-- need to research .. references to SIRLSAV, e.g., ~~preclucing~~ Note is done in CMPJ. -->		<!-- need to research .. references to SIRLSAV, e.g., precluding Note is done in CMPJ. -->
	</ul>		</ul>

			This feature is disabled by setting the <var>LSTRLOB</var> system parameter to 0 (the default is 1). See the <var>[[LSTRLOB parameter#Description\|LSTRLOB]]</var> description for further details.
	==Authorizing products==		==Authorizing products==

Dme at 03:22, 22 May 2012

2012-05-22T03:22:22Z

← Older revision		Revision as of 03:22, 22 May 2012
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 V7R2 of <var class="product">Model 204</var>, the <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.

	For example:		For example: