Oninit cdi / Archive
Talk to an expert →

Create Stored Procedure DBAccess SQL File

Posted in 2000

Topics: Stored Procedures & SPL, Server Administration

KCStout — — source: Informix-list mailing list archive (1991-1998)

I am trying to create a stored procedure from the command line using dbaccess and get the following error: $ dbaccess dbname@dbserver filename.splDatabase selected. 802: Cannot open file for run. Database closed. I have the SPL file attributes set so that everyone can read/write/execute and I am attempting this as the informix user. KStout, kstout@masconsulting.com

↪ replying to KCStout
R Smith — — source: Informix-list mailing list archive (1991-1998)

kstout@masconsulting.com (KCStout) wrote in <4h6G4.1395$UQ1.140537@news- east.usenetserver.com>: >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. > >I have the SPL file attributes set so that everyone can read/write/execute >and I am attempting this as the informix user. >KStout, kstout@masconsulting.com > > > Try $ cat filename.spl | dbaccess dbname@dbserver - -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

Glossary