GETNULLS(get the NULL state of a table)

Top  Previous  Next

 

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:

NULL

SETNULL

SETNULLS

SETNONULL