RE: Create Stored Procedure DBAccess SQL File

> > >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.> > [cutting] > $ cat filename.spl | dbaccess dbname@dbserver -> >I am bound to note that if you posted that to c.u.s you would >immediately be awarded the "Useless Use of Cat" award. Don't take >offence, it's the sort of 'humour' you get on a UNIX Shell group. ;-) > >Any invocation of "cat file | command" >can be replaced with "command < file", >and that's my useless piece of information for you. :-) But isn't 'command < file' marginally slower than 'cat file | command' because of the way the line is parsed and the dups() calls made? > >Also, for those that said you must have a .sql suffix, it's just a >nice-to-have. I thought it was an essential in the example given? Paul Watson # WFSoftware Ltd # If in doubt Tel: +44 1436 674729 # make it up Fax: +44 1436 678693 # www.wfsoftware.com/informix #