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
View original
Error saving CQ with Modify
Userlevel 1
+1
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.
+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:
https://striim.com/docs/en/modifying-and-masking-values-in-the-waevent-data-array-using-modify.html
+1
I meant the difference between aliased and unaliased SELECT. One producing WAEvent, the other not
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.