Question & Answer
Question
Document extraction map is not correctly splitting documents for JD Edwards data (SCI62982) *|* -AB3CB58877498CC78525791800433802- *|*
Answer
Technote (troubleshooting)
Problem(Abstract)
Document extraction map is not correctly splitting documents for JD Edwards data (SCI62982)
Symptom
Map for the Document Extraction Service is not properly splitting the input file.?
Document extraction only splits the first document. then appends subsequent splits onto first split.
Cause
The extended rule did not properly account for the quotes around the data fields for JD Edwards data
Resolving the problem
Modified the extended rule to account for the quoted data.? To validate when to split the documents the extended rule looks at the left-most two characters which equate to "1.? It then looks at the right-most character within that selection which is 1.?
string[1024] buffer;
string[1] match;
integer match_len;
// set these next two variables as desired
match = "1"; // header tag
match_len = 1; // the length of the tag
// read the block we're on and write it
readblock(buffer);
writeblock(buffer);
// keep reading and writing records until the end of the document
while readblock(buffer) do
begin
? if right(left(buffer 2)match_len) = match | buffer = "" then
? begin
??? unreadblock();
??? break;
? end
? writeblock(buffer);
end
Historical Number
PRI32578
Product Alias/Synonym
Fact
Gentran Integration Suite All Releases
Sterling Integrator All Releases
Document Extraction Service
Map Editor
JD Edwards data
Individual data fields are quoted
SCI62982
Was this topic helpful?
Document Information
Modified date:
12 October 2021
UID
ibm10767835