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

to get records in sort using two fields with numeric format


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Annie Mary George

New User


Joined: 23 Jan 2014
Posts: 6
Location: india

PostPosted: Mon Jan 27, 2014 2:59 pm
Reply with quote

Hi,
its showing error in both sortfields and include cond what to do

Code:


sysin dd *
sort fields=(104,2,ch,137,2,ch)
include cond =(104,2,ch,eq,c,'99')and(137,2,ch,eq,c,'0')
/*
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Jan 27, 2014 3:23 pm
Reply with quote

Please copy/paste from your emulator.

When you want us to make suggestions about errors you have, you need to show what errors you are getting. Copy/paste from the sysout for the step.

If you have accurately re-typed, I suggest you look at the manuals (links at the top of the forum) and examples of SORT and INCLUDE here. Everything detailed in the manuals about the format of control cards and the statements on them is required.
Back to top
View user's profile Send private message
Annie Mary George

New User


Joined: 23 Jan 2014
Posts: 6
Location: india

PostPosted: Mon Jan 27, 2014 3:29 pm
Reply with quote

hi,
i have explained the error after the line.

Sysin dd *
sort fields=(104,2,ch,137,2,ch) //the error is after format ch is that the format for numeric
include cond=((104,2,ch,eq,c,'99')and(137,2,ch,eq,c,'0')) //the error is after c,
/*
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Jan 27, 2014 4:02 pm
Reply with quote

I'm sorry, but I've suggested that you look at the manuals and examples for SORT and INCLUDE. I've asked you to paste from your emulator. If you can't do any of that for some reason, I don't know what to do.

OK, one more suggestion, it'll take you a bit longer, because you'll have to go back to manuals/examples, but look up the text of the error messages you get. IBM LookAt, on the web, will even extract the message from the manual and display it for you. I'm not going to do that.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon Jan 27, 2014 11:45 pm
Reply with quote

Annie Mary George wrote:
Hi,
its showing error in both sortfields and include cond what to do

Code:


sysin dd *
sort fields=(104,2,ch,137,2,ch)
include cond =(104,2,ch,eq,c,'99')and(137,2,ch,eq,c,'0')
/*


Annie Mary George,

You cannot just have your own syntax. Look at the description of INCLUDE statement along with examples here

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ice1ca60/3.7?
Back to top
View user's profile Send private message
Annie Mary George

New User


Joined: 23 Jan 2014
Posts: 6
Location: india

PostPosted: Tue Jan 28, 2014 5:26 pm
Reply with quote

hI,
I reviewed the manuals the below code works for numeric records.

sysin dd *
sort fields=COPY
include cond =((104,2,ZD,eq,99),and,(137,2,ZD,GT,c,'0'))
/*
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Jan 28, 2014 5:40 pm
Reply with quote

If you copy that and paste it and run it you'll find it doesn't work. Please stop re-typing things. We don't know what your actual mistakes are and what are just typos.

Do you still have problems with what you are running on your system? If so, please copy/paste them here, with the messages you receive in the sysout for the step.
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Populate last day of the Month in MMD... SYNCSORT 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
Search our Forums:

Back to Top