First at all, I would like to apologize if I am in a wrong forum.

In java api, we could use the method "ResultSetMetaData.getColumnLabel()" to get the designated column's suggested title for use in printouts and displays.

For instance, table STUDENT has column STUDENTID which the column is label as "Student ID". So, if I use method getColumnLabel(), then I should be able to get "Student ID" displayed in my column title, correct me if I am wrong.

How to create a label for a particular column? Is it created during the creation of a table? What's the SQL query shold look like?

For your information, I am using DB2 UDB v7.

Thanks in advanced.