Loading a file containing a LOB
Loading large objects always requires special considerations. Here, we will create a multi-technology IKM (that is, an IKM that connects to a remote source data server) that loads
BLOBs using an external table definition.
For this recipe, we will need to create three files on disk:
CLOB.TXT: use notepad and write
This is a CLOBin this file. Save it on disk in your
BLOB.DOC: use a word processor program and create this file. Write
this is a BLOBin the file and save it in your
- Use notepad and create the file
DATA.TXTwith the following record:
"Sample record with CLOB and BLOB", "CLOB.TXT", "BLOB.DOC"
- Save this file in your
- Create a table to ...