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.

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