Subselect Row Restrictions

[Michael]

I am trying to INSERT only the first row returned from a subselect, is
this possible? I'm on DB2 v8 on z/OS.

Non-working Example:

INSERT into some_table (
SELECT id
FROM some_other_tabl e
WHERE conditions are met
FETCH FIRST 1 ROWS ONLY
)

Thanks.

[Brian Tkatch]

Michael wrote:

I am trying to INSERT only the first row returned from a subselect, is
this possible? I'm on DB2 v8 on z/OS.

Non-working Example:

INSERT into some_table (
SELECT id
FROM some_other_tabl e
WHERE conditions are met
FETCH FIRST 1 ROWS ONLY
)

Thanks.

I'm on Solaris, so this may be of no help.

This "worked for me":

DECLARE GLOBAL TEMPORARY TABLE some_table(a int)
DECLARE GLOBAL TEMPORARY TABLE some_other_tabl e(id int)
INSERT INTO SESSION.some_ot her_table VALUES (1), (2)
INSERT INTO SESSION.some_ta ble (SELECT id FROM SESSION.some_ot her_table
FETCH FIRST 1 ROWS ONLY)
SELECT * FROM SESSION.some_ta ble
DROP TABLE SESSION.some_ot her_table
DROP TABLE SESSION.some_ta ble
COMMIT

What was the error that you received?

B.

[Michael]

The error I was receiving was that "FETCH" was an illegal keyword. I
was able to bypass the problem by doing a SELECT MIN(id) since I can
use any of them from the table. Thanks for your suggestion.