473,594 Members | 2,658 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

rownumber() over - which versions support this

I am using DB2 V7 on Z/OS. I am not sure if this version of DB2
supports this function. Can someone please comment whether they have
used this function in such environment??

What version of DB2 first supported this function?

Nov 12 '05 #1
1 1960
I don't think row_number() is supported yet in DB2 for zOS.
IIRC row_number(), along with other OLAP fucntiosn was first introduced
in DB2 V7.1 for LUW.

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Marcia Gulesian | last post by:
How can I determine the version of Safari (for example, 1.0.2 or 1.2.2) that's downloaded a document?
by: Paul Reddin | last post by:
Hi, using ROWNUMBER() is affecting the plan of a view very badly... is there a way of writing the following view to ensure rownumber() is done as the last thing done? i.e after the calling predicates have been applied to a_cte e.g I have rewritten the view as follows using a CTE, trying to
by: Dalan | last post by:
After reading and experiencing the phenomenon of installing MS Office 2000 on a system that already has MS Office 97, or for that matter just Access 97 Runtime, I saw the ugliness that ensues. If one elects the standard installation, then Office 2000 deletes a large percentage of the older files. Of course, if one happens to choose Custom installation and elects not to uninstall prior versions, then things are happier. Yes, the archives...
by: Zen | last post by:
From http://support.microsoft.com/kb/828956/ "Note Microsoft does not support the use of multiple versions of Microsoft Office on a Terminal Server. Coexistence is not supported on versions of Windows that are running Terminal Services. If you have to run multiple versions of Office, disable Terminal Services" The problem:
by: Evan Stone | last post by:
If one is developing a .NET application, how can I develop an application that uses COM automation that targets multiple versions of Word? For example, the signature for the Document.Open method is different from version 9 to version 11 (and I'm sure there are other variations as well), and I'm wondering if there's some easy way to deal with it. At present I'm only concerned with supporting 9-11 (i.e. Word 2000, XP, and 2003), though I'd...
by: Taoge | last post by:
hi, I'd like to know how does the rownumber - getrow() if copy rows to the datawindows itself, what's there new row numbers. for example, if i have dw have 10 rows, if copy rows 3-5 and insert the 3 rows before row 9, what are the new copied row number?
by: OceanBreeze | last post by:
I am getting error while trying to run the following SQL in DB2 8.x in Z/OS. SELECT * FROM ( SELECT MYCOL1, ROWNUMBER() OVER (ORDER BY MYCOL1) AS ROW_NEXT FROM MYSCHEMA.MYTABLE ) AS PRODUCT_TEMP WHERE ROW_NEXT BETWEEN 3 and 5I am getting following error: Examine and correct the statement in the area of the specified
by: M.-A. Lemburg | last post by:
On 2008-07-25 08:13, python@bdurham.com wrote: Yes. But then Intel Itanium is being phased out anyway and the AMD64 build works on both Intel and AMD processors. True.
by: vineetcs | last post by:
Yes In SQL2000 , Row_Number() function will not work as in SQL2005. But, we can use the IDENTITY(INT,1,1) function but it requires a temporary table to which it stores the data and in View does'nt Support Temporary tables. what I did is, I created a function which returns a table and in that table I have but 1 Identity field with AutoIncrement... Sample Code **************** ALTER FUNCTION dbo.UF_GetName() RETURNS @Temp_tbl TABLE ( ...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.