Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Red face Unanswered: Load command in Informix

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    You cannot load from inside a procedure.
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •