There is Fileaid from Compuware and Insync for Macro4 both do Vsam, and DB2.
Otto Schumacher Technical Support, CICS EDS, an HP Company Ahold Account 2000 Wade Hampton Blvd. LC1-302 Greenville, South Carolina, 29615 Tel: 864 987-1417 Fax: 864 987-4500 E-mail: [email protected] We deliver on our commitments so you can deliver on yours. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of George Rodriguez Sent: Thursday, June 25, 2009 1:20 PM To: [email protected] Subject: Re: VSAM Query Product 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:[email protected]] On Behalf Of Bill Washburn Sent: Thursday, June 25, 2009 1:02 PM To: [email protected] 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 [email protected] Mainframe cc Discussion List <[email protected] Fax to .edu> Subject Re: VSAM Query Product 06/25/2009 11:53 AM Please respond to IBM Mainframe Discussion List <[email protected] .edu> > -----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.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 [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 ---------------------------------------------------------------------- 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 ----------------------------------------- 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 [email protected] 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 [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
