Finding (and changing) ZSQL methods with given ODBC connectors
We're looking at a desire to find all ZSQL methods that have a given ODBC connector and changing the connector they're using. Today, we could use Zopelabs' "Display All ZSQL Methods" recipe (http://www.zopelabs.com/cookbook/994372502) to find ZSQL methods, but I'm having a bit of a problem limiting this to just the ones that have the ODBC connector; then, I'm also looking for pointers on changing it (though I assume once I know how to query for it I'll know how to set it?). Any useful pointers? -roy Content-Type: text/plain; charset="iso-8859-1" ------------------------------------------------- PLEASE READ THIS WARNING: Investment in securities involves the risk of loss. Past performance is no guarantee of future returns. Other methods may produce different results, and the results for different periods may vary depending on market conditions and the composition of the portfolio. Warning: Do not send time-sensitive, action-oriented messages, such as transaction requests, via e-mail as it is our policy not to accept such items electronically. All e-mail sent to or from this address will be received or otherwise recorded by the Fisher Investments corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient.
On Wed, 2004-03-10 at 19:56, Roy Rapoport wrote:
We're looking at a desire to find all ZSQL methods that have a given ODBC connector and changing the connector they're using. Today, we could use Zopelabs' "Display All ZSQL Methods" recipe (http://www.zopelabs.com/cookbook/994372502) to find ZSQL methods, but I'm having a bit of a problem limiting this to just the ones that have the ODBC connector; then, I'm also looking for pointers on changing it (though I assume once I know how to query for it I'll know how to set it?).
Any useful pointers?
try the original of all these get sql and edit sql methods, which is a python script to boot.. http://www.zopelabs.com/cookbook/1003271138 much easier to modify. already gets the conn_id as well. -kapil
participants (2)
-
Kapil Thangavelu -
Roy Rapoport