FTP Stage
Posted: Tue Aug 07, 2007 2:28 pm
I am doing transferring files from Mainframe to server through FTP Stage of Server Edition. I found jobs aborted due to a Null Value for a 'Not Null' filed, but the acutual 'Not Null' field has a value.
Error message:
DBOBJftp..Transformer_1: Not enough columns (row 3), and column 'DB_OBJ_EDT' is not 'nullable'.
Each time job aborted, the error messaged mentioned the last 2 fields having Null values, but one of the middle 4 fields has a Null value in the acutual file.
Does anyone have this experience and know how to handle this issue?
See the columns definitions
Column definition:
DB-OBJ-ID Integer(4) Not Null
DB-TBL-NM Char(7) Not Null
REFERENCE-TBL-NM Char(30)
DB-PRTN-NM Char(11)
PRTN-LOW-BNDRY-VAL Char(10)
PRTN-UPR-BNDRY-VAL Char(10)
DB-OBJ-EDT Date Not NUll
DB-OBJ-XDT Date Not Null
Appreciate for any repply
Thanks
Error message:
DBOBJftp..Transformer_1: Not enough columns (row 3), and column 'DB_OBJ_EDT' is not 'nullable'.
Each time job aborted, the error messaged mentioned the last 2 fields having Null values, but one of the middle 4 fields has a Null value in the acutual file.
Does anyone have this experience and know how to handle this issue?
See the columns definitions
Column definition:
DB-OBJ-ID Integer(4) Not Null
DB-TBL-NM Char(7) Not Null
REFERENCE-TBL-NM Char(30)
DB-PRTN-NM Char(11)
PRTN-LOW-BNDRY-VAL Char(10)
PRTN-UPR-BNDRY-VAL Char(10)
DB-OBJ-EDT Date Not NUll
DB-OBJ-XDT Date Not Null
Appreciate for any repply
Thanks