Re: Create Stored Procedure DBAccess SQL File

KCStout wrote: > > I am trying to create a stored procedure from the command line using > dbaccess and get the following error: > > $ dbaccess dbname@dbserver filename.spl> Database selected. > > 802: Cannot open file for run.> > Database closed. The dbaccess command expects a file with a .sql suffix. So it is looking for a file called 'filename.spl.sql' in your example. You can either rename the script, or use: dbaccess dbname@dbserver <filename.spl Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+