Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2011
    Posts
    1

    Unanswered: How to insert contents into BLOB without using SQl???

    Hi,


    Can anyone resolve my issue on inserting the data into BLOB column using scripts alone rather than using SQL query??? Is tat possible???

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I don't understand the question
    you can only insert in a db/table/col data by use of sql
    the sql can be in a flat file and executed with db2 -tvf command
    or with script invoking db2 ".............."
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    A BLOB is a value in a database. So the only way to get such values into the database or to retrieve them from there is through the means provided by the database system. That means: SQL.

    What you could probably do is to store the data in a file in the file system and only the path in the database. Then you can access the data directly and bypass the database system. But in this case you'd probably use a VARCHAR and not a BLOB to store the path to the file.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Nov 2011
    Posts
    334
    You can use import command with modified by lobsinfile option to insert file into lob col...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •