PI26147: ISPF - TWO LINES FOR 'FROM' STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• For SQL Statement, the FROM will take two lines if FROM line is
  more then 130 symbols long (because of long creator and/or table
  name). To resolve this, ETI code will remove the second line of
  FROM, than make LOAD WHERE at the end of DSQL panel list, and
  replace this last line (WHERE) with second line of FROM (so user
  has not seen WHERE line).
  *
  Also to be included is Tools Customizer ( TCz )
  template ETIADBI maintenance.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: For SQL Statement, the FROM will take   *
  *                      two lines if FROM line is more then     *
  *                      130 symbols long (because of long       *
  *                      creator and/or table name). To resolve  *
  *                      this, ETI code will remove the second   *
  *                      line of FROM, than make LOAD WHERE at   *
  *                      the end of DSQL panel list, and replace *
  *                      this last line (WHERE) with second      *
  *                      line of FROM (so user has not seen      *
  *                      WHERE line). Also to be included is     *
  *                      Tools Customizer ( TCz ) template       *
  *                      ETIADBI maintenance.                    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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

•    ETIADBI
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R140 PSY UI22452

     UP14/10/31 P F410

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.