Power Exchange from Informatica is the one we use here. There are many interfaces VSAM is one of them, but it also has DB2 as an interface module as well.
Support is very good when it comes to trouble-shooting problem. On the workstation side we use Decision Stream and Cognos. Thanks, George Rodriguez Specialist, Systems Programmer Network & Technical Services (561) 357-7652 (office) (561) 707-3496 (mobil) School District of Palm Beach County 3348 Forest Hill Blvd. Room B-332 West Palm Beach, FL. 33406-5869 Florida's Only A-Rated Urban District For Five Consecutive Years -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Bill Washburn Sent: Thursday, June 25, 2009 1:02 PM To: IBM-MAIN@bama.ua.edu Subject: Re: VSAM Query Product 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.a spx -- 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 ----------------------------------------- Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing. ---------------------------------------------------------------------- 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