Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SYNCSORT --- CHAR to HEX / DEC to HEX

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: SYNCSORT --- CHAR to HEX / DEC to HEX
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

Site Director


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

PostPosted: Sat May 19, 2007 1:27 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Sat May 19, 2007 2:47 am    Post subject:
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    Post subject:
Reply with quote

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

Site Director


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

PostPosted: Sat May 19, 2007 3:02 am    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Sat May 19, 2007 3:04 am    Post subject: Re: SYNCSORT --- CHAR to HEX / DEC to HEX
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

Site Director


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

PostPosted: Sat May 19, 2007 3:07 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Select numeric portion from CHAR data... balaji81_k DB2 6 Sat Aug 19, 2017 1:51 am
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us