I have created a table in Oracle with a column FIELD1 which is defined as VARCHAR2(20 BYTE)  NOT NULL. Users are able to append data to this table using SAS Enterprise Guide. I need to prevent them from appending data where FIELD1 is blank. However if the users make FIELD1 ='' in SAS (ie. blank or empty) they are able to append to the Oracle table so NOT NULL is not doing the trick.  Appears that SAS interprets = ''  as a character field with a length of 1  rather than a null.     ... View more

When running the following join in SAS Enterprise Guide, an additional query is being generated on the Oracle DB which is extremely long running and is causing production performance issues.  Does anyone have any idea how to stop this additional query being generated on Oracle?   Actual query submitted on Linux platform (modified slightly for this platform): proc sql; create table work.outputtable as select t1.filename, t1.int_cell_phone, t1.response_dttm, t1.country, t2.account_id, t2.org_id from work.SAS_table1 t1 inner join ci_mart.ma_account t2 /*** oracle table ***/ on t1.customer_rk = t2.customer_rk; quit;   Additional long running query being generated on Oracle "automatically" (ie. not in the submitted code): SELECT "ACCOUNT_ID", "ORG_ID", "CUSTOMER_RK" FROM CI_MART.MA_ACCOUNT WHERE ((("CUSTOMER_RK"=:"CUSTOMER_RK") OR (("CUSTOMER_RK" IS NULL ) AND ( :"CUSTOMER_RK" IS NULL ))))   ... View more