how to specify the number of records to fetch

romina

hi
can any body helps me for the equal statement at DB2 ver 7.0 for this
statement at SQL?
Select top 10 column1 from table1
thanks

Nov 12 '05 #1

Subscribe Reply

10801

graham_martin

to get the first 10 rows......

select column1 from table1 fetch first 10 rows only

to get the top 10 rows........

select column1 from table1 order by column1 desc fetch first 10 rows
only

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Nov 12 '05 #2

Bernd Hohmann

romina wrote:

can any body helps me for the equal statement at DB2 ver 7.0 for this
statement at SQL?
Select top 10 column1 from table1

SELECT * FROM table WHERE xxx ORDER BY yyy ASC FETCH FIRST 10 ROWS ONLY

Bernd

--
"Ja, alles meine Herren" sprach Fürst Lichnowsky. "Ooch det roochen?"
"Ja, auch das Rauchen." "Ooch im Tiergarten?" "Ja, auch im Tiergarten
darf geraucht werden, meine Herren." Und so endeten die Barrikadenkämpfe
des 18. März in Berlin

Nov 12 '05 #3

Knut Stolze

romina wrote:

hi
can any body helps me for the equal statement at DB2 ver 7.0 for this
statement at SQL?
Select top 10 column1 from table1

Have a look at the DB2 manual, specifically here:
http://publib.boulder.ibm.com/infoce...n/r0000875.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Nov 12 '05 #4

romina via DBMonster.com

hi ,
tanks for ur help,I did it but this error happened:

ILLEGAL USE OF KEYWORD FETCH, TOKEN , FOR WITH QUERYNO OPTIMIZE WAS EXPECTED

I don't know why!

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200511/1

Nov 12 '05 #5

Gert van der Kooij

In article <573f8d3305960@uwe>, romina via DBMonster.com (u15590@uwe)
says...

hi ,
tanks for ur help,I did it but this error happened:

ILLEGAL USE OF KEYWORD FETCH, TOKEN , FOR WITH QUERYNO OPTIMIZE WAS EXPECTED

I don't know why!

Which DB2 do you use, DB2 v7.0 on mainframe?

Nov 12 '05 #6

romina via DBMonster.com

hi
it's DB2 v6.0 on mainframe
Gert van der Kooij wrote:

hi ,
tanks for ur help,I did it but this error happened:

ILLEGAL USE OF KEYWORD FETCH, TOKEN , FOR WITH QUERYNO OPTIMIZE WAS EXPECTED

I don't know why!

Which DB2 do you use, DB2 v7.0 on mainframe?

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200511/1

Nov 16 '05 #7

romina via DBMonster.com

hi
it's DB2 v6.0 on mainframe
Gert van der Kooij wrote:

hi ,
tanks for ur help,I did it but this error happened:

ILLEGAL USE OF KEYWORD FETCH, TOKEN , FOR WITH QUERYNO OPTIMIZE WAS EXPECTED

I don't know why!

Which DB2 do you use, DB2 v7.0 on mainframe?

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200511/1

Nov 16 '05 #8

by: Beelzehubub | last post by:

Hi, I'm having a bit of trouble with an update performed by a PL/SQL routine that is updating more rows than it should be. Here's some of the code: Note that ZENT.APPID is NUMBER and ZENT.UCLS...

Oracle Database

Get previous and next records relative to an index record

by: eeh | last post by:

Hi, Suppose I have a table "product" with fields id,name,price. I want to get a resultset of previous and current and next record when the resultset is sorted by id and id=10. The table data is...

MySQL Database

"Specify Table containing the Records you want to Delete" Problem

by: John Baker | last post by:

Hi: Access 2000 W98! I have a table with numerous records in it, and am attempting to delete certain records that have been selected from it. These are selected based on the ID number in a...

Microsoft Access / VBA

number of rows in a cursor

by: Christoffer Gurell | last post by:

After declaring a cursor. Is there any way you can check the number of rows that cursor contains ?? / Christoffer Gurell ---------------------------(end of...

PostgreSQL Database

When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected to the database. SQLSTATE=57030.

by: alingsjtu | last post by:

Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected...

DB2 Database

Improving the Performance (Millions of Records!)

by: ssrirao | last post by:

Table1 -------------------------------------------------------- a(varchar) | b(varchar) | c(varchar) | d(float) --------------------------------------------------------- has value...

Microsoft SQL Server

How to retrieve all the records from database into textboxes using dataadapter

by: muskan | last post by:

hello, I want to fetch all the records from database one by one when I click on next button I have written this code for fetching the records from database. But it shows only first record....

.NET Framework

how to fetch records from 2 tables

by: indhu | last post by:

hi all, Tables: story, shot story-fieldnames, project, date episode shot-fieldnames, scene,shot, filename(imagepath),action and dialogue. Form has field from both the tables. how do i fetch...

Visual Basic 4 / 5 / 6

How to fetch records randomly every time you query

by: camarun20 | last post by:

Hi , I constructed an MS access query in java to retrieve the rows in random. The code snipet Connection con = DriverManager.getConnection( database ,"",""); Statement s =...

Microsoft Access / VBA

How to build RAID in BIOS?

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...

Computer Hardware

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

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 ...

C# / C Sharp

how to specify the number of records to fetch

Similar topics