User Tools

Site Tools


setnulls_set_the_null_state_of_columns_.htm
Navigation:  Language Reference > 13 - Built-in Functions >====== SETNULLS(set the null state of columns) ====== Previous pageReturn to chapter overviewNext page

NewC7.jpg

SETNULLS(table, null-value)

blk2blue.jpg

SETNULLS Set NULL state of columns in a table.
table The label of a FILE.
null-value Null “value” to assign to the table.

SETNULLS sets the NULL state of every column in the table based on the contents of the passed string. The passed string must be obtained from a prior call to GETNULLS. This function is valid on all SQL table types.

Errors Posted:

75 Invalid Column Type Descriptor ' Indicating that the passed string was too small.
80 Function Not Supported

Example:

StorageString STRING(255)

Rec           STRING(2048)

 CODE

 StorageString = GETNULLS(table)  !Get NULL state of table

 Rec = table.record               !Save record buffer

 ! Do Table Processing

 Table.Record = Rec               !Restore record buffer

SETNULLS(table, StorageString)   !Set NULL state of table columns

See Also:

GETNULLS

NULL

SETNONULL

setnulls_set_the_null_state_of_columns_.htm.txt · Last modified: 2021/04/15 15:57 (external edit)