Error saving CQ with Modify

  • 5 October 2023
  • 4 replies

Userlevel 1
Badge +1

I am trying to write a CQ with MODIFY statement that replaces all “Not Available” to NULL but I am getting an error “Left expression do not refer to an object”. Please refer to the screenshot for reference.



Best answer by Sid 6 October 2023, 00:34

View original

4 replies

Userlevel 1
Badge +5

Modify function needs WAEvent as output stream.

SELECT * FROM OracleOutputStream; creates a typed/user-defined event

SELECT d FROM OracleOutputStream d; creates a WAEvent

Using * instead of an alias creates a user-defined event. Hence, there is an error in saving the component.

Badge +1

This helped, thanks! Where could I find description of this behaviour in documentation?

Userlevel 1

You can find a doc article on Striim’s MODIFY operator here:


Badge +1

I meant the difference between aliased and unaliased SELECT. One producing WAEvent, the other not