I'm currently trying to put a value of a field from a table into a variable. I'm using -READ, but it doesn't seem to be working.

TABLE FILE SF2BANNER
BY HIGHEST 1 RUN_NUMBER
ON TABLE HOLD AS HIGHEST_RUN
END
-RUN
-READ HIGHEST_RUN, &HIGHEST_RUN.I4.
  

When checking the -TYPE of the variable, I'm receiving nothing. I decided to try it with another field from another table. The value that should be populating the variable should be 9904, but instead I get "°&" as the value when checking the type.

This message has been edited. Last edited by: ccollier,

Try this instead, you have a format error which READFILE manage automatically

TABLE FILE SF2BANNER
BY HIGHEST 1 RUN_NUMBER
ON TABLE HOLD AS HIGHEST_RUN
END
-RUN
-READFILE HIGHEST_RUN
-RUN
-TYPE &RUN_NUMBER

After first setting a default to &RUN_NUMBER that seemed to work Martin. Thanks!

READFILE FTW!!

BTW, the underlying issue is probably that the file is binary.

Changing the format of the hold to ALPHA will fix the issue.

Also, I prefer -READFILE as well.