Creating EDI large documents

, ,
1

I have a question that is related to creating an EDI document in webMethods IS and sending it out through TN.

I have a service that pulls data from a database and then needs to format the records into an EDI 867 document. My concern is that the number of records I get from the database could get very large. So instead of getting all of them at the same time, I would like to read them one at a time, convert each record into some edi string using convertToString.

Can somebody tell me a way to do this ? I dont think I can call convertToString in a loop concatenating the results from each call and still end up with a valid edi document as some segments and control numbers get duplicated.

Is there a way to achieve this ?

2

Hey Rupinder

You can call the converttoString in a Loop, for more details/help check the Service Tutorial.XMLtoEDI:processXMLSource under EDI Samples package.

HTH

Uday

3

Thanks Uday,

But the sample is not sufficient for my needs. Instead of creating individual documents from each row I want to be able to create one EDI document from all rows. And I dont have the rows in a list.

So what I want to do is something like this :

  1. REPEAT
    1a. Get the next record from database
    1b. Add it to the EDI document

  2. create group for EDI document

  3. Create envelope for EDI document

  4. Send document

4

Rupiner,

What kind of this rows are? Are they records of IDOC or any other RDBMS record or XML records?