--- In [email protected], "Nico Heinze" <[EMAIL PROTECTED]> wrote: > > --- In [email protected], "Brett W. McCoy" <idragosani@> wrote: > > > > On 8/21/07, majid_burkat <majid_burkat@> wrote: > > > > > i know it might be not the right group to post this question, > > > but i thought it might some one out there who know about this: > > > in AS400 i can use the following SQL to get the name of all > > > Columns in a given table name: > > > SELECT * FROM INFORMATION_SCHEMA.COLUMNS > > > WHERE (TABLE_NAME = 'OCUSMA') > > > Q: How can i get the Column Description ? > > > i.e: OCUSMA.OKCUA1 = 'Customer address one' > > > OCUSMA.OKPHNO = 'Customer Phone number'...etc > > > is there any SQL can give you this kind of info? > > > > You're correct, this isn't the right the place to ask this > > question. I suggest you ask this on a more appropriate list. > > Also please be careful to pick the right subject when searching for an > appropriate group. I mean different things: > 1) every DB system has its own methods to store and retrieve metadata > about tables; in Oracle, DB2, Progress, and Informix you have > completely different tables and views, so the way depicted above won't > work on any other system. > 2) Why do you ask this question exactly? Do you have to retrieve these > metadata automatically via some piece of software? Then I suggest you > use either ODBC or JDBC to write something portable. > > Just my 2 pennies. > > Regards, > Nico > Thanks for replying back ... i spent 1 hour on google and i found it :) here it is for any one who care about iseries: SELECT * FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'OCUSMA'
i made it nothing is impossible right ?
