I am trying to feed this query to a DB2 database via excel. I get an error message back from the db that is complaining about syntax of a semicolon.
When I run the exact same text as a query in a native db query application it runs just fine, no issues.
Any thoughts on why sending this via Excel is a problem?
Any way to get around it aside from running each one as a separate query?
drop alias qtemp.zz1 ; drop alias qtemp.zz2 ; drop alias qtemp.zz3 ; drop alias qtemp.zz4 ; drop alias qtemp.zz5 ;