Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

INSERT using SELECT Clause and FETCH FIRST Clause

Status
Not open for further replies.
belacourt

belacourt

Programmer
Jun 16, 2002
1
CA
Hi,

I am trying to use an INSERT Statement using a SELECT and the SELECT has FETCH FIRST N ROWS. The SQL is failing. I am using DB2 Ver 9.

Can I use INSERT with SELECt and FETCH FIRST N ROWS in DB2 SQL?
Is there a way around this ?.

Kumud.
 
Sort by date Sort by votes
Kumud,
Could you post the SQL you are running and details of the error message.
Thanks
Marc
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
220
fredericofonseca
fredericofonseca
pratimsingha
  • Locked
  • Question
Alternative of Select count(*) from TABLE
Replies
0
Views
179
pratimsingha
pratimsingha
jpotucek
  • Locked
  • Question
Understanding "Grant Select Access to PUBLIC" in DB2 LUW
Replies
1
Views
128
johnherman
johnherman
Khaleel2408
  • Locked
  • Question
Unable to connect to DB2 database server over sec port using SSL from windows ODBC DSN client
Replies
0
Views
205
Khaleel2408
Khaleel2408
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once 1
Replies
5
Views
136
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top