This is the general format that SAS uses to pass back an error message thrown by Sybase IQ, so you need to figure out what's going wrong in the Sybase IQ environment.
In addition to the other comments, which are spot-on, I notice that you appear to be using the ODBC interface to Sybase IQ. SAS has released a native connection engine for IQ, which in my experience worked much better. If possible, I suggest that you acquire that and use it. You may see performance and reliability benefits, as IQ works significantly differently from regular ODBC-type databases.
One problem that I recall was that SAS by default was asking for way too few records to be returned at a time, which was hammering performance.
Note that all of these comments apply to when I was last working with SAS and IQ, circa 2012, so things may have changed.
Tom
... View more