ibm as400 database

[Greg Caulton]

Hi,

I have written a few Java classes that facilitate datawarehousing by
connecting to our AS400, reading rows from a specified table and
simultaneously inserting each row into an Oracle database on a box that
has far more CPU/memory etc.
This works well however since I customize the fields retrieved I need to
write code for the insert sql, select sql, oracle create table sql and
java code - at the moment I use Showcase to view the table I want and
then I type out the data like so:

Description of field FIELD type (size)

I then use a class to auto generate the code I want.

If I could query the information above (exactly as Showcase does) then
that would save me significant typing and I could automate the whole
process - just specify a table.
I only have access to a few files (the product is Infinium, a financial
system) but since Showcase can show it - I must have access to a table
that has this information.

Can anyone show me the sql I need to run to get the AS400 field name,
description, data type and size?

thanks !

Greg