How to load a cursor from a stored procedure in DB2

[technocrat]

Hi,
I am trying to declare and cursor and thn load from that cursor into
another table. Since I have almost 4 million records, I cant do it
without the cursor which reduces the time by almost 1/10th.
I tried to create a sql statement for "load from cursor cur insert into
table name" using java stored procedure, but this isnt recognised by
sql since load isnt a sql keyword. So whats the solution to this. I
have to do it programatically rahter than going to db2clp everytime I
want to load data.
Any suggestions are welcome..
This is the excerpt of the code I am trying to build
try
{
String sql="declare cur cursor for SELECT * from tablename;

PreparedStateme nt st= con.prepareStat ement(sql);
st.execute(sql) ; // tried regular Statement class also

}
catch (SQLException e)
{
System.out.prin tln("Error in declaring the cursor");
e.printStackTra ce();
}

try
{
String sql2 = "load from cur of cursor insert into schema.customer
nonrecoverable" ;
Statement st1=con.createS tatement();
st1.execute(sql 2);
}
catch (SQLException e1)
{
System.out.prin tln("Error loading form the cursor");
}

Throws exception at both the places. The log looks like this:

SELECT * from tablename
Error in declaring the cursor
COM.ibm.db2.jdb c.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0104N An
unexpected token "load from cur of cursor" was found following
"BEGIN-OF-STATEMENT". Expected tokens may include: "<space>".
SQLSTATE=42601

at
COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExceptionG enerator.java(C ompiled
Code))
at
COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.th row_SQLExceptio n(SQLExceptionG enerator.java:2 17)
at
COM.ibm.db2.jdb c.app.SQLExcept ionGenerator.ch eck_return_code (SQLExceptionGe nerator.java:44 9)
at
COM.ibm.db2.jdb c.app.DB2Statem ent.execute2(DB 2Statement.java :857)
at
COM.ibm.db2.jdb c.app.DB2Statem ent.execute(DB2 Statement.java: 530)
at
PKG603011246378 44.InitControl. initCustomer(In itControl.java: 344)
at
PKG603011246378 44.InitControl. initControl(Ini tControl.java:4 9)

[Serge Rielau]

Eugene F wrote:

But *not documented* should also mean not supported by IBM, right? :-)
So how about using that solution at a customer site -- there are many
occasions where load from SQL would've made a project implementation
much easier.

Do you believe in the Easterbunny? I do.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab