CompTech810
asked on
System I Navigator Journal SQL
Hello Experts.
I have journaling turned on to capture field changes on particular files. It is collecting data but I need to use the Additional Filters area to further define the data I need to filter. I'm not sure what SQL command it needs to do this. The field I need to filter on is ENTRY_DATA. I have tried WHERE ENTRY_DATA CONTAINS '123456789' and when I apply the filter I get a message that is attached. Can someone give me a sample of the SQL command I should use. Thanks!
Exception.jpg
I have journaling turned on to capture field changes on particular files. It is collecting data but I need to use the Additional Filters area to further define the data I need to filter. I'm not sure what SQL command it needs to do this. The field I need to filter on is ENTRY_DATA. I have tried WHERE ENTRY_DATA CONTAINS '123456789' and when I apply the filter I get a message that is attached. Can someone give me a sample of the SQL command I should use. Thanks!
Exception.jpg
ASKER
Hi Pawan.
I used this SQL statement because it failed on WHERE: CONTAINS(ENTRY_DATA , '123456789')=1
Now I'm getting this attached error...
Exception2.jpg
I used this SQL statement because it failed on WHERE: CONTAINS(ENTRY_DATA , '123456789')=1
Now I'm getting this attached error...
Exception2.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked with the exception that I only had to use: WHERE ENTRY_DATA LIKE '%123456789%' I have attached a print screen of the filters for the Journal
Thanks Pawan!
Thanks Pawan!
WHERE CONTAINS(ENTRY_DATA , '123456789') = 1
Please refer contains for more details here - https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_bif_contains.html