Search found 5 matches

by jagan02
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: 5807

Thanks for the options FraklinE, i got it worked finally, I was missing Character set = EBCDIC and while transferring to mainframes I was missing to transfer in Binary mode.
by jagan02
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: 5807

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...
by jagan02
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: 5807

@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 ...
by jagan02
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: 5807

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 ...
by jagan02
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: 5807

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...