Loading a |^* delimited file to a table

[syedasiftanveer]

I have to load a file that has delimiter |^*.
I am using:


LOAD FROM D:\Branches.csv OF DEL MODIFIED BY NOCHARDEL COLDEL|^* INSERT INTO branches

This is separating columns on | while ^* remains with the data. How to make whole |^* a delimeter.


I am using Win7 OS and DB2 V9.7
Thanks