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: 7232

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: 7232

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: 7232

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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 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 Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am


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