|
Problem IT20155
|
Status: Closed |
CREATE MASK FAILING WITH BOOLEAN LITERAL VALUE |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
Create Mask is failing with Boolean Literal Values, eg for the
below query its failing.
db2 "CREATE MASK TEST.MASK1 ON TEST.TABLE0 FOR COLUMN C6 RETURN
CASE WHEN C6 = TRUE THEN C1 ELSE 'NO ENTRY' END ENABLE"
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL20474N The CREATE PERMISSION or CREATE MASK statement failed
on the
database object "TEST.MASK1" of object type "MASK" due to reason
code "21".
SQLSTATE=428HB |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to fp2 for resolution of this defect. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
The error is removed for Boolean Internals.
Problem was first fixed in DB2 11.1 db2v11m1fp2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.04.2017
23.06.2017
23.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
