help

hi friends mostly i work with oracle databases but hier in our company they have website on informix database.My question is how can i display the tables on the database,we have problem her there is one table that users they can't exucute i know the name of the table but i don't know how to find it. we run informix dynamycserver v 7.31 thanks

In article <395A124B.CC30EE27@hsv.se>, Minas Ghidei <minas.ghidei@hsv.se> wrote: > hi friends > > mostly i work with oracle databases but hier in our company they have > website on informix database.My question is how can i display the tables > on the database,we have problem her there is one table that users they > can't exucute i know the name of the table but i don't know how to find > it. > we run informix dynamycserver v 7.31 > thanks > > Do you mean you want to see the table definition? If so, use dbaccess. dbaccess <database name> Then, in the menus... Table Info <table name> -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.

For Table Definition, dbschema -d database_name -t table_name -ss >>file1 For All objects in Database, dbschema -d database_name -ss >>file2 For more information, dbschema -- Minas Ghidei <minas.ghidei@hsv.se> wrote in message news:395A124B.CC30EE27@hsv.se... > hi friends > > mostly i work with oracle databases but hier in our company they have > website on informix database.My question is how can i display the tables > on the database,we have problem her there is one table that users they > can't exucute i know the name of the table but i don't know how to find > it. > we run informix dynamycserver v 7.31 > thanks >