Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Antonin Rozehnal — source: IBM Community (ConnectedCommunity.org) Informix forum
I have a database in which is a several dozen tables with such a schema:
create table t1
i int,
c char(20),some byte in xyzbls
);
The BLOBs are located in a special (different) spaces than the rest of the table.
I am able to find out how full the xyzbls is. but I would like to know which BLOBs from which table take the most space?
Is it possible?
------------------------------
roze
------------------------------
#Informix
↪ replying to Antonin Rozehnal
Paul Watson — source: IBM Community (ConnectedCommunity.org) Informix forum
Select length(blob) from table
Will give you the size of the actual blob
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.