Search found 7 matches

by bharath.gct
Tue Apr 03, 2012 1:25 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Question on SYNCSORT - Treat CHAR as HEX and CONVERT
Replies: 8
Views: 14580

Oops! I didnt think of it that way. let me do that as well.

Also, can you tell me how do we do it in COBOL? Sorry I was very optimistic that this was a small request and can very well be handled by SORT cards itself.
by bharath.gct
Mon Apr 02, 2012 10:04 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Question on SYNCSORT - Treat CHAR as HEX and CONVERT
Replies: 8
Views: 14580

Thanks. I thought this section in the forum included SYNCSORT support as well. Can you please let me know the correct section so that I can move this question there?
by bharath.gct
Mon Apr 02, 2012 6:07 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Hexadecimal to decimal conversion - SORT JCL INREC OUTREC
Replies: 18
Views: 54111

I did try Frank's IFTHEN solution using my SyncSort. Below is what I got: SYNCSORT FOR Z/OS 1.3.0.2R SYSIN : OPTION COPY INREC IFTHEN=(WHEN=INIT, OVERLAY=(81:C'0',1,1,C'0',2,1,C'0',3,1,C'0',4,1)), IFTHEN=(WHEN=INIT,FINDREP=(STARTPOS=81, * INOUT=(C'0A',C'10',C'0B',C'11',C'...
by bharath.gct
Mon Apr 02, 2012 5:57 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Hexadecimal to decimal conversion - SORT JCL INREC OUTREC
Replies: 18
Views: 54111

Hi, I did open this issue seperately in SyncSort Support Area. http://www.mainframegurukul.com/ibmmainframeforums/viewtopic.php?p=15557&highlight=#15557 I am using Syncsort V 1.3.02R. I guess mine did not support UNHEX. I tried running a example and it gave me a syntax error. More details on i/p o/p...
by bharath.gct
Mon Apr 02, 2012 2:01 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Question on SYNCSORT - Treat CHAR as HEX and CONVERT
Replies: 8
Views: 14580

I generated them using a .Net application. These are the GUIDs (Global unique IDs) and they are always generated in the number format. i.e. It is THE original format. But unfortunately I have to load them to Teradata as BYTE type. So if my Mainframe file has them as characters, they are not getting ...
by bharath.gct
Sun Apr 01, 2012 9:04 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Question on SYNCSORT - Treat CHAR as HEX and CONVERT
Replies: 8
Views: 14580

Question on SYNCSORT - Treat CHAR as HEX and CONVERT

Hi All, My requirement is given below: (HEX is ON in all Rows. We are running SYNCSORT version 1.3.0.2R.) I/p File: ----+----1----+----2----+----3----+----4----+----5----+----6--- -------------------------------------------------------------- ********************************* Top of Data ***********...
by bharath.gct
Sat Mar 31, 2012 8:22 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Hexadecimal to decimal conversion - SORT JCL INREC OUTREC
Replies: 18
Views: 54111

HEX to CHAR Representation

Hi Frank,

I only have SYNCSORT installed. Can we do this (TRAN=UNHEX) using ICETOOL?

Bharath