topic Problem in SAS SMC while creating New Library under Data Library Manager in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-SAS-SMC-while-creating-New-Library-under-Data-Library/m-p/64624#M6510 While creating a Library (Type: DB2 Library for Unix and PC Hosts) <BR /> <BR /> Why we need to create separate database schema in SAS for pointing to same schema in<BR /> <BR /> DB2 Data base while creating more than one library pointing to that common DB2 Schema.<BR /> <BR /> If we use the same SAS schema name for another library and import tables in that library then the contents of the newly created library are overwritten on the previous library also. <BR /> <BR /> Why this is so ? Can this problem be rectified while using the same SAS Schema name ? Fri, 14 Aug 2009 11:55:47 GMT saurabh303 2009-08-14T11:55:47Z Problem in SAS SMC while creating New Library under Data Library Manager https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-SAS-SMC-while-creating-New-Library-under-Data-Library/m-p/64624#M6510 While creating a Library (Type: DB2 Library for Unix and PC Hosts) <BR /> <BR /> Why we need to create separate database schema in SAS for pointing to same schema in<BR /> <BR /> DB2 Data base while creating more than one library pointing to that common DB2 Schema.<BR /> <BR /> If we use the same SAS schema name for another library and import tables in that library then the contents of the newly created library are overwritten on the previous library also. <BR /> <BR /> Why this is so ? Can this problem be rectified while using the same SAS Schema name ? Fri, 14 Aug 2009 11:55:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-SAS-SMC-while-creating-New-Library-under-Data-Library/m-p/64624#M6510 saurabh303 2009-08-14T11:55:47Z Re: Problem in SAS SMC while creating New Library under Data Library Manager https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-SAS-SMC-while-creating-New-Library-under-Data-Library/m-p/64625#M6511 Why do you need more than one SAS library pointing to the same DB2 schema?<BR /> /Linus Fri, 14 Aug 2009 14:18:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-SAS-SMC-while-creating-New-Library-under-Data-Library/m-p/64625#M6511 LinusH 2009-08-14T14:18:12Z