Hi

I am using DB2 8.1 on windows
I want to load data from a text file to a table.
text file data is having TAB as delemiter , how to specify it in load command.
also the data contains (,) comma in some of the data values.
when i tried to load it using default del it took comma as delemiter

Please help

Thx

example:
----------------------------
IMPORT FROM "C:\ABEL.TXT" OF DEL MODIFIED BY CHARDEL"" COLDEL, DECPT. METHOD P
(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28)
MESSAGES "C:\ABEL.img" INSERT INTO DB2DWAD1.H0_ATI_PARTES
(PROPIET, NIVEL, FECHACLAVE, HORACLAVE, AREA, SISTEMA, N_PARTE, F_INGRE, TITULO,
PRIORIDAD, CLIENTE, SECTORCLIENTE, PLAZO, RECEPTO, ASIGNO, A_INICIO,
A_FIN, A_HS, E_INICIO, E_FIN, E_HS, ESTADO, DATO, PRESUP, PROYECTO, REQUERIMIENTO, INDICADOR, MARCACIERREMENSUAL);
-------------------------------
chardel: is the character delimiter
coldel: is the column delimiter
DECPT: is the decimal point

the tab delimiter I think was is |, but no sure.
good luky