Re: SQL Loader - How to load userid without hardcoding

Hi Dave & Keng Cheng !

My Qn :
>> Can anyone tell me the syntax for OR in SQL Loader ?

Your Sol :
Put both conditions into the same control file.

Thanks 4 your replies.

Exactly, I have 6 col in my tables, namely, userid, tablecounter, F1, F2, F3 & F4.

The last 4 fields (F1 or F2 or F3 or F4) can be null. However, in a row the condition
F1 is not null or F2 is not null or F3 is not null or F4 is not null must be met.

If I use your sol, I will have 15 conditions in my control table, .ie. F1 not null, F2 not null, F3 not null, F1 not null. F1 null, F2 not null, F3 not null, F1 not null. etc

I find it very inefficient since 1 condition F1 is not null or F2 is not null or F3 is not null or F4 is not null is sufficient IF ONLY I can find the syntax for OR in SQL Loader. (sigh) ...

Anyway, thanks for your advice.

I appreciate it.

ChorLing
chancl_at_nievax.nie.ac.sg Received on Sun Mar 03 1996 - 21:02:34 CST