BookmarkSubscribeRSS Feed
saroj
Calcite | Level 5
Hi I want to delete rows from a db2 table as shown in below code. the table has a qualifier name followed by table name. ADRPMMT - is the table qualifier and INV_COMM_CONV_RATE is the table name. But it is taking ADRPMMT as SAS libname. please let me know what change is required to the code.
22 PROC SQL;
23 CONNECT TO DB2(DB2SSID=DB39);
24 DELETE FROM ADRPMMT.INV_COMM_CONV_RATE
25 WHERE ROW_LOAD_DATE = &CHKDATE ;
ERROR: Libname ADRPMMT is not assigned.
ERROR: Libname ADRPMMT is not assigned.
ERROR: Libname ADRPMMT is not assigned.
ERROR: Libname ADRPMMT is not assigned.
ERROR: Libname ADRPMMT is not assigned.
ERROR: Libname ADRPMMT is not assigned.
2 REPLIES 2
LinusH
Tourmaline | Level 20
If you are using DELETE FROM in "open" proc sql code, it will assume that twp level table names will contain a SAS libname. In fact, it requires that you first assign a libname to your DB2 database.

But by using CONNECT TO, you are using SQL pass-thru. To use pass-thru to delete records enclose your DB2 specific SQL using execute:

EXCUTE( ... ) BY DB2;

/Linus
Data never sleeps
saroj
Calcite | Level 5
Thanks Linus , it worked !

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1116 views
  • 0 likes
  • 2 in conversation