Problem with DATALOAD command in LONG values case

"Yuliya Fedorova" <[email protected]>
Newsgroups gmane.comp.db.maxdb
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.