473,396 Members | 2,140 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Limit Number of Rows Updated in DB2 MVS

1
Good Day,

I need to limit the number of rows that an update statement affects.

Most resources on the web that i have seen suggests:

Expand|Select|Wrap|Line Numbers
  1.  UPDATE  (SELECT ...) SET ... WHERE .. 
This seems to work fine on DB2 AIX but it does not seem to be valid with DB2 MVS and i need it to work for both.

I'm stuck with this problem for 2 days already and I am hoping someone can help me with this.

Thanks in advance.

Note: The table to be updated changes dynamically so i can't use primary keys or any specific column
Aug 7 '13 #1
0 1277

Sign in to post your reply or Sign up for a free account.

Similar topics

29
by: Paul | last post by:
Hi, I'd like to limit the number of selections a user can make in a multiple select listbox. I have a note on the interface to say that only x no. of items should be selected and I check the...
2
by: Ian | last post by:
Using Access 97 I want to distribute my database over a LAN but limit the number of PC's that can use it at the same time. Perhaps limit it to 3 so when the 4th user tries to open it they cant...
3
by: TomislaW | last post by:
I need to show 5 rows and put link for more.. where and how to put this limit? on item data bound or else?
4
by: Melson | last post by:
Hi I've a problem. Can anyone help. I would like to use datagrid for data entry. How can I set the number of rows in the datagrid. And use the datagrid to update the ms sql table. regards...
1
by: KMEscherich | last post by:
Microsoft Access '97 Hi there, I have developed an Access database and am attempting to limit the rows in a control that has been set up as a DATASHEET view. This control has been placed on a...
1
by: jobs | last post by:
I've tried setting the height of the dropdownlist, but when I do that it eats of space below . Basically, I only want about 10 rows visible and scrolling to then show up if there are more rows. But...
1
by: sharadadutt1981 | last post by:
hi all, I was trying to fetch even or odd number rows from database. currently i am usying DB2 ver 8.0. any one can help me out.
1
by: clickingwires | last post by:
How do you consecutively number rows in an aggregate query?
3
juve11
by: juve11 | last post by:
hello, i have a vb application that writes into mysql (some kind of autocomplete). problem is that it writes too many rows and the app at a moment starts to run slowly.so an option that i thaught...
1
by: jeddiki | last post by:
Hi, I want to get a subset from my table that includes rows that have an item (cb_id) with a unique ip address ( ip_adr). To be in the subset there should be at least two rows and if there are more...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
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...
0
agi2029
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,...

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.