(I received a screenshot in private)
Sounds like the error message is formatted wrong:
Unknown field type: HREG_DIVDD
Ricardo, it is not quite clear;
is the field type called HREG_DIVDD or is the field
called HREG_DIVDD ?
Well excuse me. It seems to be obvious, but for people who don't know DB2...
The field(a column, in fact) is called HREG_DIVDD and it has a field type of TIMESTAMP (it is a type of field recognized by DB2. Smallint, char, varchar, graphics, date, time, etc are other field types)
From the sources you sent me, I cannot see it.
Can you provide a "CREATE TABLE" SQL statement
for the table DB2PRD.TRANS_ONLINE_DIVDD ?
Ya! See below!
EXEC SQL DECLARE DB2PRD.TRANS_ONLINE_DIVDD TABLE
( CIDTFD_EMPR DECIMAL(5, 0) NOT NULL,
HREG_DIVDD TIMESTAMP NOT NULL,
CSEQ_TRANS_ONLINE DECIMAL(5, 0) NOT NULL,
DPROCM DATE NOT NULL,
CIND_EXCUC_PROCM CHAR(1) NOT NULL,
RSIT_DIVDD_ATUAL CHAR(25) NOT NULL,
RSIT_DIVDD_ANTER CHAR(25) NOT NULL,
CIND_OCOR_ESTRN CHAR(1),
CIND_OCOR_CREDT CHAR(1)
) END-EXEC.
Michael.
Thank everybody
Ricardo
P.S.: Ask me more if you want.
