Querying schema/description

[SilRay]

I will admit up front that this is to help with an assignment for a class, however, I'm looking for information outside the scope of the assignment because I want to do something cooler. The assignment is intended to demonstrate the ability to query against a joined table. I am supposed to get the values for all fields of a given datatype within these 2 tables that are joined. The teacher expects that we will look at the descriptions of the tables to figure out which fields to query for, but I think that is kinda lame, and would rather do it by running a sub query.

The DESCRIBE TABLE command appears to return a table, but when I tried

SELECT * FROM (DESCRIBE TABLE [TABLENAME])

, I got an error. I also found some things (on this forum) about SYSCAT.TABLES, but I couldn't see how to get the information I was looking for out of that either.

Can anyone point me to a solution on how to get the datatype of a field (or other table metadata) in a form that I could use in this situation, or another solution that would affect the same result? Anything would be much appreciated.

::UPDATE::
OK, I've figured out a query to get the field names, but now I need to query for each of the items I generated in the join of the two tables. I'll post the code for the subquery below. For background, there are only 2 tables in the schema, so I don't need to explicitly define which tables I want to get the data from since I explicitly define the schema in which only the 2 tables I want to look at exist. Here's the code for the subquery

SELECT TABNAME||'.'||COLNAME variable FROM SYSCAT.COLUMNS WHERE TABSCHEMA = 'DBGUESTG' AND (TYPENAME = 'CHARACTER' OR TYPENAME = 'VARCHAR')

I need to use thet results of that query for the names of the columns I query for in the join of the 2 main tables.

[SilRay]

So I've managed to deduce that even if I can get it down to one element from the subquery, it interprets it as a string literal instead of a column name. So in addition to the pivot and looping concatanation, I also need to know how to convert a string literal in to a field name. Any tips?