| Parameter | Value |
|---|---|
| Maximum BLOB object size | 2,097,088,000 8-bit bytes |
| Maximum CLOB object size |
|
| Maximum XML object size | 2,097,088,000 8-bit bytes |
| Maximum number of LOB rows per rowkey per AMP for NoPI LOB or XML tables | ~ 256M The exact number is 268,435,455 LOB or XML rows per rowkey per AMP. |
| Maximum size of the file name passed to the AS DEFERRED BY NAME option in a USING request modifier | VARCHAR(1024) |