I have a file with some hex strings in it like the following three bytes: x'43 x'56 x'78
I want to read that into datastage within a sequential file stage using a schema file and get a string that has "435678" in it. Is that possible and if yes, how?
Background: I want to generate the schema files (the problem is more complex, I have more fileds and many files) and ComplexFlatFile stage is not really usable with schemas as far as I can see. Aprat from that I couldn't get it runnning in CFF also...
Reading binary data as string in parallel job with schema?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Tue Oct 20, 2009 8:36 am
Along the lines of a thread from earlier this week where we were discussing the Server functions ICONV/OCONV with the "MX" codes ... using this you can convert to and from hex representation in strings; but as this is a server function you would need to do this in a server job or in a BASIC transform stage in your parallel job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>