JR22509: SQL1822 ERROR MESSAGE WHEN SELECTING ON A DECIMAL COLUMN

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• SELECT INVOICE_NO FROM FEDAPV WHERE VOUCHER_LINE_NO = 0;
  
  VOUCHER_LINE_NO is a real datatype.
  
  Returns SQL1822N when the query is valid.
  
  SELECT INVOICE_NO FROM FEDAPV WHERE VOUCHER_LINE_NO = 1; Works
  fine.
  

Local fix

• Workaround use a decimal in front of the zero:
  
  SELECT INVOICE_NO FROM FEDAPV WHERE VOUCHER_LINE_NO = .0;
  

Problem summary

• Datatype checking is not correct.
  

Problem conclusion

• Datatype checking needs to be changed to allow a 0 to be
  accepted as a valid number.
  

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

• None     None
  

Fix information

• Fixed component name

  WS II DRDA WRAP

• Fixed component ID

  5724C7406

Applicable component levels

• R820 PSY

     UP