Informix

Or, simpler (maybe):

SELECT SUM(((length(blobcol) + blobpagesize - 41)/(blobpagesize - 40)) * blobpagesize)/1024 AS blobtotal_kb FROM mytable;

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.

Art

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

Art:

Does it exist for 11.70?

Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.

Art

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

.

I see this was edited, did you get it to work?

If not, make sure you are using the blade manager to register it. (if you do it again on v14 use the sysbldprepare function) 

.

.

Yes, it is the 'excompat' datablade for all versions. 11.7 I believe has 1.0. 
As a note for other folks,  version 1.2 is out, fixes a bug where it didn't correctly calculate sizes  > 2gb and is backwards compatible with older versions of Informix.

select dbms_lob_getlength(column) from <table>.

Art:

Does it exist for 11.70?

Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.

Art

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

Thomas:

I've got a problem unregistering excompat.1.0 on 11.70:

EXECUTE FUNCTION sysbldprepare('excompat.1.0','drop');
#                                                   ^
#(U0001) - SYSBldUnregister - Unregistration failed for DataBlade module "excompat.1.0" - unknown error - check online log and sysblderrorlog table for more information

A sysblderrorlog table contains a single row,

order          1416
bld_id         excompat.1.0
err_operation  SYSBldRegister
err_expected   unexpected
err_sql_stmt   alter function dbms_random_jrand48 (integer)| with (Modify External Name = "jrand48");
err_sql_state  XIX000:-674 : Routine (dbms_random_jrand48) can not be resolved.

Comparing the datablade with that of 12.10, I found that regardless of the same version (1.0) two files differ,

excompat.bld   74733   74801
objects.sql   99609   99608

The difference in text file objects.sql is as follows,

4559c4559
<       "alter function dbms_random_jrand48 (integer)
---
>       "alter function dbms_random_jrand48 (bigint)

How do I try to fix the problem?

Replace the files of 11.70 with those of 12.10 and restart the server?

Or something else?

Yes, it is the 'excompat' datablade for all versions. 11.7 I believe has 1.0. 
As a note for other folks,  version 1.2 is out, fixes a bug where it didn't correctly calculate sizes  > 2gb and is backwards compatible with older versions of Informix.

select dbms_lob_getlength(column) from <table>.

Art:

Does it exist for 11.70?

Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.

Art

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

Dennis:

Try this: find the DDL for the dbms_random_jrand48() function in the objects.sql file and try to CREATE it and ALTER it. Then see if you can deregister the datablade.

Art

Thomas:

I've got a problem unregistering excompat.1.0 on 11.70:

EXECUTE FUNCTION sysbldprepare('excompat.1.0','drop');
#                                                   ^
#(U0001) - SYSBldUnregister - Unregistration failed for DataBlade module "excompat.1.0" - unknown error - check online log and sysblderrorlog table for more information

A sysblderrorlog table contains a single row,

order          1416
bld_id         excompat.1.0
err_operation  SYSBldRegister
err_expected   unexpected
err_sql_stmt   alter function dbms_random_jrand48 (integer)| with (Modify External Name = "jrand48");
err_sql_state  XIX000:-674 : Routine (dbms_random_jrand48) can not be resolved.

Comparing the datablade with that of 12.10, I found that regardless of the same version (1.0) two files differ,

excompat.bld   74733   74801
objects.sql   99609   99608

The difference in text file objects.sql is as follows,

4559c4559
<       "alter function dbms_random_jrand48 (integer)
---
>       "alter function dbms_random_jrand48 (bigint)

How do I try to fix the problem?

Replace the files of 11.70 with those of 12.10 and restart the server?

Or something else?

Yes, it is the 'excompat' datablade for all versions. 11.7 I believe has 1.0. 
As a note for other folks,  version 1.2 is out, fixes a bug where it didn't correctly calculate sizes  > 2gb and is backwards compatible with older versions of Informix.

select dbms_lob_getlength(column) from <table>.

Art:

Does it exist for 11.70?

Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.

Art

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

Art:

Another trick helped: I UPDATEd sysbldobjects.drop_sql mistyped in 'objects.sql'.

Dennis:

Try this: find the DDL for the dbms_random_jrand48() function in the objects.sql file and try to CREATE it and ALTER it. Then see if you can deregister the datablade.

Art

Thomas:

I've got a problem unregistering excompat.1.0 on 11.70:

EXECUTE FUNCTION sysbldprepare('excompat.1.0','drop');
#                                                   ^
#(U0001) - SYSBldUnregister - Unregistration failed for DataBlade module "excompat.1.0" - unknown error - check online log and sysblderrorlog table for more information

A sysblderrorlog table contains a single row,

order          1416
bld_id         excompat.1.0
err_operation  SYSBldRegister
err_expected   unexpected
err_sql_stmt   alter function dbms_random_jrand48 (integer)| with (Modify External Name = "jrand48");
err_sql_state  XIX000:-674 : Routine (dbms_random_jrand48) can not be resolved.

Comparing the datablade with that of 12.10, I found that regardless of the same version (1.0) two files differ,

excompat.bld   74733   74801
objects.sql   99609   99608

The difference in text file objects.sql is as follows,

4559c4559
<       "alter function dbms_random_jrand48 (integer)
---
>       "alter function dbms_random_jrand48 (bigint)

How do I try to fix the problem?

Replace the files of 11.70 with those of 12.10 and restart the server?

Or something else?

Yes, it is the 'excompat' datablade for all versions. 11.7 I believe has 1.0. 
As a note for other folks,  version 1.2 is out, fixes a bug where it didn't correctly calculate sizes  > 2gb and is backwards compatible with older versions of Informix.

select dbms_lob_getlength(column) from <table>.

Art:

Does it exist for 11.70?

Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.

Art

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?

Oops, wrong package. You need the DBMS_LOB package installed which contains the function dbms_lob.get_length() function which you can wrap in length(BLOB) and length(CLOB) functions.

Art

Install the compatibility data blade (excompat). It contains a length-like function for BLOB and CLOB type columns that you can then remap as length(BLOB).

Art

What if LENGTH() gets error '674: Routine (length) can not be resolved.' in 11.70 for BLOB columns?