PK46993: GOC PRODUCES INCORRECT DDL FOR TABLE CHECK CONSTRAINT APPLY GETS DSNT408I SQLCODEN104 SQLCODE 104 ILLEGAL SYMBOL ION SQLCODE104N

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Using GOC compare to change a Table Check Constraint the DDL for
  the Check Constraint is incorrect. When the Apply is run it gets
  the following error:
  ADB5044E *** INPUT STATEMENT:
     ALTER TABLE NMLCM01.TBTPB
       ADD CONSTRAINT C_OWNER_RELATION
           CHECK ((OWNER_RELATION BETWEEN '00' AND '10') OR (
  OWNER_RELAT
  ION BETWEEN '14' AND '18') OR ( OWNER_RELATION BETWEEN '20' AND
   '33') OR
  ( OWNER_RELATION BETWEEN '69' AND '99') OR ( OWNER_RELATION =
  '41') ) ;
  sqlerror on ALTER      command, PREPARE    function
  DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "ION". SOME
      SYMBOLS THAT MIGHT BE LEGAL ARE:
  
  < > = <> <= !< !> != .< .> .= >= IN IS NOT LIKE BETWEEN
  
   DSNT418I SQLSTATE   = 42601 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNHPARS SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = 502  0  0  -1  122  0 SQL DIAGNOSTIC
                         INFORMATION
   DSNT416I SQLERRD = X'000001F6' X'00000000' X'00000000'
                      X'FFFFFFFF' X'0000007A'  X'00000000'
                     SQL DIAGNOSTIC INFORMATION
  .
  

Local fix

• Please apply ptf when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Object Compare v7.2                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Object Compare 710 for  Check           *
  *                      Constraint creates bad syntax and when  *
  *                      alter (created by GOC) is run it        *
  *                      causes:                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
   Check constraints gets -104 because of  bad syntax.
  

Problem conclusion

• The problem is fixed in DB2 Object Compare V7.2
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    GOC2CMF
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK29840

     UP07/10/18 P F710

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.