Data grid - AS/400

I am using ADO OLE DB connection for getting connected to AS/400.  I hav Client accessV3R2M0 + SF57002service pack. I used datagrid (Ole db 6) basic VB control.  But I am not able to fill the columns of datagrid with Numeric fields in my DB2 database table. All Numeric fields appear as 0. Can anyone help me?  Also when i use "Select * from table" it is taking too much time but when I use "Select empcode,empname,bdate(i.e.all fields) the data retrieval is faster. Why?
vikkyvAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vikkyvAuthor Commented:
Edited text of question.
0
vbyuvalCommented:
As I remember you should pool the numbers as strings from the AS/400 and then convert them back to numbers on the PC .
About the SELECT command - it's allways take more time if you use the "*" you can see that if you have SQL analizer .

                                                            Enjoy
                                                        Yuval Amir

P.S.
-----
20 pts for this question - it's vere low !
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vikkyvAuthor Commented:
We have Query analyser.  When I run the same sql statement i.e. "Select * from.." on As/400 (interactive sql) data is retrieved very fast.  I experimented with the same table located on SQL server and I used the same grid The retrieval is very fast.  Thanks for the answer
0
vbyuvalCommented:
????????? DID U GAVE ME A *C* ??????????
HOW IS THAT ? YOU JUST SAY MY ANSWER IS
GOOD ????
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.