onstat -g sql output - host variables section

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

What makes you sure that the application is not passing the variables in the wrong order? Regards. On Thu, Mar 4, 2010 at 5:20 PM, Tom <tlowrie@munis.com> wrote: > 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 > > > _______________________________________________ > Informix-list mailing list > Informix-list@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...

On 4 Mrz., 18:20, Tom <tlow...@munis.com> wrote: > 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 Hello Tom , we see the same problem with JDBC3.50JC5. In this case it is APAR IC65627. regards Manfred