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);
Can somebody tell me if this is possible at all to run from SP or it is only a Command Prompt statement.