Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    63

    Unanswered: Load utility issue

    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
    Mohd

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •