Martin Yergeau Posted June 3, 2021 Share Posted June 3, 2021 Should be related with your connection string. In below : MyConnectionName is pointing to a specific Server & DB So MyTableName will be created to specified Server & DB from MyConnectionName This is what I am using for SQLMSS, should be similar for SQLDB2 ENGINE SQLDB2 SET DEFAULT_CONNECTION MyConnecttionName TABLE FILE MySourceTbl SUM FieldB AS 'FieldB' BY FieldA AS 'FieldA' ON TABLE HOLD AS MyTableName FORMAT SQLDB2 DROP END -RUN Link to comment Share on other sites More sharing options...
Justin Thomas 2 Posted June 3, 2021 Author Share Posted June 3, 2021 Anyone know how to designate the output destination when connected to multiple databases. We are creating DB2 format hold files on one server, but connected to more than one server and would like to be able to control which server the tables are being written to. Link to comment Share on other sites More sharing options...
Toby Mills Posted June 4, 2021 Share Posted June 4, 2021 Hey Justin, Just like Martin says - its all about that DEFAULT_CONNECTION setting. Just make a separate connect string for each and switch back and forth. You can do ENGINE SQL SQLDB2 to validate that you are pointed to the right connect string. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now