View previous topic :: View next topic
|
Author |
Message |
pobbi
New User
Joined: 15 May 2007 Posts: 3 Location: usa
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
pobbi
New User
Joined: 15 May 2007 Posts: 3 Location: usa
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
pobbi
New User
Joined: 15 May 2007 Posts: 3 Location: usa
|
|
|
|
syncsort |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
One more time. . . .
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
If the desired output is posted, we'll see. . . |
|
Back to top |
|
|
|