Search found 5 matches
- Thu Mar 15, 2018 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: STRING to Packed hexadecimal
- Replies: 14
- Views: 5955
- Thu Mar 15, 2018 8:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: STRING to Packed hexadecimal
- Replies: 14
- Views: 5955
Thanks for assistance FranklinE. yes, I am using Import wizard to translate the COBOL copybook to CFD, Please find below CFD layout. record {record_format={type=implicit}, delim=none, quote=none, binary, big_endian, charset='UTF-8', round=round_inf, fix_zero} ( col1:string[2]; col2:string[1]; col3:s...
- Tue Mar 13, 2018 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: STRING to Packed hexadecimal
- Replies: 14
- Views: 5955
@FranklinE - no luck - getting the same results. @Franklin E and chulett - Thanks for the response. In CFF - there is no specific option to choose the column/record as 'Packed' - other than having the column itself as comp-3. and also below text from IBM's CFF documentation reveals that setting the ...
- Tue Mar 13, 2018 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: STRING to Packed hexadecimal
- Replies: 14
- Views: 5955
Thanks for the response : FranklinE yes, I tried all you said - signed packed decimal and have used StringTo Decimal and few others but I am not getting the value that I am expecting. Input = 123456 Current Output = 01 7B C5 93 But expected Output is = 01 23 45 6C I believe there is something going ...
- Fri Mar 09, 2018 3:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: STRING to Packed hexadecimal
- Replies: 14
- Views: 5955
STRING to Packed hexadecimal
Hi DataStage Gurus, I am trying to convert a TEXT = '0123456' to PD Hexadecimal value = '01 23 45 6C' - where C - is sign digit. for the destination data types of PIC S9(6) COMP-3. to send over to Mainframes as a DATASET. I used below possible ways and not able to achieve in either of this(getting a...