onstat -g ses output

Greetings, Can someone define or point me to a document that defines all of the output from the onstat -g ses session_id command? Specifically, I am interested in knbowing what this output section means: Host variables : address type flags value ----------------------------------------- 0x07000000ef156a98 SMINT 0x000 2005 0x07000000ef156b28 INT 0x000 11278 0x07000000ef156bb8 SMINT 0x000 1 0x07000000ef156c48 CHAR 0x000 N Thanks, Tom

http://www.oninit.com/onstat/index.php?page=./onstatidx.php&type=1&id=gses -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Tom Sent: Tuesday, January 19, 2010 7:25 AM To: informix-list@iiug.org Subject: onstat -g ses output Greetings, Can someone define or point me to a document that defines all of the output from the onstat -g ses session_id command? Specifically, I am interested in knbowing what this output section means: Host variables : address type flags value ----------------------------------------- 0x07000000ef156a98 SMINT 0x000 2005 0x07000000ef156b28 INT 0x000 11278 0x07000000ef156bb8 SMINT 0x000 1 0x07000000ef156c48 CHAR 0x000 N Thanks, Tom _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

On Jan 19, 8:24 am, Tom <tlow...@munis.com> wrote: > Greetings, > > Can someone define or point me to a document that defines all of the > output from the onstat -g ses session_id command? Specifically, I am > interested in knbowing what this output section means: > > Host variables : >    address            type       flags value >    ----------------------------------------- >    0x07000000ef156a98 SMINT      0x000 2005 >    0x07000000ef156b28 INT        0x000 11278 >    0x07000000ef156bb8 SMINT      0x000 1 >    0x07000000ef156c48 CHAR       0x000 N > > Thanks, > > Tom Nice site - but the page shown looks just like the page I have in the Online IDS Admin Reference manual, which does not show any of the "Host variables" as shown in the original post. Thanks for the response though, I just added that site to my favorites. Tom

It means that the current SQL statement had replaceable parameters and these were the values passed to the four parameters the last time it was executed or a cursor opened against it. There was a smallint value 2005, an int value 11278, a smallint value 1, and a char(1) value "N". The first column is the address in IDS's memory where the data block for each parameter is located and the flags indicate specifics of the value needed to interpret certain data types. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jan 19, 2010 at 8:24 AM, Tom <tlowrie@munis.com> wrote: > Greetings, > > Can someone define or point me to a document that defines all of the > output from the onstat -g ses session_id command? Specifically, I am > interested in knbowing what this output section means: > > Host variables : > address type flags value > ----------------------------------------- > 0x07000000ef156a98 SMINT 0x000 2005 > 0x07000000ef156b28 INT 0x000 11278 > 0x07000000ef156bb8 SMINT 0x000 1 > 0x07000000ef156c48 CHAR 0x000 N > > Thanks, > > Tom > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >