Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Anyone know how to designate the output destination when con...


Justin Thomas 2

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...