reading a field from an os/400 journal file
Posted on 2006-05-10
I have a journal file called mylog with a field called joesd that contains user-defined character data on an iSeries box running OS400 V5R3.
I am using the following command to write the journal to a physical file:
If I view the output file using the wrkdbf command, the joesd field displays all the data that was written to it (however, it is just one long string of text, which is how the journal records it). However, when I run an SQL command against it or try to view it in iSeries Navigator, the data shows up as a string of (hex?) characters (maybe in ebcdic?) like this:
Is there any way to convert this data to ascii chars on the fly with sql or another method I need to use. All help appreciated.