Hi,

Can I use "LOAD from File" command from inside a Stored Procedure? When I try to run this command, its gives me "201: Syntax error" at Load. But when I run the same from $ prompt, it runs and loads the table.

Here is what I am running:

load from "/myfile.csv" DELIMITER "," insert into myTable(col1,col2)

The above runs successfully from command prompt but when I include the above statement in a stored procedure its gives "syntax error".

create procedure myprocedure()

load from "/myfile.csv" DELIMITER "," insert into myTable(col1,col2);

end procedure;

Can somebody tell me if this is possible at all to run from SP or it is only a Command Prompt statement.

Thanks.

-Nids1811.

You cannot load from inside a procedure.