Saving BLOB column content as a file in BTEQ / Procedure

Tools

Saving BLOB column content as a file in BTEQ / Procedure

I have a table with a BLOB column containing a '.ZIP' file.
I am able to manually fire a select and save it to a by providing the required file-.

I just need a simple command to do it automatically where I can hardcode the PATH and EXTENSION to which I can save it.

It can be incorporated either in a Bteq or a Stored Proc... to pull out these Files from the BLOB column and save them at the same folder as valid .zip files.