IBM
DB2 OLAP Server for AS/400 1.1
FixPak
14
Instructions
for installing the patch for
ShowCaseODBC
Service
Level 3.01.140
December
2001
These instructions use terminology
consistent with ShowCase STRATEGY. Please read and print these instructions
before installing the patch!
These patches are language
specific. Please download the patch for your language only:
English (898 KB)
French (704 KB)
German 3.01.130 (705 KB)
Spanish 3.01.130 (702 KB
Patch
Installation Instructions
.
-
Download
the patch executable for your language
-
Copy
the patch executable to the directory containing SCODBC32.DLL. This is
normally your Windows/System (or Winnt/System32) folder. (NOTE: Do not
copy this file to your Backup or Bin folder)
-
Rename
or delete the existing Backup folder that contains previous ShowCase patch
applications
-
Double-click
on patch executable file.
A Welcome
dialog box appears, and the software searches for the SCODBC32.DLL to update.
Note: The patch can only search the drive to which it is copied.
The
patch program runs and automatically modifies, adds, renames, or deletes
files as necessary to complete the patch.
The
original file is saved in the BACKUP directory, which is automatically
created on the drive from which the patch is run.
Undoing
the Patch
If
you want or need to get back to the original files (before the patch was
applied), you will find them in the BACKUP directory, which is located
on the drive that the patch is run from. The BACKUP directory contains
a file called unpatch.bak. This file is a script file containing the commands
necessary to automatically restore the original files. To restore the original
files (from any operating system environment):
-
Locate
the unpatch.bak.
-
Rename
the unpatch.bak to unpatch.bat.
-
At an
MS-DOS prompt, type the path to unpatch.bat and press Enter.
OR
On
the desktop, click Start > Run, and browse for the patch to unpatch.bat.
Click OK.
Your
application is automatically restored to its pre-patch configuration.
If
you apply multiple PTFs over time without deleting the Backup directory,
the BACKUP directory will contain multiple copies of unpatch files and
the related original files from each backup. You may wish to periodically
clean the BACKUP directory to recover disk space. To keep the most recent
backup information, keep the latest unpatch.bak (or unpatch.bat if you
already renamed it) file and the files listed in its text.
Summary of problems fixed
-
No new
failures addressed in this patch.
In addition,
this patch incorporates the 3.01.120 patch to resolve:
-
Timestampdiff
calculation is in error when the "to" hour is less than the "from" hour.
(F6944)
In addition,
this patch incorporates the 3.01.062 patch to resolve:
-
Resolved
a problem where ODBC clients would hang on an initial connection intermittently.(F6054)
In addition,
this patch incorporates the 3.01.040 patch to resolve:
-
The ShowCase
ODBC driver will now protect your original WHERE clause search condition
with parenthesis before adding any row conditions specified in your ShowCase
row security entries for the tables referenced by the query. (F4717)
In addition,
this patch incorporates the ODBC 3.01.020 patch to resolve the following:
-
ShowCase
ODBC was not returning the new password entered in our TCP/IP support for
expired passwords, causing Report Writer to attempt to use the old password
in subsequent connections. This fix now returns the required information.
(F4105)
-
Changes
in the ShowCase ODBC driver in 3.01 respin did not allow DataViews defined
in Query Designer to be created on the AS/400. This fix resolves the problem.
(F4148)
Back
to Patch Description