We have recently repoint the DB from abc to xyz by updating the DB2 agent catalog entry and we keep alias as a same as we have used alias in most of codes and also defined in WebSphere to connect the UI. Database alias = DB_connect (Not changed as same alias defined in sas codes) Database name = XYZ (*****changed from abc to XYZ*****) After updating the catalog entry in DB and compute server, all the UI (websphere) connecting to new DB(XYZ) but when we run the sas code in SAS EG its still connecting to old DB (ABC) Please advise how I can troubleshoot?
... View more
@LinusH New DB (XYZ) is clone of existing of DB(ABC) its has same schema name and other attributes. Can we change anything outside of sas codes? like JDFC
... View more
@SASKiwi Please see below details. Just want to let you know we have hardcoded DB name in more then 100 codes so its not practical change the DB name in sasconfig or all all these sas codes. Can we repoint DB name change outside of sas codes ? like JDBC level? %let DBConnOpts = %str(database=DBname); %let DBLibOpts= %str();
... View more
@SASKiwi Libname is defined in one of sas config file. We have not defined Libname in metadata. For example. libname DB_schema &DBFlavor user=abc password=????? &DBConnOpts &DBLibOpts;
... View more
Could you please lets us know what change are required if we want to repoint the DB2 DB to new DB? Currently we are using SAS, its connecting to DB2 DB called 'ABC' , Now we have created another DB 'XYZ' and we want to repoint the DB to 'XYZ' instead of 'ABC' When we access the UI and submit the jobs it will point to the new DB 'XYZ'
... View more
Hello, Could you please help me to check the Oracle SQL definition (including null exception) with SAS EG? We don't have access to Oracle that's why unable to check null exception in oracle. Below SAS EG query not return sql exception. proc sql; describe table abc; run;
... View more