RE: onstat -g ses output

Tom. Before the mentioned section you will see the query with some question marks "?". Each line stands for one question mark. They represent the content of the variables of your query in the same order. HTH. Reinhard > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org]On Behalf Of Tom > Sent: Tuesday, January 19, 2010 2:25 PM > 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:53 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Tom. > > Before the mentioned section you will see the query with some question marks > "?". Each line stands for one question mark. They represent the content of > the variables of your query in the same order. > > HTH. > Reinhard > > > > > -----Original Message----- > > From: informix-list-boun...@iiug.org > > [mailto:informix-list-boun...@iiug.org]On Behalf Of Tom > > Sent: Tuesday, January 19, 2010 2:25 PM > > To: informix-l...@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-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list- Hide quoted text - > > - Show quoted text - Many thanks for the excellent responses to this question. One response explained (as does the response from Reinhard): The section you refer to is about the arguments passed on the query in execution. For example, above the "Host variables" section there is a "Current SQL statement" section, something like select * from a, b, c where a.x = ? and b.y = ? and c.? Each ? in the sql statement refers to the host variables, in the specific order they are listed. Tom