JR28832: GSE0214N AN INSERT STATEMENT FAILED

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• GSE0214N  An INSERT statement failed.  SQLERROR = "SQL0302N  The
  value
  of a host variable in the EXECUTE or OPEN statement is too large
  for its
  corresponding use.  SQLSTATE=22003".
  

Local fix

Problem summary

• Users affected: All Spatial Extender
  
  Problem Description:
  
  Using the Spatial Extender import_shape utility or stored
  procedure results in the error message:
  GSE0214N An INSERT statement failed. SQLERROR = "SQL0302N The
  value of a host variable in the EXECUTE or OPEN statement is too
  large
  for its corresponding use. SQLSTATE=22003"
  

Problem conclusion

• This is caused by attempting to import a a numeric field
  containing a floating point value to be inserted into a DB2
  DOUBLE column.
  
  Recommendation: upgrade to DB2 V9.1 FP6 or V9.5 FP2
  

Temporary fix

Comments

APAR Information

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

  JR28831

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

Fix information

• Fixed component name

  SPATIAL EXT SUN

• Fixed component ID

  5648D6102

Applicable component levels

• R910 PSY

     UP

• R950 PSY

     UP

• R970 PSY

     UP