I have a search that performs a basic dbxquery connection and SQL search. If the database table were to be dropped or there were any other errors encountered during the search, I would like the rest of the SPL to keep chugging along.
Is there a creative way to continue past the dbxquery error?
This is a simple example looking up an Oracle DB name:
| makeresults
| eval connection_name="<my db connection>"
| map search="| dbxquery connection=$connection_name$ query=\"select * from global_nameWRONG;\""
| eval test="didn't get here"
| table GLOBAL_NAME,test