1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
ODBC CONNECT TO [xxx] (XUserId is QXCWWYNOFbYeGTJOYC, XPassword is YUfMZQRNJTeKWSZE);
//Table 1
VenteA:
SQL SELECT "ANNEE_FACTURE",
ARTICLE,
"CLIENT_FACTURATION",
"JOUR_FACTURE",
"MOIS_FACTURE",
"MONTANT_HORS_TAXE_DEV_REF",
"NOM_COURT_CLIENT_FAC",
"NUMERO_BON",
"NUMERO_COMMANDE",
"NUMERO_COMPTEUR_FACTURE",
"NUMERO_DE_FACTURE",
PAYS,
"QTE_FACTUREE",
"REF_ARTICLE",
REFART,
"TYPE_DE_FACTURE"
FROM DB2.KNSP01.COVENTE;
//Table 2
VenteB:
SQL SELECT "ANNEE_FACTURE",
ARTICLE,
"CLIENT_FACTURATION",
"JOUR_FACTURE",
"MOIS_FACTURE",
"MONTANT_HORS_TAXE_DEV_REF",
"NOM_COURT_CLIENT_FAC",
"NUMERO_BON",
"NUMERO_COMMANDE",
"NUMERO_COMPTEUR_FACTURE",
"NUMERO_DE_FACTURE",
PAYS,
"QTE_FACTUREE",
"REF_ARTICLE",
REFART,
"TYPE_DE_FACTURE"
FROM DB2.KNSP02.COVENTE; |
Partager