II04732: SQLCODE -835 VIEW MUST BE DROPPED AND RECREATED

APAR status

• Closed as canceled.

Error description

• WHEN SQL/DS 3.1.0 FIRST ENCOUNTERS A VIEW MIGRATED FROM ANOTHER
  VERSION, THE VIEW IS 'PREPROCESSED'. A VIEW CREATED AS 'SELECT
  *' WILL INCLUDE ONLY THOSE COLUMNS OF THE UNDERLYING TABLE THAT
  WERE PRESENT WHEN THE VIEW WAS CREATED. ANY COLUMNS ADDED TO
  THE TABLE AFTER THE VIEW CREATION ARE NOT PART OF THAT VIEW.
  SQLCODE -835, SQLERRD1 -110 IS ISSUED TO WARN THAT A REPREP
  OF THE 'SELECT *' WOULD INCLUDE THESE NEWLY ADDED COLUMNS.
  THE USERS RESPONSE IS TO DROP AND RECREATE THE VIEW AS 'SELECT
  *' OR WITH A 'SELECT LIST' TO INCLUDE ONLY THE DESIRED COLUMNS.
  A COMPARE OF 'NCOLS' FROM SYSTEM.SYSCATALOG ON THE TABLE AND
  ANY VIEW CREATED AS 'SELECT *' CAN BE USED TO FIND VIEWS THAT
  WILL BE SUBJECT TO THE FAILURE. IE. NCOLS FOR THE VIEW WILL BE
  LESS THAN NCOLS FOR THE TABLE.
  FOR THE REASONS EXPLAINED ABOVE, QMF USERS MAY VALIDLY
  RECEIVE SQLCODE -835 WHEN MIGRATING TO A NEW RELEASE OF
  QMF, UNDER SQL R310.  THIS IS RECEIVED FOR TABLE Q.PROFILE.
  PLEASE NOTE QMF APAR PL74598 ALSO.
  ADDITIONAL KEYWORDS:
  Q.PROFILES Q.VPROFILE Q.VPROFILES 568810301 566872101 R450
  DSQ10498 R310 MIGRATION SQLCODE835 SQLERRD1 -110 110
  

Local fix

• DROP AND RECREATE THE VIEW.
  

Problem summary

Problem conclusion

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:

Fix information

Applicable component levels