GentranEx and extended rules

[idmnstr]

Does anyone have some examples of running SQL from extended rules?

Looking for some help with Gentran for Windows. I have modified an outbound map to create a temp record. I want to use the contents of the temp record to perform an INSERT into an Oracle db table. The table is a new table I created that is not one of the GENTRAN tables. It is in the same DB.

Regards,
Jim

 

[edijedi]

I suggest getting a translator that can read and write via ODBC, sounds like it would make your life much easier!

 

[idmnstr]

I would like to thank "edijedi" for the response. This is an alternative that is not feasible at this time.

 

[JBDev]

You should be able to do this by creating an outbound ODBC map in Gentran.

 

[idmnstr]

Thank you for your suggestion on creating an ODBC map.

I am currently making changes to Proportional to EDI map. Within this map I create a temp record that contains the data for a SQL insert.

This is working fine using an ADODB solution. This requires a UserId and Password to connect to the db.

I would like to get the same process working using GentranEx. It does not require the UserId and password. Currently, It inserts once and then fails on the second. The test data I am using would create two EDI documents that should perform two inserts.

Regards,
Jim