| Navigation: Language Reference > 13 - Built-in Functions >====== GETNULLS(get the NULL state of a table) ====== |    |
GETNULLS(table)
| GETNULLS | Gets the NULL state of a table. |
| table | The label of a FILE. |
The GETNULLS procedure returns a string containing the NULL state of the table. The size of the return string is file driver dependent. For the AS400 Accelerator, MSSQL Accelerator, ODBC Accelerator, Oracle Accelerator, Scalable/Pervasive Accelerator, and SQLAnywhere Accelerator the size of the return string is 4 times the number of columns in the table. This function is valid on all SQL tables.
| Return Data Type: | STRING |
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
Errors Posted:
| 80 | Function Not Supported |
See Also: