4 Replies Latest reply: Jan 9, 2012 6:23 PM by silviu andries RSS

    Unable to load table with WHERE condition on data field...pls help

    silviu andries
      Hi all,

       

      I have the following load script:

       

      .......

      SET TimestampFormat='DD-MM-YYYY';

      .......

      LOAD

       

       

       

       

      My problem is:

      If i load the table without the WHERE condition, my EVENT_DATE field is in corect format (DD-MM-YYYY).

      After I put the WHERE condition, EVENT_DATE transforms to numeric format (ex: 38270)...and my WHERE condition is not working...but I don't receive any error in executing the script.

       

      I wold like to give the condition for loading my table where EVENT_DATE>'01-01-2011' and the EVENT_DATE field format to remain the same...

       

      Thanks a lot!

      CLAIM_ID,

      CLAIM_REGID,

      CLAIM_STARTED,

      EVENT_DATE,

      INSR_TYPE FROM

       

      EVENT_DATE > '01-01-2011';[C:\...CLAIM.qvd]

      WHERE