SQL Anywhere 12.0.1
Is it possible to import data from file by using a scheduled Stored Procedure or Event? I read in the manual that there are certain SQL statements that are not allowed in Procedures and Events, with INPUT being one of them. But there must be some way to trigger the INPUT.
asked 28 Jan '14, 19:51
The INPUT statement is a dbisql[c] statement and cannot be used within the database server.
But there are lots of ways of getting data into the database from a procedure or event: use LOAD TABLE ... FROM FILE, xp_read_file, openxml( from file ... ), or even using proxy 'directory' tables. The exact method that you use will be dependent on the type of data that you want to import into the database. If you were using INPUT from the client then I'd recommend that you start by looking at LOAD TABLE since it is the most similar to INPUT.
answered 28 Jan '14, 20:42