LOAD via a Stored Procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thanos - 28 Sep 2004 23:36 GMT

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

Reply to this Message

Knut Stolze - 29 Sep 2004 11:54 GMT

> 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
[quoted text clipped - 6 lines]
> ....
> END

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

Signature

Knut Stolze
Information Integration
IBM Germany / University of Jena

Reply to this Message