Character field brought in a binary field

[bren1519]

Hi all,
I am trying to create a model in FM for some reporting.  This is based on a relational database not a data warehouse.  I've never run into this issue and have asked our in-house expert and neither has he so turning to the experts here! 
There is a field that is a 10 character field that is being brought into FM as a binary field when I run the metadata wizard.  I have checked with our iSeries guru and he has looked at the table on the iSeries and it is definitely a character field with a length of 10.  Yet when I pull the table into FM it is a binary field and as a result I get no data in that field. And to make matters worse, it is the field on which I need to join other tables.  Any suggestions?  thx Brenda

[sdf]

Can't you CAST the data item to a readable data type?

[bren1519]

I tried cast ([field] , varchar ( 10 ) ) and got an error:   XQE-GEN-0036 Unsupported datatype 'binary' for data item '[Business Model].[AM2000 Audit Data].[User ID]' .

thx