Problem using the where clause in the load script;

[#1]

Hi,

Please could someone point me in the right diretion on this.

I'm trying to load this table but only where the Security_Ac field is not blank..... but its erroring and I've tried every Null permiatation I can think of.

Please help!   Thank you.

Example of the load script:

SECURITIES_ACCT:

LOAD    @1:5 as [Security_Ac],

               @6:21 as [Customer_No],

               @22:27 as [Close_Date],

FROM

COSMIC_SECURITIES_ACCT.txt

(fix, codepage is 1252, no eof);

Where not IsNull ([Security_Ac]);

Many thanks, Matt

[PrashantSangle · Accepted solution]

Hi,

Remove ; before Where clause

SECURITIES_ACCT:

LOAD    @1:5 as [Security_Ac],

               @6:21 as [Customer_No],

               @22:27 as [Close_Date],

FROM

COSMIC_SECURITIES_ACCT.txt

(fix, codepage is 1252, no eof)

Where not IsNull ([Security_Ac]);

[PrashantSangle]

and , after close_date

Regards

[#4]

Thank you Max..

[PrashantSangle]

Hi,

you Welcome

Your issue is solve or not???

Regards

[#6]

Hi Max - Yes - resolved - Thanks.

Not sure how to mark it as resolved.. can only see mark as Helpful.

[PrashantSangle]

Hi,

Good, I just want to confirm that it worked or not??

Its good that you got the answer.

Regards