isql Enhancement

isql displays the LOB locator value in its hexadecimal character form. Prefetched data stored in CS_LOCATOR does not appear.

Example

Converts LOB data to locators, and displays the locator value:

1> set send_locator on
2> go

1> select * from testable
2> go

charcol         textcol
--------------- --------------------------------------------------
Hello           0x48656c6c6f20576f726c642e2048657265204920616d2e2e