Retrieving BLOBs to IFS

["Klein, Ron" <ron.klein@xxxxxxxxxx>]

Hi All,
I have some files that have 10 fields, the first two fileds are the key
data, the next group of 4 fields are BLOB fields with a size of 1048576. and
The next group of 4 is the same.  Each of these groups of 4 represent a PC
based file.  One is a drawing and one is the data related tot he drawing.
What I need to do is extract each group of 4 concatenate them together and
place them in an IFS directory.

Is this possible to do in SQL or CL or what can I use and how do I proceed
with this keeping this in the 400 environment and not looking at a PC
solution.

Right now Powerbuilder is used to manage these files and that is why they
are split like they are.  PB couldn't support anything larger that the sizes
listed.

TIA
Ron