Recent content by Zaldor

I attempted the BURST method, but when I attempt to write to the detail tables, I get the error: "Message: [Microsoft][ODBC driver for Oracle][Oracle]ORA-08002: sequence EDI_ID_SEQ.CURRVAL is not yet defined in this session" Any clues?

Maybe I should have clarified, how to run a functional map when there are no group items remaining, such as from an item level? What I need to do is write the output for the addresses after each item is written, it seems the burst mode is only for input? Order> Item1>Address1...

OK - new problem, but similar situation - I need to insert records for one order's items, then the address where the order is shipped for that item. Then the next item in the order, then the same address for that item. Is there any way to call a functional map from another functional map??

I figured it out - thanks for your help!! What I needed to do what create a map that fires off another executable map via a RUN() function - And passes the data via the echo command "-IE1S" Once I did that, it all fell into place!

Maybe I don't follow - how do I create an output card that references multiple database queries??

Hi - i'm having a problem with inserting records properly into a relational database - I have EDI 850 input, and I am attempting to insert into multiple tables (Header, Detail, items, etc) - The problem I am havnig is when I insert into the database, the mercator map inserts all the headers...