I stumbled across the following error (included below) while using the navigator feature.
It looks like the query DBVis uses isn't correct for the field data type.
As it's a "char for bit data" field the value should be enclosed as follows:
The x is all important. This is pretty consisten and this happens across all char for bit data fields I've tried through the navigator.
An error occured while executing the database request for:
IBM DB2 JDBC Universal Driver Architecture
The command that caused the problem:
select * from SCHEMA.TABLE where FIELD = '20021006123949311084000000'
Error Code: -99999
SQL State: null
Product: DbVisualizer Personal 188.8.131.52
Build: #1224 (2007/06/13 00:44)
Java VM: Java HotSpot(TM) Tiered VM
Java Version: 1.7.0-ea-b12
Java Vendor: Sun Microsystems Inc.
OS Name: Windows 2000
OS Arch: x86
OS Version: 5.0