If you are experiencing problems with character data being returned as binary data from DB2 for i, try inserting the CCSID for your character set in the Binary CCSID field. This field instructs StarSQL to treat binary data as character data using the specified CCSID.
For the complete list of supported CCSIDs, refer to the "StarSQL Character Conversion and National Language Support" document in the StarSQL technical documents of the StarQuest Web site.