Can Showcase Query be used to query Non - iSeries databases?
Showcase (Query and Report Writer) is an ODBC-compliant application. While Query and Report Writer may allow you to query any database provided you have an ODBC connection to that database, the functionality may not be equivalent to that provided by the Showcase iSeries ODBC driver. Showcase will provide limited support for non-Showcase ODBC drivers such as SQL, ORACLE, Paradox, Excel, Dbase, Text, FoxPro, and Access.
With the above information ShowCase should be able to make a determination whether the problem is with Query and/or Report Writer, or the ODBC driver; or, if it is environment-related. If the problem is in Query or Report Writer, ShowCase will attempt to diagnose and resolve the problem. Because the problem is occurring in a untested environment, ShowCase may require assistance from the customer in duplicating problem or providing further information.
When the problem is resolved, ShowCase will need the customer's assistance in testing the resolution. In cases where the customer is not able to provide the additional assistance required, ShowCase may be unable to resolve the problem.
Ref#: 1476742
Still have questions? We can help. Submit a case to Technical Support.