DB2 Version:8.1.2 Linux

I´m trying to LOAD a table that has a LOB column.
The LOAD is processed directly in the Server.
The load comand is:

LOAD CLIENT FROM OracleCatalog_SFCI1_TBCERTIDAOIMOBIL.out of ASC LOBS FROM OracleCatalog_SFCI1_TBCERTIDAOIMOBIL/ MODIFIED BY LOBSINFILE reclen=409 striptblanks METHOD L(1 9,11 65,67 321,323 323,325 359,361 361,363 388,390 395,397 406) NULL INDICATORS (0,0,409,0,0,0,0,0,0) REPLACE INTO TBCERTIDAOIMOBIL

I get the following message for all the rows:
SQL3512W The file named in row "1" and column "325" cannot be found, but the target column is not nullable. The row was not loaded.

I checked the files and they are in the correct location.
Could you help me with this problem ?????

Hi,

use absolute path to specify the lob source

kirna

Hi,

I tried but it didn´t work.Same error message.
Any other tip ?

What do file paths look like in OracleCatalog_SFCI1_TBCERTIDAOIMOBIL.out ?

The file paths look like:
D0/C1.out.1489243.2184/

"D0" is a subdirectory below OracleCatalog_SFCI1_TBCERTIDAOIMOBIL
"C1.out" is the file and ".1489243.2184" I don´t know what it is.

I assume you have checked file permissions...

Actually, the file names seem a bit suspicious to me - those slashes at the end... Have you generated your ASC files using DB2 or something else? I'm asking because when DB2 EXPORT generates LOB file names they are terminated by null characters (0x00).

Yes, I checked file permissions and both files were generated by "Oracle to DB2 Migration Toolkit"