All Apps and Add-ons

Splunk DB Connect 2: How to fetch and read XML data from BLOB and datetime from timestamp fields in DB2 on Z/OS?

srinathd
Contributor

I am connecting to DB2 database on Z/OS using Splunk DB Connect 2. However, DB Connect is not fetching timestamp and xml fields properly. It is showing values as "## NOT SUPPORTED TYPE ##". How do I get the timestamp and xml fields properly?

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

to some degree this is JDBC driver dependent... Splunk does text, not binary, so we need to get a text representation. That should be fine for XML and datetime, but if the driver is passing us binary representation, we can't eat it. To fix this, you can modify your SQL query to CAST or CONVERT the columns to VARCHAR or INT.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...