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
LVL 2
CompTech810Asked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
Please try like. ... Dont know what the error is..

LIKE statement.

SELECT * FROM yourTable
WHERE ENTRY_DATA LIKE '%123456789%'
0
 
Pawan KumarDatabase ExpertCommented:
Please try this-

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
0
 
CompTech810Author Commented:
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
0
 
CompTech810Author Commented:
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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.