IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT --- CHAR to HEX / DEC to HEX


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pobbi

New User


Joined: 15 May 2007
Posts: 3
Location: usa

PostPosted: Sat May 19, 2007 1:23 am
Reply with quote

I have a input as FB file with Record length - 403
output as VB file with LREC - 1000.
my questions:
1) is there way to sort that above combination? ie. FB file to VB file
2) And I want to convert one input field start 104 position from CHAR to HEX
3) Also I want to convert other input field start 124 position from DEC to HEX
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat May 19, 2007 1:27 am
Reply with quote

Hello and welcome to the forums,

Which sort product does your site use?

Please show some sample data (both cases) of what you have and what you want as output.
Back to top
View user's profile Send private message
pobbi

New User


Joined: 15 May 2007
Posts: 3
Location: usa

PostPosted: Sat May 19, 2007 1:36 am
Reply with quote

here is my jcl sort steps:

//JSTEP01 EXEC PGM=SORT,REGION=4096K
//*----------------------------------------------------------
//SYSOUT DD SYSOUT=C
//SORTWK01 DD UNIT=DISK,AVGREC=K,SPACE=(252,(500,50),RLSE)
//SORTWK02 DD UNIT=DISK,AVGREC=K,SPACE=(252,(500,50),RLSE)
//SORTWK03 DD UNIT=DISK,AVGREC=K,SPACE=(252,(500,50),RLSE)
//SORTWK04 DD UNIT=DISK,AVGREC=K,SPACE=(252,(500,50),RLSE)
//SORTWK05 DD UNIT=DISK,AVGREC=K,SPACE=(252,(500,50),RLSE)
//SORTIN DD DSN=TESTOR00.UI.DS157C.INPUT,
// DISP=SHR
//SORTOUT DD DSN=TESTOR00.UI.DS157C.INPUT.VB(+1),
// DISP=(NEW,CATLG,DELETE),UNIT=LVL0,
// SPACE=(10000,(600,100),RLSE),AVGREC=K,
// DCB=(LRECL=10000,BLKSIZE=0,RECFM=VB)
//SYSIN DD *
???????
/*
input data looks like :

WA 1 1 007 072 07 01704 ZZ 1
WA 0 2 007 072 13 01704 U2 2
CA 1 3 052 072 07 01704 U2 3
CA 0 4 052 072 13 01704 CQ 5
CA 1 5 052 072 07 01704 CQ 13
CA 0 6 052 072 07 01704 PS 11
CA 1 7 052 072 07 01704 HK 12
CA 0 8 052 072 13 01704 U2 12
CA 1 8 052 072 07 01704 U2 16
CA 0 8 052 072 13 01704 CQ 12

the first column needs to convert CHAR to HEX
and last column needs to convert DEC to HEX
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat May 19, 2007 2:47 am
Reply with quote

Hello,

Please re-read my initial reply and answer those questions.

They are:

What sort product do you use?

Show the desired output from the input you posted.
Back to top
View user's profile Send private message
pobbi

New User


Joined: 15 May 2007
Posts: 3
Location: usa

PostPosted: Sat May 19, 2007 2:48 am
Reply with quote

syncsort
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat May 19, 2007 3:02 am
Reply with quote

One more time. . . . icon_confused.gif

From that input, what do you want the output to look like?

It is better to be complete rather than just quick with a response. . .
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Sat May 19, 2007 3:04 am
Reply with quote

pobbi wrote:
I want to convert one input field start 104 position from CHAR to HEX
Quote:
Also I want to convert other input field start 124 position from DEC to HEX
I know what "CHAR" is, and I know what "DEC" is and I know what "HEX" is, but I'm betting that you have another definition of "HEX".
How do you define "HEX"?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat May 19, 2007 3:07 am
Reply with quote

If the desired output is posted, we'll see. . . icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Exclude rows with > than x occurre... DFSORT/ICETOOL 6
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts DFSORT/SYNCSORT/ICETOOL JCL & VSAM 8
Search our Forums:

Back to Top