SQLCODE = -622, ERROR: FOR MIXED DATA IS INVALID BECAUSE THE MIXED DATA INSTALL OPTION IS NO (4239888)

Error on STAT STAGE CNTRL table when executing StageDB2-OS390v572.sql file.   When executing the DB script for XXXX database(with new PeopleTools 8.54v) in DB2 for building the PS_STAT_STAGE_CNTRL table, we get an error as below. SQLCODE = -622, ERROR: FOR MIXED DATA IS INVALID BECAUSE THE MIXED DATA INSTALL OPTION IS NO

The column to which this message is referring is: STAGE_USERID CHARACTER(10) FOR MIXED DATA NOT NULL, ***************** In the existing table for XXXX for example it is defined as SBCS for the same field: can we use SBCS instead of Mixed data.

RESOLUTION:

We compared the 570 script to the 572 script and they are the same.  ie, they both used Mixed.

We assume the staging script was modified to use SBCS instead of Mixed.

If that worked in the past, it should work here.
However, if they are upgrading from 55x, the script looks like this:

CREATE TABLE [CREATORID].STAT_STAGE_CNTRL (
    STAGE_DT       timestamp       NOT NULL,
    SD_CD       char(3)       NOT NULL,
    CSR_ID           decimal(10,0)      NOT NULL,
    SWAT_ID      decimal(10,0)      NOT NULL,
    STAGE_USERID   char(10)       NOT NULL,
    STAGE_LOCKED   decimal(1,0)      NOT NULL
   ) IN [DATABASENAME].[TABLETBSPC1] ;
COMMIT ;

I suspect that will work for this table in this release as well.   It's a pretty simple table and shouldn't care about Unicode vs non-unicode