ERROR: CLI prepare error: in SAS

Reply
Contributor
Posts: 56

ERROR: CLI prepare error: in SAS

Hi All,

While fetching the data from database i'm getting the below error, Can you please any one help to resolve this..

ERROR: CLI prepare error: ERROR:  Relation 'TMP_VN_XLS_C_1076_CR_20140504' does not exist

SQL statement: select * from TMP_VN_XLS_C_1076_CR_20140504.

Thanks in advance for your help.

Regards

Shiva

Super Contributor
Posts: 297

Re: ERROR: CLI prepare error: in SAS

At the risk of asking a silly question. 

Does the table exist in the DB you are accessing?  Do you have permission to query this Table?

Super User
Posts: 6,963

Re: ERROR: CLI prepare error: in SAS

Get in touch with your database admin. That is most probably an error in the setup of your client/instance.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 949 views
  • 0 likes
  • 3 in conversation