Execute many SQL statements
Posted: Mon Apr 18, 2011 9:49 am
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.
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.