SQL Error Messsages

[Scottcom4]

Hi All,

Is there a system option which will give me more meaningful error messages in EG than the below?

ERROR: Prepare error: ICommandPrepare::Prepare failed.
SQL statement: SELECT C.CLAIMID , C.CLAIMNUMBER , AI.DESCRIPTION , AI.ESTIMATEAMOUNT FROM CBMRV_ASSESSMENTITEM AI , CBMRV_INCIDENT
I , CBMRV_CLAIM C , CBMRVL_REFERENCELISTS VC , CBMRVL_REFERENCELISTS AA WHERE C.CLAIMID = I.CLAIMID AND I.INCIDENTID =
AI.INCIDENTID ORDER BY C.CLAIMID VC.DESCRIPTION.

Thank you for your help.

[LinusH]

You probably should open a track on SAS support for this.
There are a number of usage notes that describes different kind of prepare errors.
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.
/Linus

[Peter_C]

surprising to see no FROM in the generated syntax