We can read data from tables in the libname without any issues. But anytime we try to update the table, the SAS does not respond and we can only resolve this issue by killing SAS program from the Task manager. For example we add a row to the table using proc append command:
proc append data = data1 base = myLIBNAME.data2; run;
I will really appreciate any insight into this issue or if any one had a similar experience.