I have the following business requirement when migrating a DTS package to Datastage. In DTS, some "Execute SQL Task" contain many SQL statements. I have tested an Open command with DB2/UDB Enterprise: it accepts 1 SQL statement, not many SQL statements (I tried to separate with spaces, with ; ).
I also tried an Execute command activity, to execute the SQL statements (2 insert statements) written in a text file, but the job sequence keeps running forever. Is it a syntax problem ?
Thanks for any suggestion.
Execute many SQL statements
Moderators: chulett, rschirm, roy
Execute many SQL statements
Thuong
best regards
best regards
copy stage + connectors? Re: Execute many SQL statements
If the statements don't need to be ordered, you could use a copy stage to feed the same data to multiple db-connectors: e.g. 1 statement per connector.
By the way, how many sql statements is "many"? 10? 500? 1,000? More?
And what kinds of statements... Lots of insert statements? Or conditional insert/update/delete logic?
And how long will this logic need to be used & maintained?
andy's idea is cleaner, but for a quick & dirty one-time migration maybe that isn't so bad.
John
By the way, how many sql statements is "many"? 10? 500? 1,000? More?
And what kinds of statements... Lots of insert statements? Or conditional insert/update/delete logic?
And how long will this logic need to be used & maintained?
andy's idea is cleaner, but for a quick & dirty one-time migration maybe that isn't so bad.
John