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

Need a Query to split the results


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Sep 24, 2009 1:22 pm
Reply with quote

no need to be rude.
At the time of my post about missing order by there was none. It's not my fault that you edit it afterwards and then play innocent.

you have now flooded this thread with a lot of BS and finally came to an answer that was already given in post 5 (which is also missing order by)
Back to top
View user's profile Send private message
lkhiger

New User


Joined: 28 Oct 2005
Posts: 89

PostPosted: Thu Sep 24, 2009 4:18 pm
Reply with quote

GuyC wrote:
no need to be rude.
At the time of my post about missing order by there was none. It's not my fault that you edit it afterwards and then play innocent.

you have now flooded this thread with a lot of BS and finally came to an answer that was already given in post 5 (which is also missing order by)

Forget about. It's not interesting for me anymore.
The problem was too easy, but you said ... it is too difficult in V8. icon_redface.gif See your message.

That's why I shown to author the few ideas how to solve it.

Buy-buy ORDER BY !

Lenny

Lenny
Back to top
View user's profile Send private message
lkhiger

New User


Joined: 28 Oct 2005
Posts: 89

PostPosted: Thu Sep 24, 2009 4:30 pm
Reply with quote

GuyC wrote:
there's no easy solution for this in V8, especially not when some order is involved.
in V9 you might use quantile runstats to determine the cut off points


icon_arrow.gif In V9 we can use the function
Code:
rowno() over()

which is not required KEYID. icon_exclaim.gif

Lenny
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts RC query -Time column CA Products 3
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Query on edit primary command CLIST & REXX 5
No new posts Query on edit primary command CLIST & REXX 1
Search our Forums:

Back to Top