SQLCNVER parameter - Revision history

DCameron: /* Description */

2017-09-07T12:11:40Z

Description

← Older revision		Revision as of 12:11, 7 September 2017
Line 23:		Line 23:
	</table>		</table>
	</p>		</p>
	<p>Regardless of the SQLCNVER setting, the SQL Server writes a message to the audit trail whenever dirty data is encountered during an SQL retrieval or update. The message (number 1296) lists the <var class="product">Model 204</var> file, field, and record number of the record with the dirty data.</p>		<p>Regardless of the SQLCNVER setting, the SQL Server writes a message to the [[Tracking_system_activity_(CCAJRNL,_CCAAUDIT,_CCAJLOG)#CCAAUDIT_and_CCAJLOG\|audit trail]] whenever dirty data is encountered during an SQL retrieval or update. The message (number 1296) lists the <var class="product">Model 204</var> file, field, and record number of the record with the dirty data.</p>
	[[Category:User parameters]]		[[Category:User parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

DCameron: /* Description */

2017-09-07T10:44:14Z

Description

← Older revision		Revision as of 10:44, 7 September 2017
Line 19:		Line 19:
	<table>		<table>
	<tr><th><var>Setting</var></th><td>Meaning</td></tr>		<tr><th><var>Setting</var></th><td>Meaning</td></tr>
	<tr><th align="right"><var> 0</var></th><td>Stop processing the SQL request and return a negative SQL code if dirty data is encountered. </td></tr>		<tr><th align="right"><var> 0</var></th><td>Stop processing the SQL request and return a [[Connect*_messages#Messages_beginning_with_a_minus_.28-.29_sign\|negative SQL code]] if dirty data is encountered. </td></tr>
	<tr><th align="right"><var> 1 </var></th><td>Skip any row with dirty data and continue processing the SQL request. Include a warning message with returned data. </td></tr>		<tr><th align="right"><var> 1 </var></th><td>Skip any row with dirty data and continue processing the SQL request. Include a warning message with returned data. </td></tr>
	</table>		</table>

DCameron: /* Description */

2017-09-07T10:38:08Z

Description

← Older revision		Revision as of 10:38, 7 September 2017
Line 16:		Line 16:
	==Description==		==Description==
	<p>The processing procedure the [[SQL_Server_overview\|SQL Server]] follows when it finds dirty data during an SQL retrieval or update</p>		<p>The processing procedure the [[SQL_Server_overview\|SQL Server]] follows when it finds dirty data during an SQL retrieval or update</p>
	<p><b><var>Dirty data</var></b> is <var class="product">Model 204</var> file data that the <var class="product">Model 204</var> SQL Server cannot convert to the [[SQL_representation_of_Model_204_data\|SQL data type]] you specify. The SQLCNVER parameter tells the SQL Server what to do if it finds dirty data during an SQL retrieval or update. SQLCNVER, specified with the User 0 parameters or on the first IODEV line, has two settings:		<p><b><var>Dirty data</var></b> is <var class="product">Model 204</var> file data that the <var class="product">Model 204</var> SQL Server cannot convert to the [[SQL_representation_of_Model_204_data\|SQL data type]] you specify. The SQLCNVER parameter tells the SQL Server what to do if it finds dirty data during an SQL retrieval or update. SQLCNVER, specified with the User 0 parameters or on the first <var>[[IODEV_parameter\|IODEV]]</var> line, has two settings:
	<table>		<table>
	<tr><th><var>Setting</var></th><td>Meaning</td></tr>		<tr><th><var>Setting</var></th><td>Meaning</td></tr>

DCameron: /* Description */

2017-09-07T10:37:11Z

Description

← Older revision		Revision as of 10:37, 7 September 2017
Line 16:		Line 16:
	==Description==		==Description==
	<p>The processing procedure the [[SQL_Server_overview\|SQL Server]] follows when it finds dirty data during an SQL retrieval or update</p>		<p>The processing procedure the [[SQL_Server_overview\|SQL Server]] follows when it finds dirty data during an SQL retrieval or update</p>
	<p><b><var>Dirty data</var></b> is <var class="product">Model 204</var> file data that the <var class="product">Model 204</var> SQL Server cannot convert to the SQL data type you specify. The SQLCNVER parameter tells the SQL Server what to do if it finds dirty data during an SQL retrieval or update. SQLCNVER, specified with the User 0 parameters or on the first IODEV line, has two settings:		<p><b><var>Dirty data</var></b> is <var class="product">Model 204</var> file data that the <var class="product">Model 204</var> SQL Server cannot convert to the [[SQL_representation_of_Model_204_data\|SQL data type]] you specify. The SQLCNVER parameter tells the SQL Server what to do if it finds dirty data during an SQL retrieval or update. SQLCNVER, specified with the User 0 parameters or on the first IODEV line, has two settings:
	<table>		<table>
	<tr><th><var>Setting</var></th><td>Meaning</td></tr>		<tr><th><var>Setting</var></th><td>Meaning</td></tr>

DCameron: /* Description */

2017-09-07T10:35:33Z

Description

← Older revision		Revision as of 10:35, 7 September 2017
Line 15:		Line 15:

	==Description==		==Description==
	<p>The processing procedure the SQL Server follows when it finds dirty data during an SQL retrieval or update</p>		<p>The processing procedure the [[SQL_Server_overview\|SQL Server]] follows when it finds dirty data during an SQL retrieval or update</p>
	<p><b><var>Dirty data</var></b> is <var class="product">Model 204</var> file data that the <var class="product">Model 204</var> SQL Server cannot convert to the SQL data type you specify. The SQLCNVER parameter tells the SQL Server what to do if it finds dirty data during an SQL retrieval or update. SQLCNVER, specified with the User 0 parameters or on the first IODEV line, has two settings:		<p><b><var>Dirty data</var></b> is <var class="product">Model 204</var> file data that the <var class="product">Model 204</var> SQL Server cannot convert to the SQL data type you specify. The SQLCNVER parameter tells the SQL Server what to do if it finds dirty data during an SQL retrieval or update. SQLCNVER, specified with the User 0 parameters or on the first IODEV line, has two settings:
	<table>		<table>

DCameron: /* Summary */

2017-09-07T10:32:14Z

Summary

← Older revision		Revision as of 10:32, 7 September 2017
Line 7:		Line 7:
	<dd>User		<dd>User
	<dt>Where set		<dt>Where set
	<dd>On User 0's or on user's parameter line		<dd>On User 0's or on user's parameter line, or reset by user
	<dt>Related products		<dt>Related products
	<dd>All		<dd>All

DCameron: /* Summary */

2017-09-07T10:28:46Z

Summary

← Older revision		Revision as of 10:28, 7 September 2017
Line 11:		Line 11:
	<dd>All		<dd>All
	<dt>Introduced		<dt>Introduced
	<dd><var class="product">Model 204 V6.1</var> ~~or earlier~~		<dd><var class="product">Model 204 V3.1</var>
	</dl>		</dl>

	==Description==		==Description==
	<p>The processing procedure the SQL Server follows when it finds dirty data during an SQL retrieval or update</p>		<p>The processing procedure the SQL Server follows when it finds dirty data during an SQL retrieval or update</p>

DmeWiccan: Automatically generated page update

2013-08-27T16:44:03Z

Automatically generated page update

← Older revision		Revision as of 16:44, 27 August 2013
Line 1:		Line 1:
			{{Template:SQLCNVER parameter subtitle}}
	==Summary==		==Summary==
	<dl>		<dl>

DmeWiccan: Automatically generated page update

2013-04-23T02:06:14Z

Automatically generated page update

← Older revision		Revision as of 02:06, 23 April 2013
Line 22:		Line 22:
	</p>		</p>
	<p>Regardless of the SQLCNVER setting, the SQL Server writes a message to the audit trail whenever dirty data is encountered during an SQL retrieval or update. The message (number 1296) lists the <var class="product">Model 204</var> file, field, and record number of the record with the dirty data.</p>		<p>Regardless of the SQLCNVER setting, the SQL Server writes a message to the audit trail whenever dirty data is encountered during an SQL retrieval or update. The message (number 1296) lists the <var class="product">Model 204</var> file, field, and record number of the record with the dirty data.</p>
	[[Category:User ~~Parameters~~]]		[[Category:User parameters]]
	[[Category:Parameters]]		[[Category:Parameters]]

Alex: Automatically generated page update

2013-02-28T00:56:57Z

Automatically generated page update

New page

==Summary==
<dl>
<dt>Default value
<dd>0
<dt>Parameter type
<dd>User
<dt>Where set
<dd>On User 0's or on user's parameter line
<dt>Related products
<dd>All
<dt>Introduced
<dd><var class="product">Model 204 V6.1</var> or earlier
</dl>
==Description==
<p>The processing procedure the SQL Server follows when it finds dirty data during an SQL retrieval or update</p>
<p><b><var>Dirty data</var></b> is <var class="product">Model 204</var> file data that the <var class="product">Model 204</var> SQL Server cannot convert to the SQL data type you specify. The SQLCNVER parameter tells the SQL Server what to do if it finds dirty data during an SQL retrieval or update. SQLCNVER, specified with the User 0 parameters or on the first IODEV line, has two settings:
<table>
<tr><th><var>Setting</var></th><td>Meaning</td></tr>
<tr><th align="right"><var> 0</var></th><td>Stop processing the SQL request and return a negative SQL code if dirty data is encountered. </td></tr>
<tr><th align="right"><var> 1 </var></th><td>Skip any row with dirty data and continue processing the SQL request. Include a warning message with returned data. </td></tr>
</table>
</p>
<p>Regardless of the SQLCNVER setting, the SQL Server writes a message to the audit trail whenever dirty data is encountered during an SQL retrieval or update. The message (number 1296) lists the <var class="product">Model 204</var> file, field, and record number of the record with the dirty data.</p>
[[Category:User Parameters]]
[[Category:Parameters]]