Patch Name: PHSS_22090

Patch Description: s700_800 10.20 HP SQL/HP-UX A.G3.17 Development Patch

Creation Date: 00/08/03

Post Date:  00/08/09

Hardware Platforms - OS Releases:
	s700: 10.20
	s800: 10.20

Products:
	HP SQL/HP-UX A.G3.14

Filesets:
	ALLBASE-SQL.AB-DEV

Automatic Reboot?: No

Status: General Superseded

Critical: No

Path Name: /hp-ux_patches/s700_800/10.X/PHSS_22090

Symptoms:
	PHSS_22090:

	SR# 1653306985
	CR# JAGab38060
	SELECT with SUB_STRING get error ALLBASE/SQL internal
	error at JASNLMV(1

	SR# 8606134741
	CR# JAGad03876
	Function 'LOWER' doesn't work if Lang = German.

	SR# 8606124122
	CR# JAGac39505
	isql abort pascal escape code 2031719 dberr 237 when
	loading tables

Defect Description:
	PHSS_22090:

	SR# 1653306985
	CR# JAGab38060
	SELECT with SUB_STRING get error ALLBASE/SQL internal
	error at JASNLMV(1

	SR# 8606134741
	CR# JAGad03876
	Function 'LOWER' doesn't work if Lang = German.

	SR# 8606124122
	CR# JAGac39505
	isql abort pascal escape code 2031719 dberr 237 when
	loading tables

SR:
	1653306985 8606134741 8606124122

Patch Files:
	/opt/allbase/bin/psqlpas
	/opt/allbase/bin/psqlfor
	/opt/allbase/bin/psqlc
	/opt/allbase/bin/psqlcbl
	/opt/allbase/include/sqlcall.c
	/opt/allbase/include/sqlcall.cbl
	/opt/allbase/include/sqlcall.h
	/opt/allbase/include/sqlxc.h

what(1) Output:
	/opt/allbase/bin/psqlpas:
		HP36217-02A.G3.17 PASCAL Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/bin/psqlfor:
		HP36217-02A.G3.17 FORTRAN Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/bin/psqlc:
		HP36217-02A.G3.17 C Preprocessor/9000 ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/bin/psqlcbl:
		HP36217-02A.G3.17 COBOL Preprocessor/9000
		ALLBASE/SQL
		HP36217-02A.G3.17.00 SQL Parser/Linearizer/9000
		ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 SQLX/9000 ALLBASE/SQL
		HP36217-02A.G3.17 NET AF Library ALLBASE/SQL
		07/13/00
		HP36217-02A.G3.17 NET Library ALLBASE/SQL 07/13/00
		HP36217-02A.G3.17 NET VC Library ALLBASE/SQL
		07/13/00
	/opt/allbase/include/sqlcall.c:
		None
	/opt/allbase/include/sqlcall.cbl:
		None
	/opt/allbase/include/sqlcall.h:
		None
	/opt/allbase/include/sqlxc.h:
		None

cksum(1) Output:
	441228662 1702125 /opt/allbase/bin/psqlpas
	205594197 1476714 /opt/allbase/bin/psqlfor
	3439317087 1878311 /opt/allbase/bin/psqlc
	3036100279 1632442 /opt/allbase/bin/psqlcbl
	3725122807 1049 /opt/allbase/include/sqlcall.c
	606924485 41 /opt/allbase/include/sqlcall.cbl
	2007079305 20 /opt/allbase/include/sqlcall.h
	4068996826 40378 /opt/allbase/include/sqlxc.h

Patch Conflicts: None

Patch Dependencies:
	s700: 10.20: PHSS_22089
	s800: 10.20: PHSS_22089

Hardware Dependencies: None

Other Dependencies: None

Supersedes: None

Equivalent Patches:
	PHSS_22092:
	s700: 11.00
	s800: 11.00

Patch Package Size: 6640 KBytes

Installation Instructions:
	Please review all instructions and the Hewlett-Packard
	SupportLine User Guide or your Hewlett-Packard support terms
	and conditions for precautions, scope of license,
	restrictions, and, limitation of liability and warranties,
	before installing this patch.
	------------------------------------------------------------
	1. Back up your system before installing a patch.

	2. Login as root.

	3. Copy the patch to the /tmp directory.

	4. Move to the /tmp directory and unshar the patch:

		cd /tmp
		sh PHSS_22090

	5a. For a standalone system, run swinstall to install the
	    patch:

		swinstall -x autoreboot=true -x match_target=true \
			-s /tmp/PHSS_22090.depot

	By default swinstall will archive the original software in
	/var/adm/sw/patch/PHSS_22090.  If you do not wish to retain a
	copy of the original software, you can create an empty file
	named /var/adm/sw/patch/PATCH_NOSAVE.

	WARNING: If this file exists when a patch is installed, the
	         patch cannot be deinstalled.  Please be careful
		 when using this feature.

	It is recommended that you move the PHSS_22090.text file to
	/var/adm/sw/patch for future reference.

	To put this patch on a magnetic tape and install from the
	tape drive, use the command:

		dd if=/tmp/PHSS_22090.depot of=/dev/rmt/0m bs=2k

Special Installation Instructions:
	You must to use SQLINSTL before running ANY new
	version (later than G.0). For example, when you
	go from G3.14 to G3.17, then you have to run SQLINSTL
	for successful migration. The SQLINSTL script is
	provided in the G.1 version of ALLBASE/SQL to make it
	easy for a DBA to move to a delta release. Using
	SQLINSTL ensures that you will have access to the
	most recent version of the SYSTEM and CATALOG views,
	and it also uses VALIDATE FORCE statements to
	revalidate all stored sections.