DSXchange

Hi -

There is a mainframe file that we copied over to our unix server (using binary mode). When trying to read the file in datastage, some columns show as special characters.
When we asked our source about it, they said these columns are defined as hex on their side.

For eg: they see the value of the field as X'30' whereas we see the value as some weird special characters which when copied to ultraedit seems like [SUB] or [STX] or [BS].

Not sure if there is some property that we can define when reading the file to fix this or there is some issue when copying the file over to unix.

Other information:
1) We are reading the file via Complex flat file stage.
2) The properties set are:
-Big-Endian as the byte order
-EBCDIC as character set
-Binary as the data format
-And "Allow all zeroes"
3) All other columns, except for the few that the source considers as hex are being read fine.
4) This field is being read as PIC X(1) as per the copy code sent to us by the source.
5) We tried changing the field value as PIC S9(1) COMP-3 but it gave an import error.

Please advise how we can fix this and thanks in advance!!!

COMP-3 is packed decimal, which you don't have there. Try it with COMP.

Mike