Re: Blob Sizes

Posted in 2000

Obnoxio The Clown — Fri, 31 Mar 2000 08:57:01 BST — source: Informix-list mailing list archive (1991-1998)

From: Vickey Crouch <vcrouch@swbell.net> > >Does anyone have a shell script that reports the blob sizes of each blob >column for a particular database? I'm in the process of migrating some >databases to a new platform, and I'd like to create some blob spaces but >I don't know how big the average blobs are. SELECT avg(collength) FROM syscolumns WHERE colname = "blobcolname" ? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com