Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading IBM DB2 tables from VFP
Message
From
29/09/2004 11:34:24
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00946961
Message ID:
00947216
Views:
11
You can use the ODBC driver for DB2 and then use SQL passthrought or remote views to get the data.
lnHandle = sqlconnect(your dsn name)
?sqlexec(lnHandle,"Select * from table","cursor_name")
>Using VFP 6.0 SP2. I want to read IBM DB2 data bases that reside on the Mainframe from within FoxPro. I have read the mainframe data bases in access, but it was awhile ago and I do not remember. Think I used IBM DB2 (or DB2 Connect) to establish the link on the PC and then linked to them from within Access. Is something similar available in FoxPro?
>
>Thanks
>
>Brenda
Previous
Reply
Map
View

Click here to load this message in the networking platform