IBM Mainframe Forum

I know that Platinum tool has the functionality to generate SQL to UNDO changes into the DB2 databases by running a LOG ANALYSER. I am not sure SQL Assist is it a tool to generate SQLs (DML) driectly from DB2 tables. If not, Is there tool which can generate SQL directly from DB2 tables. Any off the shell products to do it?

Thanks for any information

Hello,

What kind of sql might be "generated"? Queries are rather specific rather than general. . .

SQLs to manage the insert, Update and deletion of data from databases. It is used to replicate to one environment to another environments.