3
I have in a table a field of type BLOB(BLOB SUB_TYPE 0 SEGMENT SIZE 80) where I store some binary files.
I need to extract all the files stored in that table. Through Ibexpert in the "Data/Form view" tab is displayed a field where I can right click on "Save to file" option and save this file normally.
Now I own thousands of records files must be extracted.
Is there any way through Ibexpert or your script tool Ibescript where can I extract all these files at once? Is there any other tool that I can do this?
Note: I even managed to extract these files through the function ibec_ExtractMetadata from Ibexpert itself, however, it extracts all the files from table I only one file in Hexadecimal format, the extension of this file is .lob. I could not proceed to convert it to binary file.
Note: In the last case I will create a program through Delphi to extract these files.
In case of error, try increasing the varchar field from 80 to 1000.
– Claudio Santos