dbschema

Posted in 2004

Summary

Lixin Wu got 'No table or view my_table' from dbschema -t although the table existed. Art Kagel asked for version and platform and suggested checking with dbschema -d alone, -ss, and dbaccess. Ravi T suggested running update statistics on sysmaster. David Williams suggested checking tabtype in systables, as it might be a synonym. No outcome was reported.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

LIXIN WU — Mon, 15 Mar 2004 15:37:55 — source: IIUG Forums & Mailing Lists

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.

↪ replying to LIXIN WU

ART KAGEL, BLOOMBERG/ 499 PARK — Mon, 15 Mar 2004 16:24:50 — source: IIUG Forums & Mailing Lists

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.

↪ replying to LIXIN WU

Ravi T — Mon, 15 Mar 2004 17:42:47 — source: IIUG Forums & Mailing Lists

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

↪ replying to LIXIN WU

David Williams — Mon, 15 Mar 2004 20:16:01 — source: IIUG Forums & Mailing Lists

----- 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. > > >