Select on table

Dear All, Informix 7.30 - FC6 HP-UX 11.0 We are having a few problems. As informix we are trying to run a select through dbaccess on a table select * from ttiitm001700 However, we get the following error 206: The specified table (INFORMIX.ttiitm001700) is not in the database. 111: ISAM error: no record found. When we put the schema name in we get the folowing, 206: The specified table (BAAN.ttiitm001700) is not in the database. 111: ISAM error: no record found. We can query the table if we log in as baan or through dbaccess Table Info. Cheers, Howard

See if permissions have been reviked from user informix. By default use informix has DBA privelege on all databases but they can be revoked. (SELECT * from sysusers;) Art S. Kagel "howard.jones" wrote: > > Dear All, > Informix 7.30 - FC6 HP-UX 11.0 > > We are having a few problems. > > As informix we are trying to run a select through dbaccess on a table > > select * from ttiitm001700> > However, we get the following error > > 206: The specified table (INFORMIX.ttiitm001700) is not in the database. > 111: ISAM error: no record found.> > When we put the schema name in we get the folowing, > > 206: The specified table (BAAN.ttiitm001700) is not in the database. > 111: ISAM error: no record found.> > We can query the table if we log in as baan or through dbaccess Table Info. > > Cheers, > > Howard