Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reading IBM DB2 tables from VFP
Message
De
29/09/2004 11:34:24
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00946961
Message ID:
00947216
Vues:
10
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform