SQLCNVER parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
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&nbsp;204</var> file data that the <var class="product">Model&nbsp;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&nbsp;204</var> file data that the <var class="product">Model&nbsp;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>

Revision as of 10:38, 7 September 2017

SQL fetch option

Summary

Default value
0
Parameter type
User
Where set
On User 0's or on user's parameter line, or reset by user
Related products
All
Introduced
Model 204 V3.1

Description

The processing procedure the SQL Server follows when it finds dirty data during an SQL retrieval or update

Dirty data is Model 204 file data that the Model 204 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:

SettingMeaning
0Stop processing the SQL request and return a negative SQL code if dirty data is encountered.
1 Skip any row with dirty data and continue processing the SQL request. Include a warning message with returned data.

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 Model 204 file, field, and record number of the record with the dirty data.