HelpSystems SEQUEL Software PowerTech Skybot Software ShowCase Bytware CCSS Intermapper Safestone AutoMate
Help/Systems

Query

What Internet Explorer settings need to be enabled to allow our ShowCase 8 & 9 Web Enabled Add-ins to download properly?

What Internet Explorer settings need to be enabled to allow our ShowCase 8 & 9 Web Enabled Add-ins to download properly?

Abstract

What Internet Explorer settings need to be enabled to allow our ShowCase 8 & 9 Web Enabled Add-ins to download properly?

Solution

Using IE 6.0, IE 7.0 or IE 8.0 with the latest security updates to start with.  
If they DO NOT have the latest security updates they likely will have problems.

These are the internet explorer settings for Active-x Plugins :
1. Download signed ActiveX controls :- Enable
2. Download unsigned ActiveX controls :- Prompt
3. Initialize and script ActiveX controls not marked as safe :-  Prompt
4. Run ActiveX controls and plug-ins :- Enable
5. Script ActiveX controls marked safe for scripting :-  Enable
6. File download :- Enable
7. Active scripting :- Enable
8. Allow paste operations via script :- Enable
9. Scripting of Java applets :-   Enable

Apart from these, following settings were also made in Internet Explorer to run 
the XLR :- 
1. Site was added in trusted site list.
2. Security level was set to Low for trusted sites.

Software Version 9.0;8.0
Operating System(s) IBM i;Windows
Reference # 1487101

Error when using a concatenation with the DATE function.

Error when using a concatenation with the DATE function.

Abstract

Error when using a concatenation with the DATE function: 'SQL0170 Number of arguments for function DATE not valid DATE(DIGITS( DD) CONCAT DIGITS( MM )  CONCAT DIGITS( YYYY ) ,DDMMYYYY)'.

Solution

Use the DATE("string",DDMMYYYY,CHAR) function as illustrated in the select statement below.  As the result of the concatenation, the DATE value is a character string and the CHAR parameter needs to be used in the DATE wrapper
SELECT 
DATE( DIGITS( DD ) CONCAT DIGITS( MM ) CONCAT DIGITS( YYYY ); DDMMYYYY; CHAR ) 
AS COL1
FROM  .

DD is  defined as decimal (2,0) containing the day 
MM is  defined as decimal (2,0) containing the month
YYYY is defined as decimal (4,0) containing the year.

Remarks:
* The DIGITS  function returns a character string that is the absolute value of a number.  If the number contains a decimal point, this function removes the decimal point, creating a string of numbers.
* The CONCAT  function returns a string that is the concatenation of two other string values.
Software Version 9.0;8.0;7.1
Operating System(s) Windows
Reference # 1479155

How to debug issues with the CMOR install that is a part of the ShowCase Host Install.

How to debug issues with the CMOR install that is a part of the ShowCase Host Install.

Abstract

How to debug issues with the CMOR install that is a part of the ShowCase Host Install. Some errors that may be seen in joblog of install. - Failed to import/SCSERVER/ProdData/scripts/ShowCaseModel.XML. - File CFG in library SCSERVER not found or inline data file missing - ' for parameter CCSID must be numeric. - Failed to import/SCSERVER/METAFILE.XML

Solution

***********Caution NEVER run this procedure on a working ShowCase library. 
***********

These operations are intended to help trouble shoot a library that fails to 
start

**Before debugging CMOR, make sure that JDK 1.4, Toolbox for Java, Java Group 
PTF and latest cumulative PTF package have been loaded and applied.  
 In addition, verify that the date PTF's were applied is more recent than the 
date JDK 1.4 and Toolbox were loaded (PTF's need to be applied to JDK 1.4, so 
that the version matches the rest of the operating system, or the ShowCase 
installation will fail.) 
 To check the date the product was loaded issue WRKOBJ OBJ(QSYS/QJAVA) 
OBJTYPE(*LIB) and check the library description for the creation date/time. 
 The Change date/time should reflect when the Java Group PTF was applied. 
 The Java Group PTF can also be checked by using option 5 from the WRKPTFGRP 
list and displaying the details of the PTFs in the group. 

1. Debug CMOR:  See steps below - objects are included in attachments to Res 
(CMOR_Debug.zip).
Note: Replace SCSERVER with the name of your Showcase server library name that 
failed to install.
A. In the CMOR_Debug.zip, extract the files ( CMOR_Import.txt & cmor.jar) to 
your PC. 
B. Using a mapped drive to the AS400, navigate to SCSERVER/lib directory. 
C. Remove the extension & rename the existing cmor.jar in SCSERVER/lib 
directory to oldcmor. 
D. Then put the new cmor.jar file in SCSERVER/lib directory
E. Follow the instructions in the CMOR_Import.txt file and make sure to get F6 
printouts from each command run.
F. Locate the cmortrace.txt file which will be in the root of your SCSERVER 
library and send to Support Rep.

2. CMOR needs SYSIBM library and the SYSTYPINFO & SYSTBLTYPE files to exist 
otherwise something like the following will be found - 
A. **loadDataTypes - exception - SYSTYPINFO in SYSIBM type *FILE not found.  
See Step 6 below.


3. Run two quick queries to see if any data was inserted into the 
SPSS_OBJECTYPE table.

 Note: Replace SCSERVER7 with the name of your Showcase server library name
A. SELECT DBXFIL FROM QSYS/QADBXLFI              
WHERE DBXLIB='SCSERVER7'        
AND DBXLFI='SPSSCMOR_OBJECTTYPE'

B. That should return one value. Take that value and insert it into the next 
query.
 SELECT * FROM SCSERVER7/ 
 For example: SELECT * FROM SCSERVER/SPSSC00006 if the value returned is 
SPSSC00006.
 If any data is returned, we know that we were able to insert into the table.


4. Verify that these some of the SPSSC* tables are owned by QSECOFR: 
SPSSC00006; SPSSC00007; SPSSC00008
A. WRKOBJ OBJ(*ALL/SPSSC*)

B. Select Option 5=Display authority

C. Verify authority is:
 *PUBLIC                 *EXCLUDE   
 QSECOFR                 *ALL       
 QUSER                   *CHANGE    

5. Check the job logs for a SQL System Error.
A. If you find one, look at the QSQSRVR job description:

B. Ensure that the MAXJOBS parameter of the QSQSRVR prestart job is set to a 
number larger than 1.  Check this via the Prestart Job option of the QSYSWRK 
subsystem.  
C. Issue the command DSPSBSD QSYSWRK and then take option 10 for prestart job 
entries.  Find the QSQSRVR prestart job and then take option 5 and get a print 
screen of that.

D. Also check the Initial number of jobs, Threshold and Additional Number of 
jobs which are set by default to 5 - 2 - 2.

6. Verify that CFGTCP 10 and 12, and WRKRDBDIRE entries ALL match.
 Make sure Host search priority is set to *LOCAL.

7. Do a DSPLIB SYSIBM (DSPLIB LIB(SYSIBM) OUTPUT(*PRINT)) and compare to one of 
our systems with a comparable version of i5/OS. The number of objects should be 
the same, but the size of each object may vary slightly.  It's okay if the 
customer has additional objects in this library, as long as we're able to match 
every object in our library to theirs.

8. To recreate the SYSIBM library the customer can issue   CALL 
PGM(QSYS/QSQSYSIBM), but they may wish to consult IBM Support before running 
the program.    See IBM APAR SE17515 (PTF SI15756 for V5R3)

9. Check for Multi Threaded Job Queue.
A. Take the JOBD from the QSECOFR profile and run this command:

B. DSPJOBD JOBD(QGPL/QDFTJOBD) OUTPUT(*PRINT)

C. Then find the Job Queue from the JOBD and run command: 
DSPSBSD SBSD(QSYS/QBATCH) OUTPUT(*PRINT)

D. Should look like this or Max Active set to 10 or 20
   Seq          Job                                      Max 
  Nbr           Queue       Library              Active
  10            QBATCH      QGPL             *NOMAX   

10. Run the DB2Driver test using the attached files and the following 
instructions below.  This will test the connection to the DB2Driver. The codes 
(files) were compiled at JDK 1.4.

A. Using a mapped drive to your AS400, move the Java and Class 
(DB2DriverTest.java & DB2DriverTest.class) files from the zip file DB2Driver 
files.zip to a directory on the iSeries, it is best if they are placed right 
off the root

B. Start with a cle

Software Version 7
Operating System(s) IBMi
Reference # 1493329

Opening Excel sheet containing links to Query produces: "Missing or invalid configuration file Vista.cfg" in a Citrix environment.

Opening Excel sheet containing links to Query produces: "Missing or invalid configuration file Vista.cfg" in a Citrix environment.

Abstract

Opening Excel sheet containing links to Query produces: "Missing or invalid configuration file Vista.cfg" in a Citrix environment.

Solution

This issue will occur when users do not have read access to the folder 
containing the add-in; a work-around exists.

1. Start Excel and remove the existing ShowCase add-in from the add-ins list.
2. Copy (not move, just copy) the files "scxadd.xll" and "scv32enu.dll " to the 
Citrix user folder:
"%userprofile%\Application Data\Microsoft\Excel\XLSTART\ "
3. Register the file "SCXADD32.XLL" in the Windows registry for the Citrix user:
"HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options" and assign 
this information:"OPEN" ,'/R "%userprofile%\Application 
Data\Microsoft\Excel\XLSTART\SCXADD32.XLL "' ,"REG_SZ

Software Version Not Applicable
Operating System(s) Windows
Reference # 1481467

Can headers and headings be displayed vertically in Query or Report Writer?

Can headers and headings be displayed vertically in Query or Report Writer?

Abstract

Can headers and headings be displayed vertically in Query or Report Writer?

Solution

Query headings can displayed vertically by manually stacking the characters; 
however the subsequent display in Report Writer will be horizontal, and there 
is no way to make them vertical there.

Report Writer headings can also be displayed vertically, but only by manually 
stacking the characters within the header box.

Essentially, vertical headers and vertical headings are beyond the intended 
functionality of Query and Report Writer.

Software Version 7
Operating System(s) IBMi
Reference # 1479037

Does Showcase software have the ability to access non-DB2 data sources to distribute to the iSeries?

Does Showcase software have the ability to access non-DB2 data sources to distribute to the iSeries?

Abstract

Does Showcase software have the ability to access non-DB2 data sources to distribute to the iSeries?

Solution

ShowCase Warehouse Builder supports Oracle AIX/UNIX, SQL Server, Oracle NT, 
Excel, Access and Lotus Domino as source servers. 
Directions for setup are available on the Technical Support Website under 
ShowCase; Documentation; Showcase Suite ;Non-DB2 Data Source Guide

Software Version 7.1
Operating System(s) IBMi;Windows
Reference # 1475615

After uninstall and reinstall ShowCase client connections result in: "The setup routines for the ShowCase iSeries Driver ODBC driver could not be loaded due...".

After uninstall and reinstall ShowCase client connections result in: "The setup routines for the ShowCase iSeries Driver ODBC driver could not be loaded due...".

Abstract

After uninstall and reinstall ShowCase client connections result in: "The setup routines for the ShowCase iSeries Driver ODBC driver could not be loaded due to system error code 126".

Solution

Delete any existing 7.1 ShowCase data source and recreate new data sources with the 
ShowCase version you are using.

1. Go into the Windows Start menu, select "Settings", "Control Panel" and 
"Administrative Tools".
2. Open ODBC Administrator "Data Sources (ODBC)".
3. Any data source based on a driver called "ShowCase iSeries Driver" can be 
removed by selecting it and clicking the "Remove" button. 
(Note: There may be errors if ShowCase 7.10 has already been uninstalled. If 
there are errors deleting these datasources see the
details on removing them by directly updating the registry.  )
4. To add a new ShowCase data source, click the "Add" button, select "ShowCase 
ODBC Driver" and click "Finish". For more information on setting up ShowCase 
data sources, please see resolution 279

Software Version 7.1
Operating System(s) Windows
Reference # 1480284

How can you query a table to return records that are potential duplicates?

How can you query a table to return records that are potential duplicates?

Abstract

How can you query a table to return records that are potential duplicates?

Solution

Need to create a subselect using aliases to compare the records in the table.

Below is an example of how to set up a Select Statement to search for 
duplicates.  
The query below will return records that have the same value in the POSTALCODE 
column.  
You likely will have more than just one column that you are using to determine 
if records are duplicates.  
You can include multiple conditions by using AND in between the conditions. 

EXAMPLE:

SELECT 
 CUST_ID,
 CUSTNAME,
 POSTALCODE 
FROM 
 SCSAMPLE65.CUSTOMERS a 
WHERE 
 1 <( 
  SELECT 
   count( * ) 
  FROM 
   SCSAMPLE65.CUSTOMERS b 
  WHERE 
   a.POSTALCODE = b.POSTALCODE 
   ) 
ORDER BY

Software Version Not Applicable
Operating System(s) IBMi
Reference # 1479945

How to prompt for a date range ?

How to prompt for a date range ?

Abstract

How to prompt for a date range ?

Solution

Set up a prompt condition to use the BETWEEN function

1.  Click Query > Conditions
2.  Select column to be conditioned.  Then select BETWEEN for Condition
3.  Click Prompt and OK (At run time, the query will prompt for a min and max 
date for selection of records.)

Note that blank or zero date fields could cause a problem.  To work around 
this, set up a prompt on a condition that is generated via a CASE statement.  
This will allow you to replace zero dates with valid minimum-type dates, or to 
put the condition on the date field without a date wrapper.

For more information regarding conditions, please refer to the online help in 
STRATEGY (search words:  PROMPT, CONDITION, BETWEEN)

Software Version Not Applicable
Operating System(s) Windows
Reference # 1475774

Can a ShowCase Client access both JDE ERP 8.11 and JDE World data through the same server library.

Can a ShowCase Client access both JDE ERP 8.11 and JDE World data through the same server library.

Abstract

Can a ShowCase Client access both JDE ERP 8.11 and JDE World data through the same server library. The ShowCase server library and the SETJDEOWA has already been run and setup to ERP8.11, so the JDEOW.cfg file already exists.

Solution

ShowCase does not support coexistence and the code was changed to not recognize 
JDE World users if the library has been configured for OneWorld.

Will need to do the following for ShowCase to work properly with more that one 
version of JDE.

1. Install and configure a Showcase server for each version of JDE.

2. Setup and configure a new profile for each version of JDE.

Software Version 8
Operating System(s) IBMi;Windows
Reference # 1481492
Syndicate content