setnulls_set_the_null_state_of_columns_.htm
| Navigation: Language Reference > 13 - Built-in Functions >====== SETNULLS(set the null state of columns) ====== |    |
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 |
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:
setnulls_set_the_null_state_of_columns_.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1