 | |
onstat -g sql output - host variables section
comp.databases.informix comp.databases.informix
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
onstat -g sql output - host variables section -
03-04-2010
, 11:20 AM
#2
| |||
| |||
|
|
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 (AT) iiug (DOT) 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...
#3
| |||
| |||
|
|
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 |
we see the same problem with JDBC3.50JC5.
In this case it is APAR IC65627.
regards
Manfred
#4
| |||
| |||
|
|
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 <tlow... (AT) munis (DOT) 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-l... (AT) iiug (DOT) 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 - |
they changed the order of the variables during a recent update. They
are fixing that now.
Thanks Fernando - again.
Tom
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.