> -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:[email protected]] On Behalf Of John P Kalinich > Sent: Thursday, June 25, 2009 10:40 AM > To: [email protected] > Subject: VSAM Query Product > > Is there a software product available that can query VSAM > files using a > generalized query language? > > Regards, > John K
We have PowerExchange by Informatica. It runs as an STC. It allows our Business Intelligence people to do SQL-like queries against various VSAM and sequential files from their PCs, using a "client" software. I don't know much about it. I do know that you need to create "data maps" from your COPYBOOKS so that the product knows where the fields are. http://www.informatica.com/products_services/powerexchange/Pages/index.aspx -- John McKown Systems Engineer IV IT Administrative Services Group HealthMarkets(r) 9151 Boulevard 26 * N. Richland Hills * TX 76010 (817) 255-3225 phone * (817)-961-6183 cell [email protected] * www.HealthMarkets.com Confidentiality Notice: This e-mail message may contain confidential or proprietary information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. HealthMarkets(r) is the brand name for products underwritten and issued by the insurance subsidiaries of HealthMarkets, Inc. -The Chesapeake Life Insurance Company(r), Mid-West National Life Insurance Company of TennesseeSM and The MEGA Life and Health Insurance Company.SM ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
