Hello everybody,
I've some strange problems with two records into a
table on a DB2 v5.2.0.30 ( Aix 4.2.1 ).
On the Risc/6000, if I do a select on the two records, I get :
db2 "select num_dos, score from abibu.ublxxxat where num_dos in (119210 ,
121980 )"
NUM_DOS SCORE
------------- -----
119210,
SQL0804N The application program input parameters for the
current request are not valid. Reason code
"<reason-code>". If a host variable or SQLVAR in
the SQLDA is invalid then: host variable/SQLVAR
number = "<var-number>", SQLTYPE = "<sqltype>",
SQLLEN = "<sqllen>", host variable/SQLVAR type =
"<input_or_output>" SQLSTATE=07002.
db2 "select num_dos, hex(score) from abibu.ublxxxat where num_dos in
(119210 , 121980 )"
NUM_DOS 2
------------- ----
119210, 0D2C
121980, 0D2C
2 enregistrement(s) s�lectionn�(s).
We have a db2 connection from Os/390 to this Risc/6000, and
the same query using QMF results :
SELECT NUM_DOS, SCORE, HEX(SCORE) , HEX(DECIMAL(20 , 3 , 0))
FROM ABIBU.UBLXXXAT
WHERE NUM_DOS IN (119210 , 121980)
NUM
DOS SCORE 3 4
-------------- ------ ---- ----
119210 20 0D2C 020C
121980 20 0D2C 020C
The value 0D2C is not corresponding to a decimal paqued.
What's wrong ?
How could the values got in there ?
And, why QMF can retreive the data and db2 on Aix can't ?
Is it a CodePage problems ?
Thanks a million for reply.
Best Regards.
JOss.
oO�OoO�OoO�OoO�OoO�Oo
Jocelyn GIZOLME
SDDC-PSR
Tel : 7-4989
oO�OoO�OoO�OoO�OoO�Oo
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
