SYMPTOM:
When attempting to incorporate the use of wildcards as comments in Report Pre Statement in VLDB properties for reports against Sybase IQ 15.4, error message appears.
If use "!o" to get the report name, the report execution fails due to another error.
Error message 1:
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:-131: on SQLHANDLE] [Sybase][ODBC Driver][Sybase IQ]Syntax error near '(end of line)' on line 1 Connection String: DSN=Sybase;UID=sjiao;. SQL Statement: /*Report Name*/...
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. Procedure 'Project Name' not found Connection String: DSN=Sybase;UID=sjiao;. SQL Statement: Project Name...
3. Run report. Error message 1 is thrown out.
4. Go to Date -> VLDB Properties -> Pre/Post Statements -> Report Pre Statement. Uncheck User default inherited value and add statement: /*!p*/.
5. Run report. Error message 2 is thrown out.
CAUSE:
This is a known issue in Strategy 9.4 to handle the comments on Sybase IQ 15.
ACTION:
Contact Strategy Technical Support for the update of the issue.
WORKAROUND:
As a workaround, users can add some SQL after the comments like:
/*!o*/ select 1
The additional statement 'select 1' does not affect the report result but it helps to prevent the error message.
