topic Re: Execute sql command on dbconnect in All Apps and Add-ons

Execute sql command on dbconnect

indeed_2000 — Tue, 11 Feb 2020 00:42:00 GMT

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;

Thanks

Re: Execute sql command on dbconnect

nickhills — Tue, 11 Feb 2020 12:34:56 GMT

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"

Re: Execute sql command on dbconnect

indeed_2000 — Tue, 11 Feb 2020 12:53:16 GMT

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

Re: Execute sql command on dbconnect

nickhills — Tue, 11 Feb 2020 13:01:02 GMT

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?

Re: Execute sql command on dbconnect

indeed_2000 — Tue, 11 Feb 2020 13:10:51 GMT

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?