I have requirement to create a fixed flat file with hexadecimal representation only for few of the columns.
Is that possible with sequential file stage, if so could you please tell me the properties to set to acheive this ?. If not what stage I should use to acheive this?
Please help, if anyone has faced this situation before.
Create Fixed Flat file with hexadecimal values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the sequential file stage, use the Out_format or C_format options for the column(s) you wish to output in hex format, providing an appropriate C-style format string. Here's a list if you're not familiar with them.
I would recommend either %x or %X to begin with, and you can adjust them from there to get the exact format you like.
Regards,
I would recommend either %x or %X to begin with, and you can adjust them from there to get the exact format you like.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Assuming you're in an SMP architecture the BASIC Transformer stage will execute in parallel.
James's suggestion of using a %x mask is also worth considering. By that means you can allot multiple readers per node.
James's suggestion of using a %x mask is also worth considering. By that means you can allot multiple readers per node.
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.
Just to help avoid confusion for the OP: my suggestion is implemented in the target sequential file stage, where the multiple readers per node option is not available (it's active only when seqfile is used as a source).
Regards,
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.