Hi. I have created a query on the iSeries machine and then stored the results in a database file (pf). I then try to transfer the file to excel using the iAccess plugin. However I get the following error: CWBDB0052 - Error during data conversion. Any help would be greatly appreciated. Thanks
I wouldn't expect null values at first, though they do need to be considered. I'd first ensure that the QCCSID system value was set correctly and that the query result file had a reasonable CCSID. If the data is being generated and then transferred as CCSID 65535, it should be corrected.
If a reasonable CCSID is set, then I'd look for nulls.
I see this is a 9401. What version of OS/400 is installed and what version of Client Access is used?
Tom
Thank you both for your input.
I have checked the QCCSID... the value is set to 65535 (which based on what I've read means the data is not converted).
Therefore what value should I set it to?
Another bit of info: I tried the 'transfer to excel' again but this time Instead of manually entering the file name to be transferred, I selected browse instead. The system log on screen appears but after entering my details I get the same Error during data conversion.
This usually is a data issue. Alpha chars in a numeric field, for example. Also, do you have the option to store numerics in an char column checked? Check that the columns line up correctly with the database.
Was this a join query - two files - one reported even when the matching entry in the other is missing? Including fields from both files? This type of query would/could return null values. These would explain your problem.
Phil
Are you transferring into an existing pre defined Excel worksheet or is this new?
Check the PF you created and look at the field definitions. Do they look correct?
Can you view the file on the I-series without any problems? Can you transfer other files ok? Does your file have any fields defined in the query that may have exceeded you size definition? (ex. from doing a calculation)
Discuss This Question: 8  Replies