DB2 - Problembeschreibung
Problem IC66445 | Status: Geschlossen |
THE -X OPTION DOES NOT WORK WITH STORED PROCEDURES. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
The '-x' option does not work with stored procedures. For eg: db2sampl db2 connect to sample db2 -x "call reorgchk_tb_stats('T','YOGAWALI.ACT')" Problem here is - Last command returns the data with all columns headings irrespective of "-x" option. -x : This option tells the command line processor to return data without any headers, including column names. This flag will not affect all commands. It applies to SQL statements and some commands that are based on SQL statements such as LIST TABLES. Default setting = OFF . $ db2 -x "call reorgchk_tb_stats('T','SCHEMA1.ACT')" Result set 1 -------------- TABLE_SCHEMA TABLE_NAME CARD OVERFLOW NPAGES FPAGES ACTIVE_BLOCKS TSIZE F1 F2 F3 REORG ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ----------- ----------- ----------- ----- SCHEMA1 ACT 1 0 1 1 -1 35 0 -1 100 --- 1 record(s) selected. Return Status = 0 $ <<<< Column headings are there. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users prior to DB2 V95 FP6 * **************************************************************** * PROBLEM DESCRIPTION: * * THE -X OPTION DOES NOT WORK WITH STORED PROCEDURES. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V95 FP6. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem is first fixed in DB2 V95 FP6. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66446 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.02.2010 22.06.2010 22.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |