| **Navigation:**  [[introduction.htm|Language Reference]] > 13 - Built-in Functions >====== GETNULLS(get the NULL state of a table) ====== | [[getini  return ini file entry .htm|{{btn_prev_n.gif|Previous page}}]][[introduction.htm|{{btn_home_n.gif|Return to chapter overview}}]][[getposition  get control position .htm|{{btn_next_n.gif|Next page}}]] |
|  ||

{{newc7.jpg|NewC7.jpg}}

**GETNULLS(**//table//**)**

{{blk2blue.jpg|blk2blue.jpg}}

| **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:**

[[null  return null file field .htm|NULL]]

[[setnull  set file field null .htm|SETNULL]]

[[setnulls set the null state of columns .htm|SETNULLS]]

[[setnonull  set file field non null .htm|SETNONULL]]