Search below to find the answer to your Showcase questions. From helpful step-by-step how-tos to solutions to error messages, you'll find the resource you need.

Report Writer and Problem Creating IDAPI Table In Warehouse Builder Adding a presql or postsql AS400 Command with quotes fails Monitor Which iSeries Jobs are Invoked by Submitted Queries Unnamed File Cannot be found in Warehouse Manager Client Showcase Query Excel Add-in Fails with Unrecognizable File Format ErrorShowcase SCSERVER Job at 86 Percent of CPU Showcase Products Backward Compatibility Specify Different Subsystem or Port Number for Showcase 9.x Create Sequence Numbers in Query and Report Writer Query Numeric Prompt Returns Operands Not Compatible Message Error 0x0012 Opening Existing Report Batch Query Issues Data Mapping Error Warehouse Manager Audit Error Check if JAVA is Working on the iSeries Restrict Batch Query Jobs to Specific Time Limits Change the Location of the Paradox Can Showcase Query be Used with Non-iSeries Databases? Convert From Standard Date Format to Julian Date Showcase and Single Sign-On Check if Mult-thread Job Queue Used For Showcase Install Add a Column to Sequentially Rank Records Check Which IASPs are Defined on the iSeries Showcase and JDE World A9.1 Support Excel Add-in Macro Error Query Output Table Contains Bad Characters Showcase QSQSRVR Jobs Multiply Over Time Internal Error in Showcase Application Licensing Showcase iSeries Driver Error in getObjectLibrary Invalid Date or Time Format Error Scheduling Query Job Showcase Driver CLOB Support Windows Server 2003 Receives Unhandled Win32 Exception Error When Creating JDBC Connection Within MS ODBC Administrator Excel Spreadsheet as the Source of a Query Prompt Showcase ODBC SQL Negative Scale Not Valid Uninstall a Showcase Server Configure ShowCase ODBC/JDBC Data Source with MS ODBC Administrator Database Name Component of Object Qualifier Must be Name of Current Database Error 'Ox2108 received while initializing BDE in Report Writer Creating an ODBC Data Source for Showcase Query Variables File Renamed in Client Version 7.10 MCH0601 Space offset error when selecting the Table drop down in Query Mirror Showcase with MIMIX Excel Add-in Not Attached After Install Schedule a Batch Query to Run Every Day or Month Display Query Summary Totals in MS Excel--Not the Details Conversion Error on Prompted Query SCXADD32.xll Could Not be Found Uninstall and reinstall Showcase Client Query CAST Function Causes iSeries Error Opening Excel Workbook with Query Reference Produces Error Excel Missing Showcase Add-in Menu Opening Existing Report generates 'BDE error 0x2b05-permission denied' Message Batch Query Resource Limit Exceeded and Stack Overflow Errors Batch Query to Temporary Storage Space Offset Error Query an Excel Worksheet using Showcase Query Setup Timeout Feature for Showcase Query & Report Writer Unnamed File Not Found Message Opening Warehouse Manager Parser Error Creating Query Write Batch Query Results to a PC File Convert Gregorian Date Prompt Value to Julian Format Search for an Occurrence of a String Supplied with a Prompt Variable Query a Multi-Member File Profile Required for Install Add or Subtract Days, Months, or Years From a Date Query to Return Every Other Record Create a Virtual Optical Drive for Showcase Server ISO Windows Server 2008 R2 support for Showcase Client Showcase Windows Support Uninstall the Borland Database Engine Showcase Datasource on Windows 7 64-bit: Tabs vs. Menu Bar Security and Aliases of Warehouse Manager Client File is Not a Recognizable Format in Excel Clear Out Warehouse Builder Log Messages Modify Showcase Java Properties File Install Showcase Client Patch Install Showcase Server Patch Showcase Support Questions Change Config File for Java Heap Error SQL Server Fix for Showcase Client Install C&DS Adapters Showcase iSeries ODBC Driver Not Loaded Due to System Error Specify the JDE Security Table and Libraries in JDE World Environment Select the Most Recenct (Invoice) Change the SQL Database Name for Excel Data Source Showcase Install Quick Start Calculate the Last Day of the Previous Month Link the System Date in a Showcase Query Date Condition Query Results in Excel Viewer Error 'Viewer selected could not be started' Unable to Create a Data Source on Windows 7, 64-bit Use the Auditing Function Within Warehouse Manager Client Batch Processing in Showcase Generates Only HEX or GRAPHIC Fields CAST Function Fails with SQL0802 Error Error Occurred in SQL Call Level Interface Showcase 9 Copy and Paste Works Differently Than Previous Releases Migrate Showcase Queries from Pre-version 7.0 to Version 9.x Make Query Run Faster Using the SQE Engine Calculate Time Durration from Date and Numeric Time Fields Debug Steps for Showcase Warehouse Manager Server Setup Non-DB2 Data Sources JD Edwards World/OneWorld/EnterpriseOne Integration with ShowCase v9.1 Excel Extendable Detail Area Features and Capabilities Temporary Batch Tables Not Cleaned From the Showcase Server Library Prompt From a PC File Warehouse Manager Resource Settings Part II Using the CAST Function in Showcase Query Showcase and QSQSRVR Jobs Showcase Query Excel Add-in API's Understanding Date Functions and Date Wrappers Schedule Batch Queries Showcase JD Edwards Support Showcase Support for Microsoft Office 2010 Run QSQSRVR Prestart Jobs in the Showcase Subsystem Data Source Error Code 126 Check for Locks if Showcase Server Fails to End Using Date Wrappers in Showcase Query Showcase Journals and Journal Receivers