SQLCNVER parameter: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
(Automatically generated page update)
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&nbsp;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&nbsp;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]]

Revision as of 02:06, 23 April 2013

Summary

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

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.