View previous topic :: View next topic
|
Author |
Message |
raghavmcs
Active User
Joined: 14 Jul 2005 Posts: 105
|
|
|
|
Dear Experts,
I am getting a file from another mainframe system of 80 lenght,fixed block.
For my reporting purpose I am only interested in records whereever from position 46 and next 5 lenght it has value 40834.with a hex on on this file I see following on mainframe.I am wondering if this is EBCDIC format?
FFFFF
40834
I actually need 10 sample records copied from this file with key as this field which is starting at position 46 and has lenght of 5.
I am not sure what datatype should be used with sort on this. |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
Yes, it most certainly is. |
|
Back to top |
|
|
raghavmcs
Active User
Joined: 14 Jul 2005 Posts: 105
|
|
|
|
Okay,thanks,I am wondering if DFSORt has something for checking this datatype directly or there would be some internal conversion I would have to do. |
|
Back to top |
|
|
raghavmcs
Active User
Joined: 14 Jul 2005 Posts: 105
|
|
|
|
Just a correction I see this is VB file. |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
raghavmcs,
Use the following DFSORT JCL . All you need is a simple include cond and copy statement and restrict it to the number of records you want.
Code: |
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=Your input Vb file,DISP=SHR
//SORTOUT DD SYSOUT=*
//SYSIN DD *
INCLUDE COND=(50,5,CH,EQ,C'40834')
OPTION COPY,STOPAFT=10
//* |
|
|
Back to top |
|
|
raghavmcs
Active User
Joined: 14 Jul 2005 Posts: 105
|
|
|
|
I am sorry it was really my mistake while I was using the CH with sort the thing whihc I overlooked was the file was VB and I assumed its FB!!!
Really poor. |
|
Back to top |
|
|
|