We use one called TcAccess by GT Software. I believe it is called Ivory Data Access now. Sounds very similar.
"McKown, John" <jmck...@healthma RKETS.COM> To Sent by: IBM IBM-MAIN@bama.ua.edu Mainframe cc Discussion List <ibm-m...@bama.ua Fax to .edu> Subject Re: VSAM Query Product 06/25/2009 11:53 AM Please respond to IBM Mainframe Discussion List <ibm-m...@bama.ua .edu> > -----Original Message----- > From: IBM Mainframe Discussion List > [mailto:ibm-m...@bama.ua.edu] On Behalf Of John P Kalinich > Sent: Thursday, June 25, 2009 10:40 AM > To: IBM-MAIN@bama.ua.edu > 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 john.mck...@healthmarkets.com * 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 lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html