对于DB2 for i，此信息位于

qsys2.syscolumns2  (for 7.1+, better performance if just looking at 1 table's columns)
qsys2.syscolumns (for any recent version)

ODBC/JDBC和DB2 LUW v8兼容

sysibm.sqlcolumns

ANSI/ISO标准

INFORMATION_SCHEMA.columns

(note INFORMATION_SCHEMA是QSYS 2的同义词）
目录视图的完整列表如下：http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzcatalog.htm

此信息可在表syscat.columns中找到。

另一种方法是从Linux bash shell执行db2命令：

$ db2 "DESCRIBE TABLE A" |awk '{printf "%s\t",$1} END{print}'

db400（IBM i）中任意表（PF）的列名，我们可以使用java程序检索列名.示例代码：

String sql = "select * from KFILNBB.V_OCADATA";
PreparedStatement pstmt = StaticUtil.getDB2Connection().prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();

ResultSetMetaData rs1 = pstmt.getMetaData();

ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
System.out.println(rsmd.getColumnLabel(1));

// -------------------db2 connection----------

    public static Connection getDB2Connection() throws ClassNotFoundException, SQLException {
            String DRIVER_NAME = "com.ibm.as400.access.AS400JDBCDriver";

            String URL = "jdbc:as400://ibm i IP address";
             String USERNAME = "username";
            String PASSWORD = "password";
            Class.forName(DRIVER_NAME);
            return DriverManager.getConnection(URL , USERNAME, PASSWORD);
        }