Hi,
I used DB2's bulk loader "load" to import large amount of data into a
temporary table. From there I want to move the data into another table
using joins etc.
In order to move this data from the temporary table to the production
table, I read in the IBM RedBoob Series "Moving Data Across the Db2
family" (p.18) there are commands like the following two which can be
used to perform a high performance (!!!) insert

DECLARE mycurs CURSOR FOR select ...
LOAD FROM mycurs OF CURSOR insert into (...)

While the first command works fine, the second return an error: SQL0104N
after the <> follows the unexpected token INTO. To the possible tokens
belongs "("

Does anybody know what's wrong?
Thanks in advance, Tori

Great Sorry,
it works fine. Something in my statement was wrong
see you, Tori

Toralf Kirsten wrote:

What Version of DB2 do you use ?
LOAD from CURSOR is available in DB2 V8, not in V7.2 or earlier


Toralf Kirsten <tkirsten (AT) izbi (DOT) uni-leipzig.de> wrote