ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

How to determine what type of data is in the field

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to determine what type of data is in the field

    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?

  • #2
    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.

    Comment


    • #3
      Another option, using SQl, is to use the HEX function, to watch the hexadecimal value of the field.

      Comment

      Working...
      X