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
 

 

Can high values appear in internal sort?

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

New User


Joined: 12 Jul 2008
Posts: 7
Location: Chennai

PostPosted: Wed Aug 06, 2008 11:50 am    Post subject: Can high values appear in internal sort?
Reply with quote

Hi,

Following is the internal sorting handled in program. If the input has high values, will the sort fail?

SORT SORT-FILE
ASCENDING KEY FIELD1
FIELD2
FIELD3
USING INPUT-FILE

OUTPUT PROCEDURE 9000-PARA THRU
9000-PARA-EXIT.
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: Wed Aug 06, 2008 12:00 pm    Post subject:
Reply with quote

Hello,

The sort will not fail because of high-values in some or all of the character fields of a record. - every value from x'00' to x'FF' is valid to sort.

If some of your fields are supposed to be signed numeric fields and they contain high-values, your program may fail (i.e. s0c7).
Back to top
View user's profile Send private message
karthikeyan r

New User


Joined: 12 Jul 2008
Posts: 7
Location: Chennai

PostPosted: Wed Aug 06, 2008 12:17 pm    Post subject: Reply to: Can high values appear in internal sort?
Reply with quote

Hi,

The input has one record fully with high values. Of course we have sort field as signed numeric. But i am getting U025 abend. Following are the last few lines in SYSOUT:
INSIDE 9000-EXIT
ICE751I 1 BA-K22788 BB-K24705 BC-K24705 E8-K24705
ICE091I 0 OUTPUT LRECL = 40, TYPE = F
ICE080I 0 IN MAIN STORAGE SORT
ICE055I 0 INSERT 0, DELETE 0
ICE054I 0 RECORDS - IN: 1, OUT: 0
ICE025A 0 RECORD COUNT OFF
ICE052I 0 END OF DFSORT
CEE3250C The system or user abend U 025 R=NULL was issued.
From compile unit SMS475 at entry point SMS475 at compile unit offset +
address 2789EE8E.
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: Wed Aug 06, 2008 12:24 pm    Post subject:
Reply with quote

Hello,

Did you RETURN the sort file? Did you get the record or was at end raised on the first return?

Is it possible that the program went thru the output procedure and did not accres the sort file?

This sounds like a code error rather than a problem with high-values. The high-values may have caused a problem with the code, but that is not a sort/high-value issue.
Back to top
View user's profile Send private message
karthikeyan r

New User


Joined: 12 Jul 2008
Posts: 7
Location: Chennai

PostPosted: Wed Aug 06, 2008 2:35 pm    Post subject: Reply to: Can high values appear in internal sort?
Reply with quote

Hi,

It went thru output procedure also. The display ' inside 9000-exit' is also displayed indicating it came out of exit. Yes.. i have used return statement also. If you could see the sort statements in SYSOUT that i have sent, it says input to sort is 1 but output is 0. So i guess that problem with sort. If not, what can be done with the code..?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Wed Aug 06, 2008 2:48 pm    Post subject:
Reply with quote

dick scherrer wrote:
...If some of your fields are supposed to be signed numeric fields and they contain high-values, your program may fail (i.e. s0c7).


or to paraphrase what Dick said: Is field1,2 or 3 defined as numeric?`
Back to top
View user's profile Send private message
karthikeyan r

New User


Joined: 12 Jul 2008
Posts: 7
Location: Chennai

PostPosted: Wed Aug 06, 2008 2:56 pm    Post subject: Reply to: Can high values appear in internal sort?
Reply with quote

yES. fIELD1 AND fIELD 3 ARE NUMERIC
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: Wed Aug 06, 2008 7:44 pm    Post subject:
Reply with quote

Hello,

Without seeing the code, it still appears that the code is not working properly. From the info presented by the sort, it looks like the record was not returned into the program.

Quote:
So i guess that problem with sort
It is most unlikely that you have discovered a problem with the sort. It is most likely that the code is failing.

It may help if you put a display statement immediately after the return and see what happens.
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 SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


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