dbschema

Command issued: dbschema -d my_database -t my_table Output:No table or view my_table. But the table my_table does exist in my_database. (A CRCOL was added to my_table before dbschema was issued, though. Will this make a difference?) Any help is appreciated.

It should not make a difference. Version? Platform? Does the table appear in the output when you run just 'dbschema -d my_database'? Or 'dbschema -d my_database -ss'? Have you tried to see if myschema can see the table? Can you see the table in dbaccess table>info>my_table? Art S. Kagel ----- Original Message ----- From: Lixin Wu <lixinwufeng@yahoo.com> At: 3/15 11:17 > Command issued: > dbschema -d my_database -t my_table > Output:> No table or view my_table. > > But the table my_table does exist in my_database. (A CRCOL was added to my_table > before dbschema was issued, though. Will this make a difference?) > > Any help is appreciated.

Run update statistics on sysmaster and try your command again. LIXIN WU <lixinwufeng@yahoo.com> wrote:Command issued: dbschema -d my_database -t my_table Output:No table or view my_table. But the table my_table does exist in my_database. (A CRCOL was added to my_table before dbschema was issued, though. Will this make a difference?) Any help is appreciated. Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam

----- Original Message ----- From: "LIXIN WU" <lixinwufeng@yahoo.com> To: <ids@iiug.org> Sent: Monday, March 15, 2004 3:37 PM Subject: dbschema [2674] > Command issued: > dbschema -d my_database -t my_table > Output:> No table or view my_table. > > But the table my_table does exist in my_database. (A CRCOL was added to my_table before dbschema was issued, though. Will this make a difference?) > It does not exist at least not as a table Do select tabtype from systables where tabname = "<tablename>" and d dbschema -d x -s all Perhaps it is a synonym ?? or something else? > Any help is appreciated. > > >