We have db2 7.2 for OS/390 with the connect clinet. All the latest fixpacks installed etc.

Someone asked if a lob could be inserted into a table from the command line. (Using the connect client on a linux or windows machine)

I never tried to insert lobs that way. Can it be done?

Any input would be helpful
Thanks
Bob.

CLP, not CLI.

Yes, you can. Here's a clob:

db2 "create table blah4 (a clob(100))"
DB20000I The SQL command completed successfully.

db2 "insert into blah4 values ('asdf')"
DB20000I The SQL command completed successfully.

I ment CLP not CLI sorry,

Thanks for the info. I knew some text could be inserted into a clob what we are looking for is a way ot insert a file (like a pdf file) into a blob.

Sorry I should hav e been more specific in my first thread.

Sort of, you can use HEX:
db2 "insert into blah6 values (BLOB(X'000000'))"

What it sounds like you want is something sort of like the XMLClobFromFile() function... but unfortunately I don't think such a beast exists, you'd have to write it yourself, and it needs the file to be on the server.

Sounds like you'll probably need to write an app to do what you want.