Record retrievals - Revision history

JAL: mixed case for statements

2018-05-11T19:32:37Z

mixed case for statements

2018-01-23T18:57:56Z

Or character

← Older revision		Revision as of 18:57, 23 January 2018
Line 989:		Line 989:
	</tr>		</tr>
	</table>		</table>
	<blockquote class="note"><b>Note:</b> The following type of pattern is illegal:		<blockquote class="note"><b>Note:</b> The following type of pattern is illegal:
			<!-- The following example is used in QASHR tests SOUL.DME.263.QAR: -->
	<p class="code">/A,B(XYZ) </p>		<p class="code">/A,B(XYZ) </p>
	</blockquote>		</blockquote>

2018-01-23T15:33:57Z

Or character

← Older revision		Revision as of 15:33, 23 January 2018
Line 975:		Line 975:
	</table>		</table>

	====Or character====		====<b id="patOr"></b>Or character====
	<p>		<p>
	The Or character (a comma) allows the choice of more than one matching value. The Or character also can be used to define a null (<tt>,,</tt>) character. The values separated by the Or character are called members of the pattern. For example:</p>		The Or character (a comma) allows the choice of more than one matching value. The Or character also can be used to define a null (<tt>,,</tt>) character. The values separated by the Or character are called members of the pattern. For example:</p>

2017-07-12T18:06:21Z

link repair

← Older revision		Revision as of 18:06, 12 July 2017
Line 1,424:		Line 1,424:
	</ul>		</ul>

	<p class="note"><b>Note:</b> Lob-name <code>NOVEL</code> in the first of these examples has a position and length parameter, which you must supply. You can extract a section of the Large Object field by supplying a position and a length within the data. If you want all the data, position is set to 1 and length is the actual size of the Large Object data obtained using <var>[[$~~LOBLEN~~]]</var>.</p>		<p class="note"><b>Note:</b> Lob-name <code>NOVEL</code> in the first of these examples has a position and length parameter, which you must supply. You can extract a section of the Large Object field by supplying a position and a length within the data. If you want all the data, position is set to 1 and length is the actual size of the Large Object data obtained using <var>[[$LobLen]]</var>.</p>

	==IS PRESENT condition==		==IS PRESENT condition==

2016-09-01T20:19:17Z

Transporting Large Object data using the Universal Buffer: add sentence

← Older revision		Revision as of 20:19, 1 September 2016
Line 1,392:		Line 1,392:
	==Transporting Large Object data using the Universal Buffer==		==Transporting Large Object data using the Universal Buffer==
	<p>		<p>
	The Universal Buffer is used to transport [[Large Object fields#BLOB.2C CLOB.2C and MINLOBE attributes\|Large Object data]] to and from a client. The following is a sample request that moves Large Object data from a client to the <var class="product">Model 204</var> server.</p>		The Universal Buffer is used to transport [[Large Object fields#BLOB.2C CLOB.2C and MINLOBE attributes\|Large Object data]] to and from a client. The Universal Buffer is a one-per-user, temporary storage area that automatically expands to accommodate its data contents.

			The following is a sample request that moves Large Object data from a client to the <var class="product">Model 204</var> server.</p>
	<ul>		<ul>
	<li>Transporting data from a client to the <var class="product">Model 204</var> server:		<li>Transporting data from a client to the <var class="product">Model 204</var> server:

2016-09-01T19:42:55Z

Transporting Large Object data using the Universal Buffer: add link

← Older revision		Revision as of 19:42, 1 September 2016
Line 1,392:		Line 1,392:
	==Transporting Large Object data using the Universal Buffer==		==Transporting Large Object data using the Universal Buffer==
	<p>		<p>
	The Universal Buffer is used to transport Large Object data to and from a client. The following is a sample request that moves Large Object data from a client to the <var class="product">Model 204</var> server.</p>		The Universal Buffer is used to transport [[Large Object fields#BLOB.2C CLOB.2C and MINLOBE attributes\|Large Object data]] to and from a client. The following is a sample request that moves Large Object data from a client to the <var class="product">Model 204</var> server.</p>
	<ul>		<ul>
	<li>Transporting data from a client to the <var class="product">Model 204</var> server:		<li>Transporting data from a client to the <var class="product">Model 204</var> server:

2015-01-23T23:06:24Z

Y2K bug

← Older revision		Revision as of 23:06, 23 January 2015
Line 1,489:		Line 1,489:
	</p>		</p>
	<p>		<p>
	The <code>GROUP1A</code> statements retrieves records for SEX = M, DATE OF BIRTH between ~~200101~~ and ~~650101~~, and STATE = CALIFORNIA. The <code>GROUP2A</code> statements retrieves records for which SEX = MALE and either STATE not equal CALIFORNIA or DATE OF BIRTH not between ~~200101~~ and ~~650101~~. </p>		The <code>GROUP1A</code> statements retrieves records for SEX = M, DATE OF BIRTH between 19200101 and 19650101, and STATE = CALIFORNIA. The <code>GROUP2A</code> statements retrieves records for which SEX = MALE and either STATE not equal CALIFORNIA or DATE OF BIRTH not between 19200101 and 19650101.</p>

	==SFL$ and SFGE$ conditions==		==SFL$ and SFGE$ conditions==

2014-12-03T21:04:34Z

rewording

← Older revision		Revision as of 21:04, 3 December 2014
Line 1,254:		Line 1,254:

	===EQ WITH retrieval condition for concatenated fields===		===EQ WITH retrieval condition for concatenated fields===
	The EQ WITH clause is available as of Model 204 version 7.5. To use the EQ WITH clause, FILEORG=x'100' ~~must be set~~.		The EQ WITH clause is available as of Model 204 version 7.5. To use the EQ WITH clause, set the <var>[[FILEORG parameter\|FILEORG]]</var> X'100' bit.

	<b>Purpose</b>		<b>Purpose</b>

2014-11-11T19:49:50Z

Retrieval conditions

← Older revision		Revision as of 19:49, 11 November 2014
Line 28:		Line 28:
	<tr>		<tr>
	<td>Pattern </td>		<td>Pattern </td>
	<td>With field values matching a specified pattern (for example, a <code>c*</code> pattern searches for all patterns beginning with the letter ''c'').</td>		<td>With field values matching a specified pattern (for example, a <code>c*</code> pattern searches for all patterns beginning with the letter "c").</td>
	</tr>		</tr>

Line 71:		Line 71:
	</tr>		</tr>
	</table>		</table>

	===Handling a foundset===		===Handling a foundset===
	<p>		<p>

2014-08-05T20:30:06Z

← Older revision		Revision as of 20:30, 5 August 2014
Line 158:		Line 158:
	If the value of the named field in a given record has the stated relation to the number in the retrieval condition, then the record is retrieved. For example, AGE IS BETWEEN 21 AND 35 does retrieve a record with the pair AGE = 27.</p>		If the value of the named field in a given record has the stated relation to the number in the retrieval condition, then the record is retrieved. For example, AGE IS BETWEEN 21 AND 35 does retrieve a record with the pair AGE = 27.</p>
	<p>		<p>
	When a numeric retrieval is performed on a multiply occurring field, all records with at least one occurrence of the field that meets the specified condition are retrieved. See [[~~Operations on~~ multiply occurring fields]] for more information about retrieval of multiply occurring fields. </p>		When a numeric retrieval is performed on a multiply occurring field, all records with at least one occurrence of the field that meets the specified condition are retrieved. See [[Processing multiply occurring fields and field groups]] for more information about retrieval of multiply occurring fields. </p>

	===NUMERIC RANGE and ORDERED NUMERIC attributes===		===NUMERIC RANGE and ORDERED NUMERIC attributes===