Re: vb6/ADO 2.8/ DB2

OldVaxGuy wrote:
I need to clarify: the actual data returned is 98,99,100,101 but in

Forgive me, but this statement is still ambiguous. Do you mean "the actual
data that should be returned is ... "? Or do you mean that this is the data
you see in your recordset while debugging, indicating that this is a problem
with the way you are writing it to the textbox/whatever? Looking at the rest
of this paragraph, it is safe to assume the former interpretation, but
wonder why it is so hard to say "My database table in DB2 contains these
numbers in a numeric field: 98,99,100,101. When I retrieve them via a simple
sql statement, the recordset field contains 98,99,1,101 (confirmed via
debug.print during a loop). Why are those trailing zeroes in the 100 being
dropped?"

The answer probably lies in some obscure setting in whatever ODBC driver or
OLE DB provider you are using to connect to the database. Again, I have no
experience with DB2 (other than AS400 servers with which I have never
encountered this issue) so will be unable to provide specifics. Hopefully,
one of the other guys here will. If you get no help here, try one of the vb
groups (avoid the .Net groups: those groups all have the word "dotnet"
somewhere in their names), or look for a DB2 forum somewhere, I'm sure they
exist. In fact, IBM has a knowledge base containing lots of white papers and
redbooks about using the AS400 on their website. I'm sure similar must exist
for DB2.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages