Question ID : 221
Created on 2013-11-22 at 4:45 AM
Author : Veryant Support [support@veryant.com]
Online URL : http://support.veryant.com/support/phpkb/question.php?ID=221
To achieve this goal, you have to use indicator variables:
*Put a NULL value in a record using indicator variables move 6 to V-KEY move spaces to V-DATA move -1 to IND-VAR EXEC SQL INSERT INTO V_TABLE VALUES (:V-KEY, :V-DATA:IND-VAR) END-EXECWhen the value of the indicator variable is equal to -1, the value of the host variable is ignored and NULL will be used instead.
More information related to indicator variables is available in the isCOBOL documentation's Language Reference Manual in the "Embedded SQL: Indicator Variables" chapter.