I am reading an EBCDIC file in which there is a binary field, based on the value of the binary field I will have to read different segments of the record.
I can read this field as binary from the file but in the transformer I want to write a constraint against this field to determine the segment.
eg. COL_138 has the binary value 01, how can I equate this in a constraint..
I cant do COL_138 = '01'
Please advise
Comparing Binary values in Transformer
Moderators: chulett, rschirm, roy
Comparing Binary values in Transformer
Regards,
Ganesh
Ganesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it's truly binary then you could compare it against the value of Char(01).
Tip: evaluate the Char() function once in a stage variable and compare against that value. In ASCII, Char(01) is Ctrl-A. If this doesn't work, then it's not actually a binary value that you're looking at.
Tip: evaluate the Char() function once in a stage variable and compare against that value. In ASCII, Char(01) is Ctrl-A. If this doesn't work, then it's not actually a binary value that you're looking at.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.