Forum

Kognitio Console issues, advice, etc.
Contributor
Offline
Posts: 184
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Kog Scripts: how do I see the resultset?

by MikeAtkinson » Tue Jul 16, 2013 8:28 am

I'm running the KogScript utility with a simple script. When I perform a query I don't see any results.
Reply with quote Top
Contributor
Offline
Posts: 184
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Re: Kog Scripts: how do I see the resultset?

by MikeAtkinson » Wed Jul 17, 2013 4:10 pm

use the sqldebug variable.

Code: Select all

> select * from ipe_user;
> sqldebug = 1;
> select * from ipe_user;
OK

> sqldebug = 2;
> select * from ipe_user;
OK

Execute time: 0:00.3
First row time: 0:00.3
All rows time: 0:00.3

> sqldebug = 3;
> select * from ipe_user;
OK

Execute time: 0:00.1
First row time: 0:00.1
All rows time: 0:00.1

NAME    ID      DFLT_SCNO       SEC_CLASS       SCH_CLASS       STATUS  PTIME
SYS     0       0       0       0       0       2013-07-17 10:44:03
GRP_LOG 3       0       0       0       8       2013-07-17 10:44:46
MIKE    6       2       0       0       0       2013-07-17 10:49:55
GRP_MONITOR     1       0       0       0       8       2013-07-17 10:44:45
GRP_DISKUSAGE   4       0       0       0       8       2013-07-17 10:44:46
GRP_DBG 2       0       0       0       8       2013-07-17 10:44:46
ODBC    5       1       0       0       1       2013-07-17 10:45:15
PUBLIC  -1      0       0       0       8       2013-07-17 10:44:03
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron