473,405 Members | 2,354 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,405 software developers and data experts.

qurey for ibm db2

what is query for update table in db2???????????
Jun 16 '07 #1
1 1270
what is query for update table in db2???????????
if you want to update single row at a time

update tablename set columnname= expression where condition;
Jun 18 '07 #2

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

Similar topics

4
by: middletree | last post by:
Intranet tech support system using ASP/VBScript running on W2000 Server, IIS, and using SQL Server 2000. I need to add a search engine. The problem with using a regular SQL query is that if you...
1
by: Prashant | last post by:
Hi Folks, Can u help me out on a sql query: Requirement is i need to print table_name , columns_inside_table , rows_in_this_table of a particular schema.. I have got 1 solution from using PLSQL...
6
by: teedilo | last post by:
We have an application with a SQL Server 2000 back end that is fairly database intensive -- lots of fairly frequent queries, inserts, updates -- the gamut. The application does not make use of...
6
by: micmic.chion | last post by:
I am using Windows 2003 Server English Version. I wanna store the big-5 data so I install the sql server 2000 as if i install it in the Windows 2000 with Server Collation of the...
4
by: meyvn77 | last post by:
Im using an ADP to connect to a SQL Sqever DB. In access it was really easy to say Inner join on table1 and table2 and update columnA from table1 with columnC from table2 where table1.key =...
1
by: Jacky11 | last post by:
Is there anyway I can enter the words bellow in a query Field? This line has to be added to every line. That's the way I have to submit my filtered table. Thanks <p><img border="0"...
1
by: KinRsole | last post by:
Hi there I'm a complete beginner with access so please be gentle! I need to write a qurey to calculate the daily interest earn on a saving account. So far I have two tables.One with the account...
2
by: logesh | last post by:
hi, i have written a qurey to retive some data form a table,but i want the qurey should be more faster, i dont want to set index, other that that,if any. advice required!!!!! THIS THE QUREY...
1
by: mina10a | last post by:
plze guide me. I have done asp.net project in which i usr MS Access database. this site works fine in localhost but when i upload the site in server it show me the error "Operation must use an...
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: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
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.