All Apps and Add-ons

Execute sql command on dbconnect

indeed_2000
Motivator

Hi
I have queries that does not run on db connect, but it will be run on informix server and return result.
What is the reason?

select * from syscolumns;
select * from systables a, systables b;
update t1 set rowsize = rowsize +100;

alt text

alt text

Thanks

0 Karma

nickhills
Ultra Champion

It looks like the user you have configured in DB Connect does not have permission to access that table.
From the left side navigation, your DBX user can only see the table "flags_text"

If my comment helps, please give it a thumbs up!
0 Karma

indeed_2000
Motivator

User have full access and table list continue when i scroll down, it’s not in screenshot.

0 Karma

nickhills
Ultra Champion

ah! 🙂

I don't know anything about informix, is t1 a table you see in that list, or is it some kind of alias?
In any case, Splunk is saying that it can't see it, have you tried running that query against the server with the DBX user?

If my comment helps, please give it a thumbs up!
0 Karma

indeed_2000
Motivator

I’m wondering how can I write simple sql command to join two table in splunk.

For e.g. when I run below query give me syntax error.
SELECT * FROM "sysmaster":"sysadtinfo". "sysbufpool"

sysmaster: database name
sysadtinfo: table1
sysbufpool: table2

Is this right syntax?

0 Karma
Get Updates on the Splunk Community!

Celebrating Fast Lane: 2025 Authorized Learning Partner of the Year

At .conf25, Splunk proudly recognized Fast Lane as the 2025 Authorized Learning Partner of the Year. This ...

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...