Hi people, have a mess here with some supposed binary data in a TXT file on IFS to get into a DB2.
I had tried CPYFRMPCD, CPYFRMIMPF but none of them helped me. Tried also by FTP, neither.
Here i attach de original TXT file to import and an excel (rename .DOC file to .XLS) file with de description of that TXT data structure, for us to play.
On the excel file on DETALLE flap, where have the complete file fields descriptions, the most important one for me is the one coloured in blue, that is an amount but in binary format.
For the beggining my DB2 DDS is plain of legtht char 600. For me is the same to have this DDS with all fields defined or plain with only one.
For example if you try to open the TXT with NotePad, will be opened perfect, but try with UltraEdit and it truncated data, same as happens on the iSeries.
My real problem is that when getting it on DB2, some records got truncated because of a special character that does this job.
I attach too, some green screens of the issue.
Any help would be very appreciated!!
I had tried CPYFRMPCD, CPYFRMIMPF but none of them helped me. Tried also by FTP, neither.
Here i attach de original TXT file to import and an excel (rename .DOC file to .XLS) file with de description of that TXT data structure, for us to play.
On the excel file on DETALLE flap, where have the complete file fields descriptions, the most important one for me is the one coloured in blue, that is an amount but in binary format.
For the beggining my DB2 DDS is plain of legtht char 600. For me is the same to have this DDS with all fields defined or plain with only one.
For example if you try to open the TXT with NotePad, will be opened perfect, but try with UltraEdit and it truncated data, same as happens on the iSeries.
My real problem is that when getting it on DB2, some records got truncated because of a special character that does this job.
I attach too, some green screens of the issue.
Any help would be very appreciated!!
Comment