How do I handle invalid numeric data in my Relativity tables? (Version 12.16 & newer)

0 Likes

Problem:

COBOL allows invalid numeric data to be stored in a numeric field.  However, since ODBC does not, invalid numeric data will cause an error to be returned when that data is encountered in a column.

Resolution:

In order to resolve the issue of invalid numeric data, you can configure Relativity to return NULLs for any encountered invalid numeric data.  This may be accomplished in the new Relativity Designer via the following steps.

1) Select and Connect to the DSN for the table you wish to modify.

2) On the Tools menu, click Options.

3) In the Options pane, click on the Catalog tab.

4) On the Invalid Numerics Return NULL row, click on the down arrow to display the choices.

5) Yes, Except for Record Key Data Items is mostly commonly chosen.  Please see the documentation link below for an explanation of the choices: 

https://www.microfocus.com/documentation/relativity/relativity1218/reldbdsn/RM%20Relativity/GUID-6810FD68-103E-450A-9D77-E15C1C267C6A.html

6) After the selection is made, the Nullable Column Utility is displayed. Check all the columns that you wish to have the selection applied to and click Apply

For a more information on this topic, please see the Relativity Designer online documentation at the link below:

https://www.microfocus.com/documentation/relativity/relativity1218/reldbdsn/RM%20Relativity/GUID-C81520ED-5FD4-4360-96F4-803F6C1E202B.html

**As a note; if you are encountering invalid numeric issues, it could be due to the presence of multiple record types in your COBOL file definitions. If that is the case, please see the following Knowledge Base article for information on that subject: How do you handle multiple record type definitions in the Relativity Designer?

Labels:

Record Types
Relativity Designer
Tip from Support
Comment List
Related
Recommended