How to insert NULL into a field with data type CHAR in DBMaker via DCI in a COBOL program? (DBMR2557)
The following three configuration variables are used to insert NULL into a field with data type CHAR via DCI.
- DCI_NULL_ON_SPACE_CHAR
- DCI_NULL_ON_ILLEGAL_DATE
- DCI_NULL_ON_ILLEGAL_DATA
In addition, users can dynamically set the three variables with the following statements.
CALL "DCI_SETENV" USING "DCI_NULL_ON_ILLEGAL_DATA" "1"
CALL "DCI_SETENV" USING "DCI_NULL_ON_ILLEGAL_DATE" "1"
CALL "DCI_SETENV" USING "DCI_NULL_ON_SPACE_CHAR" "1"
CALL "DCI_SETENV" USING "DCI_NULL_ON_ILLEGAL_DATA" "0"
CALL "DCI_SETENV" USING "DCI_NULL_ON_ILLEGAL_DATE" "0"
CALL "DCI_SETENV" USING "DCI_NULL_ON_SPACE_CHAR" "0"
Version: DBMaker 5.2.x/5.3.x
Product: Normal/Bundle
Platform: Windows/Linux