Hello,
I have a file that's CCSID 819 and the processing job is 65535; every now and then the XML-SAX function throws error code 6 (invalid characters) because the file contains a ? symbol.
I've tried changing the ccsid of; the file, the %xml() function and the job in numerous combinations and I can't seem to get it to work without throwing an error.
I have then looked at ways of handling error code 6;
The last URL reads to me that it stops normal processing and only continues looking for other errors, meaning you can't make it just ignore the error or replace it with something else, like a blank? This seems to be backed up by the example which has a "return" for the XML_EXCEPTION; would this not return to the program that called the XML-SAX function, halting processing of the file?
Anyone got any ideas on how I can just ignore the invalid character and continue processing without rewriting it to use the SQL equivalents or fixing the source data? Is it going to involve checking the file first?
Cheers,
Ryan
I have a file that's CCSID 819 and the processing job is 65535; every now and then the XML-SAX function throws error code 6 (invalid characters) because the file contains a ? symbol.
I've tried changing the ccsid of; the file, the %xml() function and the job in numerous combinations and I can't seem to get it to work without throwing an error.
I have then looked at ways of handling error code 6;
The last URL reads to me that it stops normal processing and only continues looking for other errors, meaning you can't make it just ignore the error or replace it with something else, like a blank? This seems to be backed up by the example which has a "return" for the XML_EXCEPTION; would this not return to the program that called the XML-SAX function, halting processing of the file?
Anyone got any ideas on how I can just ignore the invalid character and continue processing without rewriting it to use the SQL equivalents or fixing the source data? Is it going to involve checking the file first?
Cheers,
Ryan
Comment