I want to execute multiple lines of DDL and DML commands from a file in datastage.
I have used the ODBC connector with the write mode selected as user defined SQL and the and the SQL statements are available in the file.
But the connector stage is not executing the file. If anyone can provide me with guidance it would be greatly appreciated.
Thanks