Problems with Remove statment

[jymm]

I have never had the occasion to use 'Remove' with a SAS program that is going through an ODBC connection to a SQL 2000 db - 'till yesterday.

I issue the statements:
---
Data SQLDB.entity_channels;
Modify SQLDB.entity_channels Work.RemoveEntityChannel;
by entity_id;
If channel_entity_id = REMOVEchannel_entity_id
Then remove;
---

In the log I even get that SAS thinks that the record(s) have been deleted. No such luck. The records still exist in the DB. I will send something to SAS support with a trace, but thought I would ask the people here as well.

 

[jymm]

well - shh-golly folks - I figured it out on my own (sorry all of those people who want stars).

so darn simple too.

When defining my ODBC connection I had intentionally left off the BCP= statement which seems to slow things down DRAMATICALLY when I do any 'Proc Append' or any modify procedures (like above) where I am JUST modifying the data in the SQL databases. Adding the BCP=YES made everything fly - and all is good and true in the world again.

libname SQLDB odbc
dsn=sqlserver DATASRC="CRMTestDB" bcp=yes;