SQLCNVER parameter: Difference between revisions
Jump to navigation
Jump to search
| (4 intermediate revisions by the same user not shown) | |||
| 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_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> | ||
<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> | ||
</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]] | ||
Latest revision as of 12:11, 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:
| Setting | Meaning |
|---|---|
| 0 | Stop 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.