User Tools

Site Tools


getnulls_get_the_null_state_of_a_table_.htm
Navigation:  Language Reference > 13 - Built-in Functions >====== GETNULLS(get the NULL state of a table) ====== Previous pageReturn to chapter overviewNext page

NewC7.jpg

GETNULLS(table)

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

SETNULL

SETNULLS

SETNONULL

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