|
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 |
