topic SQL Error Messsages in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/SQL-Error-Messsages/m-p/43996#M11575 Hi All,<BR /> <BR /> Is there a system option which will give me more meaningful error messages in EG than the below?<BR /> <BR /> ERROR: Prepare error: ICommandPrepare::Prepare failed. <BR /> SQL statement: SELECT C.CLAIMID , C.CLAIMNUMBER , AI.DESCRIPTION , AI.ESTIMATEAMOUNT FROM CBMRV_ASSESSMENTITEM AI , CBMRV_INCIDENT <BR /> I , CBMRV_CLAIM C , CBMRVL_REFERENCELISTS VC , CBMRVL_REFERENCELISTS AA WHERE C.CLAIMID = I.CLAIMID AND I.INCIDENTID = <BR /> AI.INCIDENTID ORDER BY C.CLAIMID VC.DESCRIPTION.<BR /> <BR /> Thank you for your help. Thu, 21 Jan 2010 06:45:36 GMT Scottcom4 2010-01-21T06:45:36Z SQL Error Messsages https://communities.sas.com/t5/SAS-Procedures/SQL-Error-Messsages/m-p/43996#M11575 Hi All,<BR /> <BR /> Is there a system option which will give me more meaningful error messages in EG than the below?<BR /> <BR /> ERROR: Prepare error: ICommandPrepare::Prepare failed. <BR /> SQL statement: SELECT C.CLAIMID , C.CLAIMNUMBER , AI.DESCRIPTION , AI.ESTIMATEAMOUNT FROM CBMRV_ASSESSMENTITEM AI , CBMRV_INCIDENT <BR /> I , CBMRV_CLAIM C , CBMRVL_REFERENCELISTS VC , CBMRVL_REFERENCELISTS AA WHERE C.CLAIMID = I.CLAIMID AND I.INCIDENTID = <BR /> AI.INCIDENTID ORDER BY C.CLAIMID VC.DESCRIPTION.<BR /> <BR /> Thank you for your help. Thu, 21 Jan 2010 06:45:36 GMT https://communities.sas.com/t5/SAS-Procedures/SQL-Error-Messsages/m-p/43996#M11575 Scottcom4 2010-01-21T06:45:36Z Re: SQL Error Messsages https://communities.sas.com/t5/SAS-Procedures/SQL-Error-Messsages/m-p/43997#M11576 You probably should open a track on SAS support for this.<BR /> There are a number of usage notes that describes different kind of prepare errors.<BR /> I'm not sure if you can get any more information than this. If your data resides in an external RDBMS, you could try the sastrace global option, see on-line doc for details.<BR /> /Linus Thu, 21 Jan 2010 07:38:55 GMT https://communities.sas.com/t5/SAS-Procedures/SQL-Error-Messsages/m-p/43997#M11576 LinusH 2010-01-21T07:38:55Z Re: SQL Error Messsages https://communities.sas.com/t5/SAS-Procedures/SQL-Error-Messsages/m-p/43998#M11577 surprising to see no FROM in the generated syntax Sun, 24 Jan 2010 18:37:25 GMT https://communities.sas.com/t5/SAS-Procedures/SQL-Error-Messsages/m-p/43998#M11577 Peter_C 2010-01-24T18:37:25Z