|
Problem IC66445
|
Status: Closed |
THE -X OPTION DOES NOT WORK WITH STORED PROCEDURES. |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem is first fixed in DB2 V95 FP6. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66446
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.02.2010
22.06.2010
22.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
