home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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