Byte Column to Blob Column

Posted in 2011

Summary

Samuel Jakabowski, on Informix 10.00 (Solaris), asked how to join scanned manual pages stored one per row in a BYTE column into one document in a blobspace. Paul Watson suggested a Linux tool such as pdfsam to merge images. Samuel said security forbids third-party software on the Sun systems and the pages total about 5 TB; Paul replied to unload to disk and copy to Linux. No in-database method was given.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: SQL Development & Query Writing, Platform-Specific Issues

SAMUEL JAKABOWSKI — Sat, 25 Jun 2011 19:18:51 — source: IIUG Forums & Mailing Lists

Guru's We have a table that contains manuals , The fields are man_ name (char), page_number (int) and scanned_page (byte). Each page of a manual is in its own row. Is there an easy way of joining the pages together and inserting the complete manual into a blob space, We are on Informix 10.00 on a Solaris box Thanks

↪ replying to SAMUEL JAKABOWSKI

Paul Watson — Sun, 26 Jun 2011 08:32:59 — source: IIUG Forums & Mailing Lists

There are a number of Linux utilities that can merge multiple scanned images into a single document. Check out www.pdfsam.org, AFAIK its around $20 and worth every cent Cheers Paul > Guru's > > We have a table that contains manuals , The fields are man_ name (char), > page_number (int) and scanned_page (byte). Each page of a manual is in its > own > row. > > Is there an easy way of joining the pages together and inserting the > complete > manual into a blob space, > > We are on Informix 10.00 on a Solaris box > > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid.

↪ replying to Paul Watson

SAMUEL JAKABOWSKI — Sun, 26 Jun 2011 13:55:07 — source: IIUG Forums & Mailing Lists

Thanks for the suggestion. Security will not allow third party software on Sun systems. The manuals/pages were migrated from the old 7.31 environment. The pages occupy around 5 TB of the instance

↪ replying to SAMUEL JAKABOWSKI

Paul Watson — Sun, 26 Jun 2011 15:03:37 — source: IIUG Forums & Mailing Lists

Unload to disk, copy to Linux :) > Thanks for the suggestion. Security will not allow third party software on > Sun > systems. The manuals/pages were migrated from the old 7.31 environment. > The > pages occupy around 5 TB of the instance > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > -- Paul Watson Tel: +1 913-674-0360 Mob: +1 913-387-7529 Web: www.oninit.com www.advancedatatools.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid.