I have a file that is causing a data decimal error. The SQL job log says the data is in the field is invalid and when I run a query it shows up as a bunch of + signs on the AS400 or a - if I run the query in the iAccess Run SQL Script function. The record shows up if I make a test of FIELD IS NOT NULL. Is there a way to find out what the data in the field is if it is not null?
Announcement
Collapse
No announcement yet.
How to determine what type of data is in the field
Collapse
X
-
Just guessing, but I would suspect that the field with the problem is numeric. you could do a DSPFFD to see what the layout is, and then do a DSPPFM on that file/member and put it into hex mode on the suspected record to find the field with problems. You need the data in the field to be in the expected format or you will get errors.
- Likes 1
Comment