Insert into and FETCH FIRST ROW ONLY

[dataguy]

Re: Insert into and FETCH FIRST ROW ONLY

Thanks to everyone who helped on this issue.
dataguy wrote:

Thanks for the clarification
Tonkuma wrote:

DB2 for OS/390 doesn't support fetch for subselect nor fullselect even
Version 8.
FETCH is supported for select-statement.
Related part of syntax of INSERT statement is
INSERT INTO table-name|view-name fullselect isolation-clause QUERYNO
integer

DB2 for LUW support fetch for sub-select. So, fetch can be used in
INSERT.