1963550 - SQL530 Attempt to insert NULL value into column in work table column does not allow NULLS - SAP ASE for Business Suite

• SELECT on a view fails with ASE Error 530
• On systems running SAP applications, you find the following ST22 short dump to occur:

C ERROR: -1 in function StartSelect (execute) [line 20225]
C (530) [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Attempt to insert NULL value in
C to column 109 in work table (table id 4290838519); column does not allow NULLS.
C UPDATE fails.
C

B ***LOG BY4=> sql error 530 performing SEL on table CAUFV [dbtran 7634]
B ***LOG BY0=> [ASE Error SQL530]Attempt to insert NULL value into column 109 in work table (table id 4290838519); column does not

• SAP Adaptive Server Enterprise (ASE) 15.7 and higher for Business Suite
• SAP Solution Manager (Solman) 7.1
• SAP Adaptive Server Enterprise (ASE) 15.7 and higher

error 530, Error: 530, update index statistics, work table, VIEW, SQL530, CAUFV , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem