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!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...