Hi

I have created a AS400 input component.
Among the fields I want there is one that is called invoice description. In our AS400 this is set to type NCHAR(24)
When I look at the schema design I see that it is set with type String and DB Type to varchar.
It failes at the very first line. The text it finds is "2412 FEILBET."

My error code:
[statistics] connecting to socket on port 3671
[statistics] connected
Exception in component tAS400Input_1
java.sql.SQLException: Data type mismatch. (For input string: "2412 FEILBET.")
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
    at com.ibm.as400.access.SQLChar.getFloat(SQLChar.java:464)
    at com.ibm.as400.access.AS400JDBCResultSet.getFloat(AS400JDBCResultSet.java:2869)
    at as400_mitmas.fapred_0_1.FAPRED.tAS400Input_1Process(FAPRED.java:700)
    at as400_mitmas.fapred_0_1.FAPRED.runJobInTOS(FAPRED.java:1065)
    at as400_mitmas.fapred_0_1.FAPRED.main(FAPRED.java:936)

I have tried to alter the line so it has "FEILBET". Still the same error.

Anyone got ideas on why this happends?

Dan