onstat -g sql output - host variables section

[Tom]

Greetings,

I thought that the variables listed in the "Host variables" section
aligned with the fields given in the "Current SQL statement" section
located just before the "Host variables" output. But, as shown in this
example, this does not appear to be the case. I looked at the values
in the actual table and they do not match up.

Here is the onstat -g sql 113 output:

Current SQL statement :
select * from txchgdef where txchgdef.txch_mt_sw = ? and
txchgdef.txch_ar_cat = ? and txchgdef.txch_prop_id = ? and
txchgdef.txch_year = ? and txchgdef.txch_list_no = ? and
txchgdef.txch_chg_def = ?

Host variables :
address type flags
value I added this part
-----------------------------------------
0x0700000037d08038 SMINT 0x000 1 <--
txchgdef.txch_mt_sw <-- OK
0x0700000037d080c8 SMINT 0x000 20 <--
txchgdef.txch_ar_cat <-- OK
0x0700000037d08158 SMINT 0x000 2010 <--
txchgdef.txch_year <-- Out Of Order
0x0700000037d081e8 INT 0x000 2144 <--
txchgdef.txch_list_no <-- Out Of Order
0x0700000037d08278 CHAR 0x000 020600000089E <--
txchgdef.txch_prop_id <-- Out Of Order
0x0700000037d08308 CHAR 0x000 TAX <--
txchgdef.txch_chg_def <-- OK

And here is the relevant section from a dbaccess screen that shows the
actual values and which fields they belong to:

txch_mt_sw 1
txch_ar_cat 20
txch_prop_id 020600000089E
txch_year 2010
txch_list_no 2144
txch_chg_def TAX

[Fernando Nunes]

What makes you sure that the application is not passing the variables in the wrong order?
Regards.

_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list

--
Fernando Nunes
Portugal

http://informix-technology.blogspot.com
My email works... but I don't check it frequently...

[moppel]

Hello Tom ,

we see the same problem with JDBC3.50JC5.
In this case it is APAR IC65627.

regards
Manfred

[Tom]

> > Informix-l...@iiug.org

> >http://www.iiug.org/mailman/listinfo/informix-list
>
> --
> Fernando Nunes
> Portugal
>
> http://informix-technology.blogspot.com

> My email works... but I don't check it frequently...- Hide quoted text -
>
> - Show quoted text -

Fernando called it. I contacted the folks who wrote the program and
they changed the order of the variables during a recent update. They
are fixing that now.

Thanks Fernando - again.

Tom