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
 

 

to get records in sort using two fields with numeric format

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: to get records in sort using two fields with numeric format
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7281

PostPosted: Mon Jan 27, 2014 3:23 pm    Post subject: Reply to: to get records in sort using two fields with numer
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    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7281

PostPosted: Mon Jan 27, 2014 4:02 pm    Post subject: Reply to: to get records in sort using two fields with numer
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    Post subject: Re: to get records in sort using two fields with numeric for
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

http://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    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7281

PostPosted: Tue Jan 28, 2014 5:40 pm    Post subject: Reply to: to get records in sort using two fields with numer
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    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 Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts To Merge mutliple records into a sing... anandgbe DFSORT/ICETOOL 4 Wed Feb 22, 2017 8:49 am
No new posts Match records - scdinesh DFSORT/ICETOOL 6 Wed Feb 22, 2017 5:02 am
No new posts Matching and unmatching records scdinesh DFSORT/ICETOOL 11 Tue Feb 07, 2017 12:41 am
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm


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