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
| USE RSA;
INSERT IGNORE INTO import (Id, DateImport) VALUES (1,20090809002310);
LOAD DATA LOCAL INFILE 'F:/Base_PMSI/rsa07sschain.sav/rsa07sschain.fixe'
INTO TABLE datRSAFixe Fields terminated by '\t' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
(Import_Id, Id, CodeFiness, NoFormatRSA, NoIndexRSA, NoVersFormatRSSLu, NoVersGenRSA, NoSeqTarif, VersClassifLu, CodeGHMLu, CodeRetGroupageLu, VersClassif, CodeGHM, CodeRetGroupage, NbreRum, AgeAn, AgeJour, Sexe, ModeEntree, Provenance, ModeSortie, Destination, MoisSortie, AnneeSortie, TypeSejour, Duree, DureeSeance, CodeGeo, Poids, AgeGest, NbreSeance, IGS2, NbreActeDialyse, GHS, DureeRea, NbreSupBorneHaute, SejInfBorneBasse, NbreActeRx, NbreActe24Z05Z, NbreActe24Z06Z, NbreActe24Z07Z, NbreActeGHS9510, NbreActeGHS9511, NbreActeGHS9512, NbreActeGHS9515, NbreActeGHS9524, ActePreltOrgane, NoRUMClassant, DP, DR, NbreDAS, NbreActe, TypePrelevementOrgane, NbreSupplREA, NbreSupplSI_ REA, NbreSupplSRA, NbreSupplSTF, NbreSupplSRC, NbreSupplSSC, NbreSupplNN1, NbreSupplNN2, NbreSupplNN3, NbreSupplReaPed, NbreSupplCaisson, NbreForfaitDialyse, NbreSupplHemodialyse, NbreSupplEntrainDialyseAuto, NbreSupplEntrainDialyseContinue, NbreSupplEntrainHemodialyse, NbreSeancesAvantSROS, LitDediePalliatif,TypeActe);
LOAD DATA LOCAL INFILE 'F:/Base_PMSI/rsa07sschain.sav/rsa07sschain.dg'
INTO TABLE datDiag Fields terminated by '\t' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
(RSAFixe_Id,Code,Type,PosDg);
LOAD DATA LOCAL INFILE 'F:/Base_PMSI/rsa07sschain.sav/rsa07sschain.cdam'
INTO TABLE datActeCDAM Fields terminated by '\t' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
(RSAFixe_Id,Code,Nb);
LOAD DATA LOCAL INFILE 'F:/Base_PMSI/rsa07sschain.sav/rsa07sschain.ccam'
INTO TABLE datActeCCAM Fields terminated by '\t' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
(RSAFixe_Id,NoActe,Code,Phase,Nb,Activite,ExtDocument,Modificateur,Association,RembExcept,Delai,NoRUM);
LOAD DATA LOCAL INFILE 'F:/Base_PMSI/rsa07sschain.sav/rsa07sschain.um'
INTO TABLE datUM Fields terminated by '\t' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
(RSAFixe_Id,NoRUM,TypeUM,DureeUM,PosDP,DPRUM,DRRUM,ValRea,TypeUMForce,RUMapres,ValPartiel);
/* Met à jour le nombre d'enregistrement importé */
UPDATE import SET NombreRSA = (SELECT COUNT(*) FROM datRSAFixe WHERE Import_Id=1) WHERE Id=1; |
Partager