Problem with Byte field on fastload

General

Problem with Byte field on fastload

Hi there,

Could anybody help me to look at this? Thanks in advance!

I met some problems when I use fastload:

Error messages:
Fastload: Incorrect number of bytes returned from a File Read

fast export script:

.logtable DP_DEDW_MDB.XM_ACCOUNT_LOAD_LOG;
.LOGON 11.11.11.1/user,pass;

.begin export sessions 8;
.export outfile fast.out mode record format fastload;

select
trim(TRAILING '0D'XC FROM trim(TRAILING '0A'XC from TRIM(coalesce (cast (feed as VARCHAR(50)) ,''))))|| '|' ||
trim(TRAILING '0D'XC FROM trim(TRAILING '0A'XC from TRIM(coalesce (cast (subfeed as VARCHAR(50)) ,''))))|| '|' ||
trim(TRAILING '0D'XC FROM trim(TRAILING '0A'XC from TRIM(coalesce (cast (key1 as VARCHAR(120)) ,''))))|| '|' ||
trim(TRAILING '0D'XC FROM trim(TRAILING '0A'XC from TRIM(coalesce (cast (key2 as VARCHAR(120)) ,''))))|| '|' ||
trim(TRAILING '0D'XC FROM trim(TRAILING '0A'XC from TRIM(coalesce (cast (key3 as VARCHAR(120)) ,''))))|| '|' ||
trim(coalesce (trim(trailing '.' from batchid) ,'')), '|'
,hashvalue (format 'X(16)')
from dp_vedw_mdb.mdb_hist_sr
sample 10;

.end export;
.logoff;
.exit;

The flat file:

A8MDB_ACCOUNT_SR|BILLINGCONTACTCHANGEFLAG|0000000000|||322|ñ¿D
A8MDB_ACCOUNT_SR|SERVICECONTACTCHANGEFLAG|1111111111|||326|àÙ2
@7MDB_ACCOUNT_SR|SERVICECONTACTCHANGEFLAG|2222222222|||334|²ú@*

The fastload script:

.sessions 2;
.errlimit 2;

.logon 11.11.111.111/user,pass;

SET RECORD unformatted;

DEFINE
feed (char(14)), a (char(1)), subfeed (char(24)),b (char(1)), key1 (char(12)),c (char(1)),key2 (char(1)) ,d (char(1)),key3 (char(1)), e (char(1)), batchid (char(3)) ,g (char(1)), hashvalue (char(8))
FILE=./hist.out;

begin loading DP_WEDW_SND.MDB_HIST_XM_BACKUP errorfiles DP_WEDW_SND.error_adsss, DP_WEDW_SND.error_bdsss ;

insert into DP_WEDW_SND.MDB_HIST_XM_BACKUP.*;

end loading;

.logoff
.quit

The table:

CREATE SET TABLE DP_DEDW_MDB.MDB_HIST_SR ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Feed VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
SubFeed VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,
Key1 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
Key2 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
Key3 VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
HashValue BYTE(4),
BatchID DECIMAL(38,0) COMPRESS (0. ,1. ,2. ,3. ,5. ,6. ,8. ,9. ,10. ,11. ,12. ,13. ,14. ,15. ,18. ,19. ,20. ,21. ,22. ,23. ,24. ,25. ,26. ,27. ,28. ,29. ,30. ,31. ,33. ,34. ,35. ,36. ,37. ,38. ,42. ,43. ,44. ,45. ,49. ,64. ,65. ,72. ,74. ,78. ,80. ,81. ,82. ,83. ,87. ,95. ,97. ,100. ,101. ,102. ,103. ,105. ,107. ,112. ,113. ,114. ,116. ,121. ,122. ,125. ,126. ,128. ,130. ,131. ,134. ,137. ,138. ,140. ,141. ,142. ,144. ,145. ,149. ,150. ,152. ,153. ,154. ,160. ,162. ,165. ,166. ,167. ,168. ,169. ,173. ,176. ,181. ,183. ,185. ,187. ,188. ,189. ,190. ,194. ,195. ,201. ,202. ,204. ,205. ,208. ,209. ,210. ,212. ,214. ,215. ,216. ,221. ,223. ,224. ,226. ,230. ,231. ,232. ,233. ,234. ,235. ,236. ,241. ,242. ,243. ,-2. ,-1. ))
PRIMARY INDEX ( Feed ,SubFeed ,Key1 ,Key2 ,Key3 );
Tags (3)