Showcase 9

• Add a Column to Sequentially Rank Records

• Add or Subtract Days, Months, or Years From a Date [Video]

• Adding Summaries to Query Results

• Batch Processing in Showcase Generates Only HEX or GRAPHIC Fields

• Batch Queries Fail After Java PTF's or New Licensed Programs Installed

• Batch Query Issues Data Mapping Error

• Batch Query Resource Limit Exceeded and Stack Overflow Errors

• Batch Query to Temporary Storage Space Offset Error

• Calculate the Last Day of the Previous Month

• Calculate Time Durration from Date and Numeric Time Fields

• Can Showcase Query be Used with Non-iSeries Databases?

• CAST Function Fails with SQL0802 Error

• Change Config File for Java Heap Error

• Change the Location of the Paradox File-pdoxusrs.net

• Change the SQL Database Name for Excel Data Source

• Check for Locks if Showcase Server Fails to End

• Check if JAVA is Working on the iSeries

• Check if Mult-thread Job Queue Used For Showcase Install

• Check Which IASPs are Defined on the iSeries

• Clear Out Warehouse Builder Log Messages

• Configure ShowCase ODBC/JDBC Data Source with MS ODBC Administrator

• Connection Errors After Installing Server 9.1.0.2 Patch

• Conversion Error on Prompted Query

• Convert From Standard Date Format to Julian Date

• Convert Gregorian Date Prompt Value to Julian Format

• Create a Virtual Optical Drive for Showcase Server ISO

• Create Sequence Numbers in Query and Report Writer

• Creating an ODBC Data Source for Showcase Query [Video]

• Database Name Component of Object Qualifier Must be Name of Current Database

• Debug Steps for Showcase Warehouse Manager Server

• Display Query Summary Totals in MS Excel--Not the Details

• Enable JDK 8 for Showcase Server [Video]

• Error 0x0012 Opening Existing Report

• Error CPF9898: Server Installation Fails Due to an Unsupported CCSID (65535) [Video]

• Error Occurred in SQL Call Level Interface

• Error 'Ox2108 received while initializing BDE in Report Writer

• Error When Creating JDBC Connection Within MS ODBC Administrator

• Excel Add-in Macro Error

• Excel Add-in Not Attached After Install

• Excel Extendable Detail Area Features and Capabilities

• Excel Missing Showcase Add-in Menu

• Excel Spreadsheet as the Source of a Query Prompt

• File is Not a Recognizable Format in Excel

• Host Install Fails Before Displaying License Agreement

• How Does Showcase Apply JD Edwards E1 Inclusive Row Security

• How to Change Showcase Server Ports or Swap Ports Between two Showcase Servers [Video]

• In Warehouse Builder Adding a presql or postsql AS400 Command with quotes fails

• Install C&DS Adapters

• Install Showcase Client Patch

• Install Showcase Server Patch [Video]

• Internal Error in Showcase Application Licensing

• Invalid Date or Time Format Error Scheduling Query Job

• JD Edwards World/OneWorld/EnterpriseOne Integration with ShowCase v9.1

• Link the System Date in a Showcase Query Date Condition

• Make Query Run Faster Using the SQE Engine

• Manually Remove All Showcase Client Software

• MCH0601 Space offset error when selecting the Table drop down in Query

• Memory Allocation Failure for pRSData in Function

• Migrate Showcase Queries from Pre-version 7.0 to Version 9.x

• Mirror Showcase with MIMIX

• Modify Showcase Java Properties File

• Modify the Showcase.cfg file to Turn on JDBC Tracing for Showcase Logging [Video]

• Monitor Which iSeries Jobs are Invoked by Submitted Queries

• Multiple Interface ( IP Addresses ) on Same LPAR Receive Error Connecting to Server [Video]

• Opening Excel Workbook with Query Reference Produces Error

• Opening Existing Report generates 'BDE error 0x2b05-permission denied' Message

• Parser Error Creating Query

• Profile Required for Install

• Prompt From a PC File

• Query a Multi-Member File

• Query an Excel Worksheet using Showcase Query

• Query CAST Function Causes iSeries Error

• Query Client Generates Error - Error connecting to server 'nn.nn.nn.nn:ppppp' : no such object in table [Video]

• Query Error - Specified DSN Contains an Architecture Mismatch

• Query Numeric Prompt Returns Operands Not Compatible Message

• Query Output Table Contains Bad Characters

• Query Results in Excel Viewer Error 'Viewer selected could not be started'

• Query to Return Every Other Record

• Remove a Server Patch [Video]

• Report Writer and Problem Creating IDAPI Table

• Restrict Batch Query Jobs to Specific Time Limits

• Row Security Ignored for User or PUBLIC as Data Administrator

• Run QSQSRVR Prestart Jobs in the Showcase Subsystem

• SAVSRVRINF and RSTSRVRINF to Move User Profile Settings [Video]

• Schedule a Batch Query to Run Every Day or Month [Video]

• Schedule a Warehouse Builder Distribution Set/Job [Video]

• Schedule Batch Queries

• SCSERVER Job at 86 Percent of CPU

• SCXADD32.xll Could Not be Found

• Search for an Occurrence of a String Supplied with a Prompt Variable

• Security and Aliases of Warehouse Manager Client

• Select the Most Recenct (Invoice)

• Setup Non-DB2 Data Sources

• Setup Timeout Feature for Showcase Query & Report Writer [Video]

• Showcase 9 Copy and Paste Works Differently Than Previous Releases

• Showcase 9.x Connection Ports [Video]

• Showcase and JDE World A9.1 Support

• Showcase and QSQSRVR Jobs

• Showcase and Single Sign-On

• Showcase Datasource on Windows 7 64-bit: Tabs vs. Menu Bar

• Showcase Driver CLOB Support

• Showcase Independent Auxiliary Storage Pool Support

• Showcase Install Quick Start

• Showcase iSeries Driver Error in getObjectLibrary

• Showcase iSeries ODBC Driver Not Loaded Due to System Error

• Showcase JD Edwards Support

• Showcase Journals and Journal Receivers

• Showcase ODBC SQL Negative Scale Not Valid

• Showcase Products Backward Compatibility

• Showcase QSQSRVR Jobs Multiply Over Time

• Showcase Query Excel Add-in API's

• Showcase Query Excel Add-in Fails with Unrecognizable File Format Error

• Showcase Server Patch Fails with CPF21A0

• Showcase Support for Microsoft Office 2010

• Showcase Support Questions

• Showcase Windows Support

• Specify a Different Subsystem or Port Number for Showcase Server version 9.x and higher

• Specify the JDE Security Table and Libraries in JDE World Environment

• SQL Server Fix for Showcase Client 9.1.0.7

• Temporary Batch Tables Not Cleaned From the Showcase Server Library

• Unable to Create a Data Source on Windows 7, 64-bit

• Unable to Open Report Writer Report

• Understanding Date Functions and Date Wrappers

• Uninstall a Showcase Server on IBM i

• Uninstall and reinstall Showcase Client

• Uninstall the Borland Database Engine

• Unnamed File Cannot be found in Warehouse Manager Client

• Unnamed File Not Found Message Opening Warehouse Manager

• Use Showcase Security for JD Edwards EnterpriseOne ( JDE E1 ) Profiles

• Use the Auditing Function Within Warehouse Manager Client

• Use the CAST Function within Showcase Query [Video]

• Use the Excel Query Add-in to Link a Query to a Spreadsheet [Video]

• Using Date Wrappers in Showcase Query

• Using the CAST Function in Showcase Query

• Variables File Renamed in Client Version 7.10

• Warehouse Builder/Manager Connection Error-Processing of the SQL Statement Ended

• Warehouse Manager Audit Error

• Warehouse Manager Resource Settings Part II

• Windows Server 2003 Receives Unhandled Win32 Exception

• Windows Server 2008 R2 support for Showcase Client

• Write Batch Query Results to a PC File