Unanswered: data dump/query without using connection resource
I have been asked to "find a way" (as I have been assured it can be done) of performing a dump of the data in two columns in a table, that does NOT involve using a database connection resource [stop laughing at the back]
I'm pretty sure that no matter WHAT method is used to retrieve this data, a connection resource MUST be used.
Can someone confirm this either way.. that it can't be done, without a connection resource, or that there's some third party tool or whatever that can do it.
I'm relatively new to DB2, but I find the concept of being able to query data within tables without using the database connection resources a rather scary thought.
Why is this wanted? This can be known as security subversion.
There are a number of third party tools that, given sufficiently detailed information about the way the data is stored can do an unload of data (ready to load into another table). Check the usual suspects.