Whenever possible, CONNX does an implicit data conversion when it encounters data that is not represented as the type required.  For example, if a character field is being returned as a number the value 'ABC123' will be automatically converted to 123.  The value 'ABC' as a number however, has no meaning and a 0 will be returned.

 

In some situations, the preferred behavior would be to return an error rather than a 0.  When set to 1, STRICTCONVERSIONRULES will cause an error to be returned when the conversion is not valid.

 

To set the STRICTCONVERSIONRULES parameter, set the following value:

 

STRICTCONVERSIONRULES = 1
 
Default = 0

 

 

Environment: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  STRICTCONVERSIONRULES

Unix Registry Setting: CONNX.STRICTCONVERSIONRULES