Built-In Services For Connections - WebMethods

Integration Server provides built‐in services that enable you to programmatically control connections.b You can use them to enable and disable a connection, and to return usage statistics and the current state (Enabled or Disabled) and error status for a connection. These services are located in the WmART package, in the pub.art.connection folder.

There are two built‐in services, setAdapterServiceNodeConnection and setPollingNotificationNodeConnection, that enable you to change the connection associated with an adapter service or notification respectively.

This is going to help you a lot and save you so much time if you haven't worked with this tool before.

Max number of values in IN clause

Somebody asked me about this a few days ago, and this person (really sure of what he was talking about) told me: "You can only pass a limit of 200 items in a IN clause (during a DELETE)"

I'm not an Expert DBA (know it all), but I do remember that you can pass up to 1000 elements. And that was my counter argument to this guy (as always if you don't believe me double check with your best friend or test it
In the past it used to be 256 elements, but that was in Oracle 8.