load error

I'm getting a weird error when I attempt to load data into a table from a file. I'm running Informix 7.31.UC2 on HP-UX 10.20. Here is the error: $ dbaccess test - Database selected. > set lock mode to wait; Lockmode set. > load from add_ie3 insert into user_test; 404: The cursor or statement is not available. 404: The cursor or statement is not available. Error in line 1Near character position 41 > My add_ie3 file has the same number and type of columns as the user_test table. The 404 error just doesn't make any sense to me in this context. Has anyone else run across this? Thanks, Nick

I just noticed that I can load the file in question fine if I do so as the user informix and another user. However, my account and another account can not load the file. Is there a system table in Informix that restricts which users can access which tables? Thanks, Nick In article <89ok72$rst$1@copland.udel.edu>, Nicholas Pieter Heesters Jr. <heesters@copland.udel.edu> wrote: >I'm getting a weird error when I attempt to load data into a table >from a file. I'm running Informix 7.31.UC2 on HP-UX 10.20. Here >is the error: > >$ dbaccess test -> >Database selected. > >> set lock mode to wait;> >Lockmode set. > >> load from add_ie3 insert into user_test;> > 404: The cursor or statement is not available.> > 404: The cursor or statement is not available. >Error in line 1>Near character position 41 >> > >My add_ie3 file has the same number and type of columns as the >user_test table. The 404 error just doesn't make any sense to >me in this context. Has anyone else run across this? > >Thanks, >Nick

In article <89p1eh$jh3$1@copland.udel.edu>, heesters@copland.udel.edu (Nicholas Pieter Heesters Jr.) wrote: > I just noticed that I can load the file in question fine if I do > so as the user informix and another user. However, my account and > another account can not load the file. Is there a system table in > Informix that restricts which users can access which tables? > > Thanks, > Nick > > In article <89ok72$rst$1@copland.udel.edu>, > Nicholas Pieter Heesters Jr. <heesters@copland.udel.edu> wrote: > >I'm getting a weird error when I attempt to load data into a table > >from a file. I'm running Informix 7.31.UC2 on HP-UX 10.20. Here > >is the error: > > > >$ dbaccess test -> > > >Database selected. > > > >> set lock mode to wait;> > > >Lockmode set. > > > >> load from add_ie3 insert into user_test;> > > > 404: The cursor or statement is not available.> > > > 404: The cursor or statement is not available. > >Error in line 1> >Near character position 41 > >> > > > >My add_ie3 file has the same number and type of columns as the > >user_test table. The 404 error just doesn't make any sense to > >me in this context. Has anyone else run across this? > > > >Thanks, > >Nick > > Check to see if you have insert permission on the table. dbaccess test table, info <select table> Priviledges Look for your user id or public and see if the insert column says yes. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.