Re: Creating Stored Procedures on the fly...
Govind,
are you running this 'isql file.sql' or 'dbaccess file.sql' - ive never
seen the documentations, but on our sun boxes, i have to use dbaccess to
execute spl code.
>
> I want to be able to recreate stored procedures dynamically, based on
> SPL commands from a disk file. This would enable me to constantly
> change the action of the stored procedure based on varying conditions
> and parameters. According to the manuals, this is a fairly trivial
> task achieved by executing the sql statement:
> create procedure from "myproc.spl"
> where myproc.spl is a disk file containing the SPL statements needed to> create the procedure.
> But this does not work, and returns the ubiquitous -201 (Syntax Error)
> message. Even after having qualified the file name with the complete
> path, the error persists. What am i missing here?
> I am running Informix Online 5.01 under Sun OS 5.3
> Any help will be highly appreciated!!
> Govind
>
--
regards,
+----------------------------------------------------------------------------+
| . . | |
| ... ... | Bob Baskett |
| ..... ..... | Software Engineer, DBA |
| .. ... .. | Business Systems Integration Group |
| . . . | Semiconductor Products Sector |
| | Mesa, AZ |
| Motorola, Inc. | |
|----------------------------------------------------------------------------|
| 'connectionLESS IS MORE' -- Data Broker |
|----------------------------------------------------------------------------|
| Duct tape is like the force. It has a light side, and a dark side, and |
| it holds the universe together ... |
| -- Carl Zwanzig |
+----------------------------------------------------------------------------+