PI52609: SQLCODE -208 ERROR WHEN A SORT IS DONE ON A COLUMN WITH LABEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Release=11.3.0, DB2Rel=1015(NFM)
  Encountered the SQL Error Described
  Below
  
        DSNT408I SQLCODE = -208, ERROR:  THE ORDER BY CLAUSE IS
  INVALID BECAUSE
                            COLUMN Customer ID IS NOT PART OF THE
  RESULT TABLE
        DSNT418I SQLSTATE   = 42707 SQLSTATE RETURN CODE
        DSNT415I SQLERRP    = DSNXORSO SQL PROCEDURE DETECTING
  ERROR
        DSNT416I SQLERRD    = -90  0  0  -1  0  0 SQL DIAGNOSTIC
  INFORMATION
        DSNT416I SQLERRD    = X'FFFFFFA6'  X'00000000'
  X'00000000'
                 X'FFFFFFFF'  X'00000000'  X'00000000' SQL
  DIAGNOSTIC
                 INFORMATION
  
                 Cannot Continue.  Edit Session will End
                 Enter SQL Command to View the SQL Statement in
  Error
  

Local fix

• Do not sort on a column with a label defined.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Optim for z/OS users sorting when using browse or edit on a  *
  * DB2 table with a label defined.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Release=11.3.0, DB2Rel=1015(NFM)                             *
  *                          Encountered the SQL Error Described *
  * Below                                                        *
  *                                                              *
  *       DSNT408I SQLCODE = -208, ERROR:  THE ORDER BY CLAUSE   *
  * IS INVALID BECAUSE                                           *
  *                           COLUMN Customer ID IS NOT PART OF  *
  * THE RESULT TABLE                                             *
  *       DSNT418I SQLSTATE   = 42707 SQLSTATE RETURN CODE       *
  *       DSNT415I SQLERRP    = DSNXORSO SQL PROCEDURE DETECTING *
  * ERROR                                                        *
  *       DSNT416I SQLERRD    = -90  0  0  -1  0  0 SQL          *
  * DIAGNOSTIC INFORMATION                                       *
  *       DSNT416I SQLERRD    = X'FFFFFFA6'  X'00000000'         *
  * X'00000000'                                                  *
  *                X'FFFFFFFF'  X'00000000'  X'00000000' SQL     *
  * DIAGNOSTIC                                                   *
  *                INFORMATION                                   *
  *                                                              *
  *                Cannot Continue.  Edit Session will End       *
  *                Enter SQL Command to View the SQL Statement   *
  * in Error                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the provided fix.                                      *
  ****************************************************************
  Legacy table array support used the internal Label field for the
  extended array column names.  When sorting it is using the label
  value rather than the column name and when this is a DB2 table
  it causes the use of the label in the SQL SELECT statement
  resulting in the error.
  

Problem conclusion

• The use of label was made conditional on the type of table
  referenced in the sort request.
  

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:

  UI34471

Modules/Macros

• FOPMDXTR FOPMAIN  FOPMEMAI FOPMECMN FOPMDPRC FOPMADDE
  

Fix information

• Fixed component name

  OPTIM MOVE FOR

• Fixed component ID

  5655V0700

Applicable component levels

• RB30 PSY UI34471

     UP16/01/20 P F601

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.