LOAD via a Stored Procedure

[Thanos]

Can you use a the load or import command in a stored procedure??? I
tried to LOAD FROM blah blah...within a stored procedure but i get a
error that was not expecting the worD LOAD! Any ideas??? TIA!

i.e

CREATE PROCEDURE LOAD_DATA()
SPECIFIC LOAD_DATA
LANGUAGE SQL

BEGIN
LOAD FROM C:\TEMP\DATA.DAT...... <<<< I GET THE ERROR ON THIS
LINE???
......
.....
END

[Knut Stolze]

Thanos wrote:

Can you use a the load or import command in a stored procedure??? I
tried to LOAD FROM blah blah...within a stored procedure but i get a
error that was not expecting the worD LOAD! Any ideas??? TIA!
Yes, you can but you have to use an external programming language like C and
the DB2 APIs.
CREATE PROCEDURE LOAD_DATA()
SPECIFIC LOAD_DATA
LANGUAGE SQL

BEGIN
LOAD FROM C:\TEMP\DATA.DAT...... <<<< I GET THE ERROR ON THIS
LINE???
.....
....
END

LOAD is not an SQL statement but rather a DB2 command. Thus, you cannot
embed it into a LANGUAGE SQL procedure.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena