Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

separating only the records with hexa decimal value

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
akashs

New User


Joined: 24 Nov 2005
Posts: 49
Location: chennai

PostPosted: Thu Nov 05, 2009 4:19 pm    Post subject: separating only the records with hexa decimal value
Reply with quote

Hi,

I have a variable record length file of 2048 bytes.Records in this file are in hexadecimal format. I need to seperate only those records which has values '777C' into a output file.I dont know the exact field position.Please suggest me a solution.

regards,
Akash
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Nov 05, 2009 4:24 pm    Post subject:
Reply with quote

Search the forum using the words search substring
indicate the box that says all keywords
And many excellent examples will appear
Back to top
View user's profile Send private message
akashs

New User


Joined: 24 Nov 2005
Posts: 49
Location: chennai

PostPosted: Thu Nov 05, 2009 4:30 pm    Post subject: Reply to: separating only the records with hexa decimal valu
Reply with quote

Hi Expat,

There is no links in this forum that has SS command for Hexa decimals.
They have given SS only for chracter strings.

regards,
sathish
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: Thu Nov 05, 2009 8:56 pm    Post subject:
Reply with quote

Hello,

Define the value as a hex constant rather than a character constant. . .

Quote:
There is no links in this forum that has SS command for Hexa decimals.
They have given SS only for chracter strings.
Yes, there are. . . You just didn't take the time. . .

Quote:
For example if the S9(4) COMP variable value is 202 I can give
(5,10000,SS,EQ,X'F8F900CAF0F1')


The info is also in the DSFORT documentation.

Had you looked at either, you would have had an answer hours ago and not still be waiting. . .
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Nov 05, 2009 11:38 pm    Post subject:
Reply with quote

sathish,

You can use these DFSORT statements:

Code:

   OPTION COPY
   INCLUDE COND=(1,2048,SS,EQ,X'777C')
Back to top
View user's profile Send private message
akashs

New User


Joined: 24 Nov 2005
Posts: 49
Location: chennai

PostPosted: Fri Nov 06, 2009 3:12 pm    Post subject: Reply to: separating only the records with hexa decimal valu
Reply with quote

Hi Frank,

Thank u very much..the code worked fine now

regards,
akash
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Comparing Decimal and CHAR columns rakesh17684 DB2 7 Thu Oct 20, 2016 2:33 am
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us