I have to retrieve an Image against its Id from Database and send it to shared directory(as of now into my local directory). Earlier I did it with the help of stored procedure but later we got to know that we cannot use stored procedure as we are building application for the third party. So we have to do it in MB only.
Now I am stuck at the point that with the help of 'fileOutput' node how to propagate an image( which is in blob)and most important, how to process this blob into the target directory so that image will be accessible.
With the help of below code, I can propagate the Blob into target directory, but as I am not processing the blob , I am not able to open this image.
Please suggest me the way so that I can complete this requirement.
SET SqlQuery='SELECT FORM_CONTENT FROM prtformtbl WHERE FORM_ID = '||CAST (formId AS CHAR);
SET data.list = PASSTHRU(SqlQuery);
--Send the XML doc into the shared directory
SET OutputRoot.XMLNSC.ns:sendFaxResponse.dummy= data.list.FORM_CONTENT;
PROPAGATE TO TERMINAL 'out1' DELETE NONE;