Oninit cdi / Archive
Talk to an expert →

Smart blobs

Posted in 2006

Topics: General Discussion

KENNETH PENZA — — source: IIUG Forums & Mailing Lists

People, Is there a way to get the length of a CLOB or BLOB stored in a smart blob space without retriveing it to a file ? For example query on a system table or use something similar to the length function. Regards Kenneth

↪ replying to KENNETH PENZA
Guillermo Gómez Valcárcel — — source: IIUG Forums & Mailing Lists

I use casting like length(graf.object_zip::lvarchar::clob) or register sblobinfo 1.5 datablade -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de KENNETH PENZA Enviado el: miércoles, 31 de mayo de 2006 12:31 Para: ids@iiug.org Asunto: Smart blobs [6839] People, Is there a way to get the length of a CLOB or BLOB stored in a smart blob space without retriveing it to a file ? For example query on a system table or use something similar to the length function. Regards Kenneth **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. __________ Información de NOD32, revisión 1.1569 (20060531) __________ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com

↪ replying to Guillermo Gómez Valcárcel
Penza Kenneth at MITTS — — source: IIUG Forums & Mailing Lists

Guillermo, From where can I get the sblobinfo data blade ? Regards Kenneth Penza Technical Services Officer Systems and Database Services Service Management Department Malta Information Technology & Training Services Ltd Please read our Legal Notice: http://emailpolicy.mitts.gov.mt P Please consider your environmental responsibility before printing this e-mail. END OF TEXT -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guillermo G.... Sent: 31 May 2006 15:31 To: ids@iiug.org Subject: RE: Smart blobs [6840] I use casting like length(graf.object_zip::lvarchar::clob) or register sblobinfo 1.5 datablade -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de KENNETH PENZA Enviado el: miércoles, 31 de mayo de 2006 12:31 Para: ids@iiug.org Asunto: Smart blobs [6839] People, Is there a way to get the length of a CLOB or BLOB stored in a smart blob space without retriveing it to a file ? For example query on a system table or use something similar to the length function. Regards Kenneth **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. __________ Información de NOD32, revisión 1.1569 (20060531) __________ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Penza Kenneth at MITTS
Guillermo Gómez Valcárcel — — source: IIUG Forums & Mailing Lists

From http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle /db_sblob.html Regards, Guillermo. -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Penza Kenne.... Enviado el: miércoles, 31 de mayo de 2006 15:46 Para: ids@iiug.org Asunto: RE: Smart blobs [6841] Guillermo, >From where can I get the sblobinfo data blade ? Regards Kenneth Penza Technical Services Officer Systems and Database Services Service Management Department Malta Information Technology & Training Services Ltd Please read our Legal Notice: http://emailpolicy.mitts.gov.mt P Please consider your environmental responsibility before printing this e-mail. END OF TEXT -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guillermo G.... Sent: 31 May 2006 15:31 To: ids@iiug.org Subject: RE: Smart blobs [6840] I use casting like length(graf.object_zip::lvarchar::clob) or register sblobinfo 1.5 datablade -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de KENNETH PENZA Enviado el: miércoles, 31 de mayo de 2006 12:31 Para: ids@iiug.org Asunto: Smart blobs [6839] People, Is there a way to get the length of a CLOB or BLOB stored in a smart blob space without retriveing it to a file ? For example query on a system table or use something similar to the length function. Regards Kenneth **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. __________ Información de NOD32, revisión 1.1569 (20060531) __________ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. __________ Información de NOD32, revisión 1.1569 (20060531) __________ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com

↪ replying to Guillermo Gómez Valcárcel
Penza Kenneth at MITTS — — source: IIUG Forums & Mailing Lists

Thanks for the info, I will check it out. Regards Kenneth Penza Technical Services Officer Systems and Database Services Service Management Department Malta Information Technology & Training Services Ltd Please read our Legal Notice: http://emailpolicy.mitts.gov.mt P Please consider your environmental responsibility before printing this e-mail. END OF TEXT -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guillermo G.... Sent: 31 May 2006 17:04 To: ids@iiug.org Subject: RE: Smart blobs [6842] >From http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle /db_sblob.html Regards, Guillermo. -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de Penza Kenne.... Enviado el: miércoles, 31 de mayo de 2006 15:46 Para: ids@iiug.org Asunto: RE: Smart blobs [6841] Guillermo, >From where can I get the sblobinfo data blade ? Regards Kenneth Penza Technical Services Officer Systems and Database Services Service Management Department Malta Information Technology & Training Services Ltd Please read our Legal Notice: http://emailpolicy.mitts.gov.mt P Please consider your environmental responsibility before printing this e-mail. END OF TEXT -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Guillermo G.... Sent: 31 May 2006 15:31 To: ids@iiug.org Subject: RE: Smart blobs [6840] I use casting like length(graf.object_zip::lvarchar::clob) or register sblobinfo 1.5 datablade -----Mensaje original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] En nombre de KENNETH PENZA Enviado el: miércoles, 31 de mayo de 2006 12:31 Para: ids@iiug.org Asunto: Smart blobs [6839] People, Is there a way to get the length of a CLOB or BLOB stored in a smart blob space without retriveing it to a file ? For example query on a system table or use something similar to the length function. Regards Kenneth **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. __________ Información de NOD32, revisión 1.1569 (20060531) __________ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. __________ Información de NOD32, revisión 1.1569 (20060531) __________ Este mensaje ha sido analizado con NOD32 antivirus system http://www.nod32.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads