Error to convert text data in Fastload TD12

Tools

Error to convert text data in Fastload TD12

hi,

in TD12 I have a fastload script that in mainframe the run is OK:

tenacity 5;

sleep 4;

.LOGON TDP4/xxxxx,yyyyyy;

ERRLIMIT 1;

drop table TDDB.TDTB_ERR1;

drop table TDDB.TDTB_ERR2;

begin loading TDDB.TDTB

errorfiles TDDB.TDTB_ERR1,

TDDB.TDTB_ERR2

;

DEFINE

 DT_RIF           (CHAR (10 ),Nullif='         ')                                                                                                                                        

,COD_TD           (CHAR(4))                                                                                                                                                               

,DESC_TD          (CHAR(96))                                                                                                                                                              

DDNAME=DDOUT;

INSERT INTO DXDWH_DB.DWH_PEG_MON

(

 DT_RIF                                                                                                                                                                                            

,COD_TD                                                                                                                                                                                             

,DESC_TD                                                                                                                                                                                           

)

VALUES (

 :DT_RIF                                                                                                                                                                                           

,:COD_TD                                                                                                                                                                                           

,:DESC_TD                                                                                                                                                                                                                                                                                                                                                                          

);

END LOADING;

LOGOFF;

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.

Thanks, Sergio

1 REPLY

Re: Error to convert text data in Fastload TD12

Hi Sergio,

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;

bye