1. Forum
  2. Usenet
  3. COMP.SYS.IBM.AS400.MISC

  • Extract BLOB column data to a file with CL or SQL?

    From gary@cci-consultants.com@21:1/5 to JohnO on Tue Sep 25 09:13:05 2018
    On Monday, September 17, 2012 at 5:59:51 PM UTC-5, JohnO wrote:
    Hi All,

    I have an application that is generating various kinds of files (mostly PDFs) and saving them in BLOB columns in a db2 for i database table.

    I may need to write a utility to extract these out to an IFS file. I can do this with an C embedded SQL program but wonder if this can be done with a SQL stored procedure or with a CL command - is that possible? It seems there's no SELECT ... INTO :
    file type command for a SQL procedure so I suspect not...

    Thanks
    John


    Hello -

    I need to do the opposite, ie copy a bunch of ifs files to a blob column in a table. Each record in the table will have one ifs file and I know the key values to populate the other fields in the table. Does anybody have any suggestions how to do in
    RPGLE or SQL.

    Thanks
    Gary W.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)