Anyone working with GIS/GENTRAN Server with Oracle? 1

[RogerH1889]

Hello Everyone -

I'm new to the world of EDI and inherited a multi-platform setup where one unit is utilizing GENTRAN Server for Windows (4.0.1)and the other is using GIS for Windows (4.1) both linked to Oracle. I'm having difficulties with an outbound 810 on the GIS side where I am trying to edit a datafield during the export translation through the map and my changes are apparently being over-written by the ProcessData value originally extracted from the Oracle tables. Anyone know how I can use an Extended Rule to edit the output from the 0067 element before sending out the EDI file? (I need to remove the first 3 characters from the output prior to transmitting it to the trade partner).

I tried using a conditional statement

If $INPUT.#Trading_Partner_Code = "XYZ" Then
Ship_To = mid(#0067,3,4);
else
Ship_To = left(#0067,4);

but there was no result. Placing the code as an ER in the #0067 element directly (along with another statement that empties the #0066 field if #0067 is empty) and attempting to update the ProcessData afterwards, I get an error message that 'WHEN' is expected by the compiler. Can anyone familiar with GIS walk me through coding this to update the ProcessData with the new 4 digit value?

Thanks for the assist!

 

[RonPro]

I don't work with the GIS suite - but I have often found in regular old GENTRAN server that NOT directly using the #0067 (an example for this situation only) is crucial. That is, create a temporary record (with tag $$$) and set up a couple temporary storage fields/elements in the record. Store the contents of the #0067 (again, just for this example) in one of the temp fields. This makes the data more presistent - I've actually lost data value at times and this technique holds the value for the duration of the map or iteration of loop you need it for.

From that, then, use the "temp storage" variable in your ERs.

Not guaranteeing this will work but it has helped me.

 

[CatPlus]

Roger,

Call Sterling Commerce 800-GENTRAN. I have found them extremely helpful.

If it gets extended, Sterling offers consulting at an hourly rate of $200... it will save you a lot of headaches and time!

HTH
Mickey