in TD12 I have a fastload script that in mainframe the run is OK:
drop table TDDB.TDTB_ERR1;
drop table TDDB.TDTB_ERR2;
begin loading TDDB.TDTB
DT_RIF (CHAR (10 ),Nullif=' ')
INSERT INTO DXDWH_DB.DWH_PEG_MON
In unix system (with keyword DDNAME replaced in FILE) with TD 6r2 the run is OK, but in TD12 there is the error:
**** 12:54:44 Number of recs/msg: 382
**** 12:54:44 Starting to send to RDBMS with record 1
**** 12:54:44 I/O Error on File Read: 16, Text: Unexpected data format
. Highest return code encountered = '12'.
The TTU are migrated from TTU6 to TTU12 in mainframe system and in unix system, but only mainframe is OK.
for to cast the data correctly from char type file into the target type you have to add this line after "begin loading TDDB.TDTB..." and before "DEFINE DT_RIF (CHAR (10 ),Nullif=' ')... ":
.set record text;