User Tools

Site Tools

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


SETNULLS(table, null-value)


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


StorageString STRING(255)

Rec           STRING(2048)


 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:




setnulls_set_the_null_state_of_columns_.htm.txt · Last modified: 2021/04/15 15:57 by