https://communities.sas.com/t5/SAS-Enterprise-Guide/SQL-Query-CLI-prepare-error/m-p/964516#M45902 <P>What's wrong with this script ? it work fine on the production server but not on the development server even if the tables exist.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc sql; create table test as select contractVer.* from cntrctDM.DIM_PL_CNTRCT_VER contractVer ; quit; ERROR: CLI prepare error: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.SQL statement: SELECT * FROM CONTRACTPL_DM.DIM_PL_CNTRCT_VER.</CODE></PRE> Thu, 17 Apr 2025 14:25:44 GMT alepage 2025-04-17T14:25:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SQL-Query-CLI-prepare-error/m-p/964516#M45902 <P>What's wrong with this script ? it work fine on the production server but not on the development server even if the tables exist.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc sql; create table test as select contractVer.* from cntrctDM.DIM_PL_CNTRCT_VER contractVer ; quit; ERROR: CLI prepare error: Cannot perform SELECT. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.SQL statement: SELECT * FROM CONTRACTPL_DM.DIM_PL_CNTRCT_VER.</CODE></PRE> Thu, 17 Apr 2025 14:25:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SQL-Query-CLI-prepare-error/m-p/964516#M45902 alepage 2025-04-17T14:25:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SQL-Query-CLI-prepare-error/m-p/964566#M45912 <P>&nbsp;</P> <P>Do both <CODE class=" language-sas">libname</CODE> definitions include the database name? What about the ODBC driver definitions?</P> <P>&nbsp;</P> Fri, 18 Apr 2025 04:14:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SQL-Query-CLI-prepare-error/m-p/964566#M45912 ChrisNZ 2025-04-18T04:14:12Z