320 likes | 410 Views
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
E N D
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
” ” 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
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!
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
How do I work with IceQuery? • ”One Click” Query • Grouping • Publication • Selection & Modification
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
How are the result presented? • Homepages • Readable and styled HTML-pages • Graphically • Dynamic charts • 19 different variations
How are the result presented? • Query Files • ”Snap Short” for later use • Connected Queries
Can the result be exported? • ”One click” Integration • Excel spreadsheet (XLS) • Comma separated file (CSV) • XML file • PDF document • Text document (TXT)
Formated reports through integration to InterForm
Can the result be exported? • Innovative Plug-In • Newsletter Engine • Easy integration to your own homepage • Unique ticket per Query and Output type
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
http://icequery.icebreak.dk/icequery/query.aspx?loginKey=qNbX5PBhyKf414TTsGGT0iilxKf45sSmTubEqE7XxPPiYdf14mHIpwkkhttp://icequery.icebreak.dk/icequery/query.aspx?loginKey=qNbX5PBhyKf414TTsGGT0iilxKf45sSmTubEqE7XxPPiYdf14mHIpwkk
How can the result be distributed? • Mail templates • Per purpose • Per user or user group • Per language • Use of variables • Build in HTML editor
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”
How can data access be restricted? • Restriction with flexibility • Per Library or File • Per User or User Group
Questions? Visit our Web Site icequery.com