Reading a BLOB field

Reading a BLOB field

I am creating a VB.NET process that will use BLOBS on the AS400 to store the information. My question is how using VB.NET how can I insert and extract objects from the BLOB on the AS400.

Reading a BLOB field

Are there any tools on the iSeries (maybe in SQL) that can be used to read a BLOB field? (binary large object)?

Reading a BLOB field

BLOBs can be accessed by Java programs or SQL stored procedures natively on the 400 (without a client program), but most BLOBs aren't really useful until you get them on a client. You might be able to do BLOBs in ILE but I haven't tried. Try here for details, page 94, References to LOB Host Variables: http://www-900.ibm.com/cn/support/li...nce%20R440.pdf

[David Abramowitz]

TTBOMK, BLOBs can be created and stored in DB2/UDB/400 via SQL, but they can only be accessed through client programs. Dave