using System;
using com.ibm.as400.access;
using java.sql;

Connection db2conn = null;
AS400JDBCConnection db2connJT = null;
DriverManager.registerDriver(new AS400JDBCDriver());
db2conn = DriverManager.getConnection("jdbc:as400://penelope;queryTimeout=0;translate binary=true;date format=iso;time format=iso", , );
db2connJT = (AS400JDBCConnection)db2conn;

try
{
    String query = @"SELECT REPLACE(cast(current_date as char(10)),'-',''),REPLACE(cast(current_time as char(8)),'.','') FROM sysibm.sysdummy1";


    ResultSet rst = db2connJT.createStatement().executeQuery(query);
    ResultSetMetaData rsmd = rst.getMetaData();
    while (rst.next())
    {
        for (int i = 1; i <= rsmd.getColumnCount(); i++)
        {
            Console.WriteLine(rsmd.getColumnName(i) + " " + rst.getString(i));
        }
        Console.WriteLine("-----------------------------------------------------------");
    }
}
catch (ThreadAbortException abortException)
{
    Console.WriteLine((string)abortException.ExceptionState);
    db2connJT.close();
}

     db2connJT.close();