SQL Generations from DB2 tables



IBM's flagship relational database management system

SQL Generations from DB2 tables

Postby atodpquery » Fri May 28, 2010 7:34 pm

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?

8-) :? Thanks for any information
atodpquery
 
Posts: 31
Joined: Sat Nov 15, 2008 3:40 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL Generations from DB2 tables

Postby dick scherrer » Fri May 28, 2010 11:03 pm

Hello,

What kind of sql might be "generated"? Queries are rather specific rather than general. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: SQL Generations from DB2 tables

Postby atodpquery » Sat May 29, 2010 7:45 pm

SQLs to manage the insert, Update and deletion of data from databases. It is used to replicate to one environment to another environments.
atodpquery
 
Posts: 31
Joined: Sat Nov 15, 2008 3:40 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post