MSCEWI5002

FUNCTIONALITY MIGHT BE DIFFERENT DEPENDING ON THE DB2 DATABASE.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

This message is shown whenever a SQL element behaves differently depending on the DB2 database version (DB2 for i, DB2 for z/OS, or DB2 for Linux, Unix, and Windows). SnowConvert treats all DB2 versions as one and therefore, the translation for the element might have functionality differences when compared to the original platform.

EWI Cases

Listed below are all the SQL elements so far identified, that behave differently depending on the DB2 database version.

CURRENT MEMBER

DB2 for z/OS: CURRENT MEMBER specifies the member name of a current Db2 data sharing member on which a statement is executing. The value of CURRENT MEMBER is a character string.

Db2 for LUW: The CURRENT MEMBER special register specifies an INTEGER value that identifies the coordinator member for the statement.

Code example

Input code:

CREATE TABLE T1
(
  COL1 INT,
  COL2 CHAR(8) WITH DEFAULT CURRENT MEMBER
);

Output code:

CREATE TABLE T1
(
   COL1 INT,
   COL2 CHAR(8) DEFAULT /*** MSC-WARNING - MSCEWI5002 - FUNCTIONALITY FOR CURRENT_ROLE MIGHT BE DIFFERENT DEPENDING ON THE DB2 DATABASE. ***/ CURRENT_ROLE()
);

Recommendations

• Review your code and keep in mind that the result transformation can behave differently according to the Db2 version that is being used.

• If you need more support, you can email us at [email protected]