Ho to avoid loading of data with null datetime

[Anonymous]

    Hi,

I am trying to load data with Casenum,Startdate(datetime),enddate(datetime), i want to drop the coulumns with null datetime while loading,  can anyone help me to solve this.

Best Regards,

Arjin.

AGMT_NUM	Start_date	End_Date
160429055		29Apr2016 14:07:19
160429055	29Apr2016 14:07:19
160429055	29Apr2016 14:07:51	29Apr2016 14:07:59
160429055	29Apr2016 14:07:59	09May2016 14:52:22
160429055		09May2016 15:45:06
160429055	09May2016 15:45:06	09May2016 16:36:22
160429055	09May2016 16:36:22	10May2016 17:53:49
160429055		10May2016 17:55:50
160429055	10May2016 17:55:50	10May2016 18:11:46
160429055	10May2016 18:11:46	10May2016 18:14:38
160429055	10May2016 18:14:38
160429055	11May2016 9:15:34	11May2016 10:28:28
160429055		11May2016 12:12:52
160429055	11May2016 12:12:52	11May2016 12:13:19
160429055		11May2016 12:14:45

[muthukumar77]

In last line should be there,

WHERE START_DTTM is NOT NULL and END_DTTM is NOT NULL;

[michael_klix]

at least it looks much easier... why should we use the complex version ?

my version would be

• if both dates must be available

WHERE(not IsNull(date1) and not IsNull(date2))

• if only one date is needed

WHERE(not IsNull(date1) or not IsNull(date2))

[Anonymous]

Hi

Maybe try amending the load part of your script to just

LEAPS_MASTER:

LOAD

CASE_NUM,

and commect out the other fields in your load and make sure this loads using your where statement. Once it is loading you can add your other date fields etc. Just to make sure your statement is correctly coded.

[ramasaisaksoft]

Hi Arjin,

You told the below condition is working fine in Inline Load

Where len(Trim(Start_date))>0 and Len(Trim(End_Date))>0

I have a doubt about your ODBC Connection so please check it first.

Case 1:- if you tried with your DB it is throwing error means,First you can  check without where condition ur query  fetching the data from your database or not?

if it is fetches then this will also work.