When trying to load data from an input file, I have also encountered an error message:
UTY4205 Record '1' of file is too short by '20' bytes
I don't know what this error means or how can I solve this error. If I am going to check the field in the input file, I will also not be able to understand what are written there since the content of the input file .DAT is encrypted unless I have successfully loaded it to the table.
Can anyone help me understand this or do you know of any reference materials or sources where I can study and understand the error codes in the Multiload processing, like UTY4205?
Are you using DBS in Japanese mode?
Rather than using $dbname.$tblname.* use the DEFINE structure matching with the schema.
If the source table has some DECIMAL column and the precision is higher than 18 (i.e. the precision is 19 or more), then in the fastexport script you should add a "DECIMALDIGITS 38" specifier in the "BEGIN EXPORT" command.
.BEGIN EXPORT SESSIONS 8 DECIMALDIGITS 38;
Default mode in fastexport is "mode indicator" where as default mode in fastload is "mode record".
So, when exporting the data using fastexport, always use "mode record" and use default mode in fastload or vice versa.
the same problem has annoyed to me also and i am looking for some appropriate solution to it, a help would be appreciated here
I've had this problem by using a "FXP->FLD" load and and I've found that the poblem was for Unicode columns... I changed them to LATIN so I solved the problem.... I expect it will be usefull for you too.