Patch Name: PHSS_23888 Patch Description: s700_800 10.20 HP SQL/HP-UX A.G3.23 Development Patch Creation Date: 01/04/10 Post Date: 01/04/20 Hardware Platforms - OS Releases: s700: 10.20 s800: 10.20 Products: HP SQL/HP-UX A.G3.17 A.G3.14 Filesets: ALLBASE-SQL.AB-DEV,A.G3.14,A.G3.17 Automatic Reboot?: No Status: General Release Critical: No Path Name: /hp-ux_patches/s700_800/10.X/PHSS_23888 Symptoms: PHSS_23888: SR# 8606177425 SQLMOn does not work since G3.15 SR# 8606184134 DBERR 10071 when using Allbase/Net SR# 8606167904 NLS-Problem: Allbase connect changes the display of printf of numbers SR# 8606160803 Enhance Allbase/SQL to allow implicit AS clause as well as explicit PHSS_22090: SR# 1653306985 SELECT with SUB_STRING get error ALLBASE/SQL internal error at JASNLMV(1 SR# 8606134741 Function 'LOWER' doesn't work if Lang = German. SR# 8606124122 isql abort pascal escape code 2031719 dberr 237 when loading tables Defect Description: PHSS_23888: SR# 8606177425 SQLMOn does not work since G3.15 SR# 8606184134 DBERR 10071 when using Allbase/Net SR# 8606167904 NLS-Problem: Allbase connect changes the display of printf of numbers SR# 8606160803 Enhance Allbase/SQL to allow implicit AS clause as well as explicit PHSS_22090: SR# 1653306985 SELECT with SUB_STRING get error ALLBASE/SQL internal error at JASNLMV(1 SR# 8606134741 Function 'LOWER' doesn't work if Lang = German. SR# 8606124122 isql abort pascal escape code 2031719 dberr 237 when loading tables SR: 1653306985 8606134741 8606124122 8606177425 8606184134 8606167904 8606160803 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.23 PASCAL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.23.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/01 HP36217-02A.G3.23 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.23 NET AF Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET VC Library ALLBASE/SQL 02/26/01 /opt/allbase/bin/psqlfor: HP36217-02A.G3.23 FORTRAN Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.23.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/01 HP36217-02A.G3.23 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.23 NET AF Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET VC Library ALLBASE/SQL 02/26/01 /opt/allbase/bin/psqlc: HP36217-02A.G3.23 C Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.23.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/01 HP36217-02A.G3.23 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.23 NET AF Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET VC Library ALLBASE/SQL 02/26/01 /opt/allbase/bin/psqlcbl: HP36217-02A.G3.23 COBOL Preprocessor/9000 ALLBASE/SQL HP36217-02A.G3.23.00 SQL Parser/Linearizer/9000 ALLBASE/SQL 03/30/01 HP36217-02A.G3.23 SQLX/9000 ALLBASE/SQL HP36217-02A.G3.23 NET AF Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET Library ALLBASE/SQL 02/26/01 HP36217-02A.G3.23 NET VC Library ALLBASE/SQL 02/26/01 /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: 2079416678 1710323 /opt/allbase/bin/psqlpas 4268933823 1489007 /opt/allbase/bin/psqlfor 3892731684 1890604 /opt/allbase/bin/psqlc 1689483739 1644735 /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_23887 s800: 10.20: PHSS_23887 Hardware Dependencies: None Other Dependencies: None Supersedes: PHSS_22090 Equivalent Patches: PHSS_23890: s700: 11.00 s800: 11.00 Patch Package Size: 6680 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_23888 5a. For a standalone system, run swinstall to install the patch: swinstall -x autoreboot=true -x match_target=true \ -s /tmp/PHSS_23888.depot By default swinstall will archive the original software in /var/adm/sw/patch/PHSS_23888. 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_23888.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_23888.depot of=/dev/rmt/0m bs=2k Special Installation Instructions: You must use SQLINSTL before running ANY new version (later than G.0). For example, when you go from G3.17 to G3.23, 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.