topic ERROR: CLI prepare error: in SAS in SAS Programming https://communities.sas.com/t5/SAS-Programming/ERROR-CLI-prepare-error-in-SAS/m-p/184388#M265480 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>While fetching the data from database i'm getting the below error, Can you please any one help to resolve this..</P><P></P><P>ERROR: CLI prepare error: ERROR:&nbsp; Relation 'TMP_VN_XLS_C_1076_CR_20140504' does not exist</P><P>SQL statement: select * from TMP_VN_XLS_C_1076_CR_20140504.</P><P></P><P>Thanks in advance for your help.</P><P></P><P>Regards</P><P>Shiva</P></BODY></HTML> Wed, 04 Jun 2014 06:56:12 GMT shivakrishna 2014-06-04T06:56:12Z ERROR: CLI prepare error: in SAS https://communities.sas.com/t5/SAS-Programming/ERROR-CLI-prepare-error-in-SAS/m-p/184388#M265480 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>While fetching the data from database i'm getting the below error, Can you please any one help to resolve this..</P><P></P><P>ERROR: CLI prepare error: ERROR:&nbsp; Relation 'TMP_VN_XLS_C_1076_CR_20140504' does not exist</P><P>SQL statement: select * from TMP_VN_XLS_C_1076_CR_20140504.</P><P></P><P>Thanks in advance for your help.</P><P></P><P>Regards</P><P>Shiva</P></BODY></HTML> Wed, 04 Jun 2014 06:56:12 GMT https://communities.sas.com/t5/SAS-Programming/ERROR-CLI-prepare-error-in-SAS/m-p/184388#M265480 shivakrishna 2014-06-04T06:56:12Z Re: ERROR: CLI prepare error: in SAS https://communities.sas.com/t5/SAS-Programming/ERROR-CLI-prepare-error-in-SAS/m-p/184389#M265481 <HTML><HEAD></HEAD><BODY><P>At the risk of asking a silly question.&nbsp; </P><P></P><P>Does the table exist in the DB you are accessing?&nbsp; Do you have permission to query this Table?</P></BODY></HTML> Wed, 04 Jun 2014 07:08:53 GMT https://communities.sas.com/t5/SAS-Programming/ERROR-CLI-prepare-error-in-SAS/m-p/184389#M265481 Scott_Mitchell 2014-06-04T07:08:53Z Re: ERROR: CLI prepare error: in SAS https://communities.sas.com/t5/SAS-Programming/ERROR-CLI-prepare-error-in-SAS/m-p/184390#M265482 <HTML><HEAD></HEAD><BODY><P>Get in touch with your database admin. That is most probably an error in the setup of your client/instance.</P></BODY></HTML> Wed, 04 Jun 2014 07:14:12 GMT https://communities.sas.com/t5/SAS-Programming/ERROR-CLI-prepare-error-in-SAS/m-p/184390#M265482 Kurt_Bremser 2014-06-04T07:14:12Z