how do i retrive column names from a given table?

See more: (untagged)

i need to retrieve column names from a database, when a table name provide as a parameter to the sql query.

select c.name as SC_DATA_COL_NAME  from sys.tables v,sys.columns c where v.object_id=c.object_id and upper(v.name)=upper(@name) 

here @name is used as a parameter

above query works fine in sql server but not in DB2, please give some suggestion to create a query which runs on DB2.