How to avoid conversion for running procedure $ is converted to _ and = is converted to LIKE?
Article ID: KB0070973
Updated On:
| Products | Versions |
|---|---|
| ibi WebFOCUS | WebFOCUS 9 |
Description
Running the below SQL trace "$" is converted to "_" and "=" is converted to "LIKE".
Repro :-
SET TRACEOFF = ALL
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = ON
SET XRETRIEVAL = OFF
TABLE FILE EMP
SUM SAL NOPRINT
BY JOB
WHERE JOB EQ '$';
END :-
Issue/Introduction
How to avoid conversion when executing procedure with special characters "$" is converted to "_" and "=" is converted to "LIKE".
Environment
WebFOCUS 8105 and 9.
Resolution
Previously WHERE JOB EQ '$' changing to JOB LIKE '$'.
Repro Step
SET TRACEOFF = ALL
SET TRACEON = STMTRACE//CLIENT
SET TRACEON = SQLAGGR//CLIENT
SET TRACEUSER = ON
SET XRETRIEVAL = OFF
TABLE FILE EMP
SUM SAL NOPRINT
BY JOB
WHERE JOB LIKE '$';
END
Additional Information
Case 02089449
Feedback
Yes
No
Powered by
