1 / 32

IceQuery™ Brings new life to your existing Queries

IceQuery™ Brings new life to your existing Queries. System & Method A/S. System & Method was established in 1989 IBM Advanced Business Partner Sales directly to customers Sales via partners System implementation More than 1000 customers in 28 countries

callie
Download Presentation

IceQuery™ Brings new life to your existing Queries

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IceQuery™Brings new life to your existing Queries

  2. System & Method A/S • System & Method was established in 1989 • IBM Advanced Business Partner • Sales directly to customers • Sales via partners • System implementation • More than 1000 customers in 28 countries • Subsidiaries in Denmark and Brazil • Partners in more than 20 countries

  3. ” ” IceQuery is everything that Query/400 is missing What is IceQuery? • Visual and functional modernization of Query/400 • A simple and effective solution – contrary to an advanced Business Intelligence solution • Implemented in few hours • Running on every OS/400 version from V5R2

  4. OS/IBM i™ DB2 QUERY/400 DISPLAY How does IceQuery work? • Developed in IceCap™ to enclose the original Query/400 • Uses the existing definitions – no need for conversion!  • The users can recognize the ”good old” Query/400!

  5. How do I work with IceQuery? • Intuitive menu system • Common menus for all our products • Latest Queries • Run Queries • Work with Queries • The traditional Query/400 • Shown in “5250” • Printed as a Spooled File

  6. How do I work with IceQuery?

  7. How do I work with IceQuery? • ”One Click” Query • Grouping • Publication • Selection & Modification

  8. How do I work with IceQuery? • Internal & External Web Access • User administration • Fixed selection for external users Limited to recordswhere the customer numberis equal to 45

  9. How are the result presented? • Homepages • Readable and styled HTML-pages • Graphically • Dynamic charts • 19 different variations

  10. How are the result presented?

  11. How are the result presented? • Query Files • ”Snap Short” for later use • Connected Queries

  12. Can the result be exported? • ”One click” Integration • Excel spreadsheet (XLS) • Comma separated file (CSV) • XML file • PDF document • Text document (TXT)

  13. Formated reports through integration to InterForm

  14. Can the result be exported? • Innovative Plug-In • Newsletter Engine • Easy integration to your own homepage • Unique ticket per Query and Output type

  15. How can the result be distributed? • Mail a Query • Attached file • Link to ”Run Query” • Link to ”Snap Shot” • Integrated part of the mail body

  16. http://icequery.icebreak.dk/icequery/query.aspx?loginKey=qNbX5PBhyKf414TTsGGT0iilxKf45sSmTubEqE7XxPPiYdf14mHIpwkkhttp://icequery.icebreak.dk/icequery/query.aspx?loginKey=qNbX5PBhyKf414TTsGGT0iilxKf45sSmTubEqE7XxPPiYdf14mHIpwkk

  17. How can the result be distributed? • Mail templates • Per purpose • Per user or user group • Per language • Use of variables • Build in HTML editor

  18. Who remembers the monthly reports? • Build in scheduling • Daily, Weekly, Monthly • First/last day in the month • On a specific weekday • On a specific time • All types of output • Integration to IBM ”Job Scheduler”

  19. How can data access be restricted? • Restriction with flexibility • Per Library or File • Per User or User Group

  20. Questions? Visit our Web Site icequery.com

More Related