Problem with DATALOAD command in LONG values case

[Yuliya Fedorova]

Hello!

I have a problem during DATAEXPORT/DATALOAD  operations. I try to run
this commands:
        DATAEXTRACT "PATYPS$ID","S$VERSIONID","description"
                FROM CMDEV."PATYP_" WHERE "PATYPS$ID" IN (SELECT S$ID
FROM CMDEV."PATYP" WHERE S$MODELID=2) 
                WITH LOCK 
                OUTFIELDS 
                        "PATYPS$ID"     1 
                        "S$VERSIONID"   2 
                        "description"   3 
                OUTSTREAM 'c:/testExport/PATYP_.dat'
                LONGFILE "description"
'c:/testExport/PATYP__description.dat'

for data export and
        
        DATALOAD TABLE CMDEV."PATYP_" 
                "PATYPS$ID"     1
                "S$VERSIONID"   2 
                "description"   3 DEFAULT NULL
        INFILE 'c:/testExport/PATYP_.dat'
        LONGFILE "description" 'c:/testExport/PATYP__description.dat'   

for data import.

But after DATALOAD command's run I saw that first imported "description"
had value like "???..??". I tried to use different data types (my column
has a LONG UNICODE type). For example UTF8, UCS2 during unloading and
ASCII, UTF8, UCS2 during loading operations. But I haven't got correct
answer yet. 

And I found one interesting thing:

Content of 'c:/testExport/PATYP_.dat':
        "1","2","3-42"
        "2","2","43-92"
        "3","2","93-166"
        "4","2","167-180"

I corrected first row as "1","2","1-42" and import this file. The first
imported "description" had actual string value plus first letter of
second record. All other records had correct values. 

Could you help me in this situation?

Thank you.


Best Regards,
Yuliya Fedorova
Software Engineer