problem dumping files to disk
Posted in 2004
Topics: Migration, Import/Export & Data Conversion
Hi, I've been tasked with exporting certain documents from our Informix DB ( Universla Server version 9.14 UC5) for use in importing elsewhere - these docs might be Word/pdf/excel etc. . However, when I have come to export the documents, some are created on disk correctly and some don't get created at all. I have used the lotofile function and unload to .... commands which both work for some docs but not others. i.e. I know which tables and column the documents should exist in because I can access them via a web application which was built using DDW and which in turn accesses them via the web databalade. But when I come to specifically export what I think is the correct blob column /row in the relvant table there appears no blob stored in the table. One of the clues I have is that for the file I am successful with, if I query the relevant row using SQL editor in the lo_pointer column I get e.g. lld_llob; length=xxxxx where as for the ones that fail I get a length = 0. I am therefore trying to work out where the blob is actually stored. Going thorugh the DDW code hasn't helped much as it seems to create a hugely long pointer which doesn't seems to work in SQL queries. Thanks in advance on any ideas how to progress. I need to understand how blobs are refrence via the web datablade and the way in which infromix stores blobs e.g is there a way of exporting a whole table ? and would the documents/blobs have regonisable filenames if I did this? Chris