[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

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?
0
vikkyv
Asked:
vikkyv
  • 2
  • 2
1 Solution
 
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
 
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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now