//SOLER21J JOB 'CREATION BASE',MSGCLASS=X,CLASS=C, // RESTART=*, // MSGLEVEL=(1,1),NOTIFY=&SYSUID //*-------------------------------------------------------------------* //* CREATION DE LA BASE DE DONNEES : * //* * //* 1 STOGROUP SGS21 * //* 2 DATABASE DBS21 * //* * //* 3 TABLESPACE SEGMENTE TSS21 * //* 4 TABLES + LABELS + INDEX * //*-------------------------------------------------------------------* //CREATE EXEC PGM=IKJEFT01,DYNAMNBR=20 //STEPLIB DD DSN=DB2.RUNLIB.LOAD,DISP=SHR //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM (DSN1) RUN PROGRAM(DSNTEP2) PLAN(DSNTEP41) PARMS('/ALIGN(LHS)') END //SYSIN DD * ------------------------------------------------------------------------ -- 1 CREATION DU STOGROUP -- ------------------------------------------------------------------------ CREATE STOGROUP SGS21 VOLUMES (DISK04) VCAT SOLER21 ; ------------------------------------------------------------------------ -- 2 CREATION DE LA DATABASE -- ------------------------------------------------------------------------ CREATE DATABASE DBS21 STOGROUP SGS21 ; ------------------------------------------------------------------------ -- 3 CREATION DU TABLESPACE SEGMENTE -- ------------------------------------------------------------------------ CREATE TABLESPACE TSS21 IN DBS21 USING STOGROUP SGS21 PRIQTY 40 SECQTY 20 SEGSIZE 32 ; ------------------------------------------------------------------------00060000 -- CREATION DE LA TABLE CLIENT --00070000 ------------------------------------------------------------------------00080000 CREATE TABLE TCLIENT0 00090000 ( 00100000 CDNUMCLI CHAR (006) NOT NULL , 00110000 LBNOMCLI CHAR (033) NOT NULL , 00120000 CDPTTCLI CHAR (005) , 00130000 LBVILCLI CHAR (025) , 00140000 CDNUMDEP CHAR (002) , 00150000 PCREMCLI SMALLINT , 00160000 IDCRECLI CHAR (008) NOT NULL , 00170000 DTCRECLI DATE NOT NULL WITH DEFAULT, 00180000 HHCRECLI TIME NOT NULL WITH DEFAULT, 00190000 IDMODCLI CHAR (008) NOT NULL , 00200000 DTMODCLI DATE NOT NULL WITH DEFAULT, 00210000 HHMODCLI TIME NOT NULL WITH DEFAULT, 00220000 LBRUECLI VARCHAR (033) 00230000 ) 00240000 IN DBS21.TSS21 00250004 ; 00260000 ------------------------------------------------------------------------00270000 -- DOCUMENTATION DE LA TABLE CLIENT --00280000 ------------------------------------------------------------------------00290000 LABEL ON TABLE TCLIENT0 00300000 IS 'CLIENT ' 00310000 ; 00320000 LABEL ON TCLIENT0 00330000 ( 00340000 CDNUMCLI IS 'NUMERO CLIENT ', 00350000 LBNOMCLI IS 'NOM CLIENT OU RAISON SOCIALE ', 00360000 CDPTTCLI IS 'CODE POSTAL LOCALITE ', 00370000 LBVILCLI IS 'VILLE ', 00380000 CDNUMDEP IS 'DEPARTEMENT GEOGRAPHIQUE ', 00390000 PCREMCLI IS '% REMISE ACCORDEE ', 00400000 IDCRECLI IS 'USER CREATION ', 00410000 DTCRECLI IS 'DATE CREATION ', 00420000 HHCRECLI IS 'HEURE CREATION ', 00430000 IDMODCLI IS 'USER MODIFICATION ', 00440000 DTMODCLI IS 'DATE MODIFICATION ', 00450000 HHMODCLI IS 'HEURE MODIFICATION ', 00460000 LBRUECLI IS 'ADRESSE NO & NOM RUE ' 00470000 ) 00480000 ; 00490000 ------------------------------------------------------------------------00500000 -- VALIDATION DES MISES A JOUR --00510000 ------------------------------------------------------------------------00520000 COMMIT 00530000 ; 00540000 ------------------------------------------------------------------------00550000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE CLIENT --00560000 ------------------------------------------------------------------------00570000 CREATE UNIQUE INDEX XCLIENT0 00580000 ON TCLIENT0 00590000 ( 00600000 CDNUMCLI ASC 00610000 ) 00620000 ; 00630000 ------------------------------------------------------------------------00690000 -- CREATION DE LA TABLE FOURNISSEUR --00700000 ------------------------------------------------------------------------00710000 CREATE TABLE TFOURNI0 00720000 ( 00730000 CDNUMFOU CHAR (006) NOT NULL , 00740000 LBNOMFOU CHAR (033) NOT NULL , 00750000 CDPTTFOU CHAR (005) , 00760000 LBVILFOU CHAR (025) , 00770000 CDNUMDEP CHAR (002) , 00780000 IDCREFOU CHAR (008) NOT NULL , 00790000 DTCREFOU DATE NOT NULL WITH DEFAULT, 00800000 HHCREFOU TIME NOT NULL WITH DEFAULT, 00810000 IDMODFOU CHAR (008) NOT NULL , 00820000 DTMODFOU DATE NOT NULL WITH DEFAULT, 00830000 HHMODFOU TIME NOT NULL WITH DEFAULT, 00840000 LBRUEFOU VARCHAR (033) 00850000 ) 00860000 IN DBS21.TSS21 00870004 ; 00880000 ------------------------------------------------------------------------00890000 -- DOCUMENTATION DE LA TABLE FOURNISSEUR --00900000 ------------------------------------------------------------------------00910000 LABEL ON TABLE TFOURNI0 00920000 IS 'FOURNISSEUR ' 00930000 ; 00940000 LABEL ON TFOURNI0 00950000 ( 00960000 CDNUMFOU IS 'NUMERO FOURNISSEUR ', 00970000 LBNOMFOU IS 'NOM OU RAISON SOCIALE ', 00980000 CDPTTFOU IS 'CODE POSTAL LOCALITE ', 00990000 LBVILFOU IS 'VILLE ', 01000000 CDNUMDEP IS 'DEPARTEMENT GEOGRAPHIQUE ', 01010000 IDCREFOU IS 'USER CREATION ', 01020000 DTCREFOU IS 'DATE CREATION ', 01030000 HHCREFOU IS 'HEURE CREATION ', 01040000 IDMODFOU IS 'USER MODIFICATION ', 01050000 DTMODFOU IS 'DATE MODIFICATION ', 01060000 HHMODFOU IS 'HEURE MODIFICATION ', 01070000 LBRUEFOU IS 'ADRESSE NO & NOM RUE ' 01080000 ) 01090000 ; 01100000 ------------------------------------------------------------------------01110000 -- VALIDATION DES MISES A JOUR --01120000 ------------------------------------------------------------------------01130000 COMMIT 01140000 ; 01150000 ------------------------------------------------------------------------01160000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE FOURNISSEUR --01170000 ------------------------------------------------------------------------01180000 CREATE UNIQUE INDEX XFOURNI0 01190000 ON TFOURNI0 01200000 ( 01210000 CDNUMFOU ASC 01220000 ) 01230000 ; 01240000 ------------------------------------------------------------------------01300000 -- CREATION DE LA TABLE ARTICLE/FOURNISSEUR --01310000 ------------------------------------------------------------------------01320000 CREATE TABLE TARTFOU0 01330000 ( 01340000 CDNUMART CHAR (006) NOT NULL , 01350000 CDNUMFOU CHAR (006) NOT NULL , 01360000 MTACHART DECIMAL (008, 002) , 01370000 IDCREARF CHAR (008) NOT NULL , 01380000 DTCREARF DATE NOT NULL WITH DEFAULT, 01390000 HHCREARF TIME NOT NULL WITH DEFAULT, 01400000 IDMODARF CHAR (008) NOT NULL , 01410000 DTMODARF DATE NOT NULL WITH DEFAULT, 01420000 HHMODARF TIME NOT NULL WITH DEFAULT 01430000 ) 01440000 IN DBS21.TSS21 01450004 ; 01460000 ------------------------------------------------------------------------01470000 -- DOCUMENTATION DE LA TABLE ARTICLE/FOURNISSEUR --01480000 ------------------------------------------------------------------------01490000 LABEL ON TABLE TARTFOU0 01500000 IS 'ARTICLE/FOURNISSEUR ' 01510000 ; 01520000 LABEL ON TARTFOU0 01530000 ( 01540000 CDNUMART IS 'NUMERO ARTICLE ', 01550000 CDNUMFOU IS 'NUMERO FOURNISSEUR ', 01560000 MTACHART IS 'PRIX ACHAT ARTICLE ', 01570000 IDCREARF IS 'USER CREATION ', 01580000 DTCREARF IS 'DATE CREATION ', 01590000 HHCREARF IS 'HEURE CREATION ', 01600000 IDMODARF IS 'USER MODIFICATION ', 01610000 DTMODARF IS 'DATE MODIFICATION ', 01620000 HHMODARF IS 'HEURE MODIFICATION ' 01630000 ) 01640000 ; 01650000 ------------------------------------------------------------------------01660000 -- VALIDATION DES MISES A JOUR --01670000 ------------------------------------------------------------------------01680000 COMMIT 01690000 ; 01700000 ------------------------------------------------------------------------01710000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE ARTICLE/FOURNISSEUR --01720000 ------------------------------------------------------------------------01730000 CREATE UNIQUE INDEX XARTFOU0 01740000 ON TARTFOU0 01750000 ( 01760000 CDNUMART ASC, 01770000 CDNUMFOU ASC 01780000 ) 01790000 ; 01800000 ------------------------------------------------------------------------01860000 -- CREATION DE LA TABLE ARTICLE --01870000 ------------------------------------------------------------------------01880000 CREATE TABLE TARTICL0 01890000 ( 01900000 CDNUMART CHAR (006) NOT NULL , 01910000 LBNOMART CHAR (033) NOT NULL , 01920000 PCTVAART DECIMAL (004, 002) , 01930000 QTSTKART SMALLINT , 01940000 QTRELART SMALLINT , 01950000 MTVTEART DECIMAL (008, 002) , 01960000 QTPDSART DECIMAL (005, 002) , 01970000 CDNUMFOU CHAR (006) , 01980000 IDCREART CHAR (008) NOT NULL , 01990000 DTCREART DATE NOT NULL WITH DEFAULT, 02000000 HHCREART TIME NOT NULL WITH DEFAULT, 02010000 IDMODART CHAR (008) NOT NULL , 02020000 DTMODART DATE NOT NULL WITH DEFAULT, 02030000 HHMODART TIME NOT NULL WITH DEFAULT 02040000 ) 02050000 IN DBS21.TSS21 02060004 ; 02070000 ------------------------------------------------------------------------02080000 -- DOCUMENTATION DE LA TABLE ARTICLE --02090000 ------------------------------------------------------------------------02100000 LABEL ON TABLE TARTICL0 02110000 IS 'ARTICLE' 02120000 ; 02130000 LABEL ON TARTICL0 02140000 ( 02150000 CDNUMART IS 'NUMERO ARTICLE ', 02160000 LBNOMART IS 'LIBELLE ARTICLE ', 02170000 PCTVAART IS 'TAUX DE TVA ', 02180000 QTSTKART IS 'QUANTITE STOCK ', 02190000 QTRELART IS 'QUANTITE RELANCE ', 02200000 MTVTEART IS 'PRIX UNITAIRE ', 02210000 QTPDSART IS 'POIDS ', 02220000 CDNUMFOU IS 'NUMERO FOURNISSEUR ', 02230000 IDCREART IS 'USER CREATION ', 02240000 DTCREART IS 'DATE CREATION ', 02250000 HHCREART IS 'HEURE CREATION ', 02260000 IDMODART IS 'USER MODIFICATION ', 02270000 DTMODART IS 'DATE MODIFICATION ', 02280000 HHMODART IS 'HEURE MODIFICATION ' 02290000 ) 02300000 ; 02310000 ------------------------------------------------------------------------02320000 -- VALIDATION DES MISES A JOUR --02330000 ------------------------------------------------------------------------02340000 COMMIT 02350000 ; 02360000 ------------------------------------------------------------------------02370006 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE ARTICLE --02380000 ------------------------------------------------------------------------02390000 CREATE UNIQUE INDEX XARTICL0 02400000 ON TARTICL0 02410000 ( 02420000 CDNUMART ASC 02430000 ) 02440000 ; 02450000 ------------------------------------------------------------------------02510000 -- CREATION DE LA TABLE COMMANDE --02520000 ------------------------------------------------------------------------02530000 CREATE TABLE TCOMMAN0 02540000 ( 02550000 CDNUMCOM CHAR (006) NOT NULL , 02560000 DTETACOM DATE NOT NULL , 02570000 DTLIVCOM DATE , 02580000 CDNUMCLI CHAR (006) NOT NULL , 02590000 CDNUMFAC CHAR (006) , 02600000 CDCOMORI CHAR (006) , 02610000 IDCRECOM CHAR (008) NOT NULL , 02620000 DTCRECOM DATE NOT NULL WITH DEFAULT, 02630000 HHCRECOM TIME NOT NULL WITH DEFAULT, 02640000 IDMODCOM CHAR (008) NOT NULL , 02650000 DTMODCOM DATE NOT NULL WITH DEFAULT, 02660000 HHMODCOM TIME NOT NULL WITH DEFAULT 02670000 ) 02680000 IN DBS21.TSS21 02690004 ; 02700000 ------------------------------------------------------------------------02710000 -- DOCUMENTATION DE LA TABLE COMMANDE --02720000 ------------------------------------------------------------------------02730000 LABEL ON TABLE TCOMMAN0 02740000 IS 'COMMANDE' 02750000 ; 02760000 LABEL ON TCOMMAN0 02770000 ( 02780000 CDNUMCOM IS 'NUMERO COMMANDE ', 02790000 DTETACOM IS 'DATE COMMANDE ', 02800000 DTLIVCOM IS 'DATE LIVRAISON ', 02810000 CDNUMCLI IS 'NUMERO CLIENT ', 02820000 CDNUMFAC IS 'NUMERO FACTURE ', 02830000 CDCOMORI IS 'NUMERO COMMANDE ORIGINE ', 02840000 IDCRECOM IS 'USER CREATION ', 02850000 DTCRECOM IS 'DATE CREATION ', 02860000 HHCRECOM IS 'HEURE CREATION ', 02870000 IDMODCOM IS 'USER MODIFICATION ', 02880000 DTMODCOM IS 'DATE MODIFICATION ', 02890000 HHMODCOM IS 'HEURE MODIFICATION ' 02900000 ) 02910000 ; 02920000 ------------------------------------------------------------------------02930000 -- VALIDATION DES MISES A JOUR --02940000 ------------------------------------------------------------------------02950000 COMMIT 02960000 ; 02970000 ------------------------------------------------------------------------02980000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE COMMANDE --02990000 ------------------------------------------------------------------------03000000 CREATE UNIQUE INDEX XCOMMAN0 03010000 ON TCOMMAN0 03020000 ( 03030000 CDNUMCOM ASC 03040000 ) 03050000 ; 03060000 ------------------------------------------------------------------------03120000 -- CREATION DE LA TABLE LIGNE COMMANDE --03130000 ------------------------------------------------------------------------03140000 CREATE TABLE TLIGCOM0 03150000 ( 03160000 CDNUMCOM CHAR (006) NOT NULL , 03170000 CDNUMLCO CHAR (002) NOT NULL , 03180000 CDNUMART CHAR (006) NOT NULL , 03190000 QTCOMART DECIMAL (004, 000) NOT NULL , 03200000 PCREMLCO SMALLINT NOT NULL , 03210000 IDCRELCO CHAR (008) NOT NULL , 03220000 DTCRELCO DATE NOT NULL WITH DEFAULT, 03230000 HHCRELCO TIME NOT NULL WITH DEFAULT, 03240000 IDMODLCO CHAR (008) NOT NULL , 03250000 DTMODLCO DATE NOT NULL WITH DEFAULT, 03260000 HHMODLCO TIME NOT NULL WITH DEFAULT 03270000 ) 03280000 IN DBS21.TSS21 03290004 ; 03300000 ------------------------------------------------------------------------03310000 -- DOCUMENTATION DE LA TABLE LIGNE COMMANDE --03320000 ------------------------------------------------------------------------03330000 LABEL ON TABLE TLIGCOM0 03340000 IS 'LIGNE COMMANDE' 03350000 ; 03360000 LABEL ON TLIGCOM0 03370000 ( 03380000 CDNUMCOM IS 'NUMERO COMMANDE ', 03390000 CDNUMLCO IS 'NUMERO LIGNE COMMANDE ', 03400000 CDNUMART IS 'NUMERO ARTICLE ', 03410000 QTCOMART IS 'QUANTITE COMMANDE ', 03420000 PCREMLCO IS '% REMISE LIGNE ', 03430000 IDCRELCO IS 'USER CREATION ', 03440000 DTCRELCO IS 'DATE CREATION ', 03450000 HHCRELCO IS 'HEURE CREATION ', 03460000 IDMODLCO IS 'USER MODIFICATION ', 03470000 DTMODLCO IS 'DATE MODIFICATION ', 03480000 HHMODLCO IS 'HEURE MODIFICATION ' 03490000 ) 03500000 ; 03510000 ------------------------------------------------------------------------03520000 -- VALIDATION DES MISES A JOUR --03530000 ------------------------------------------------------------------------03540000 COMMIT 03550000 ; 03560000 ------------------------------------------------------------------------03570000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE LIGNE COMMANDE --03580000 ------------------------------------------------------------------------03590000 CREATE UNIQUE INDEX XLIGCOM0 03600000 ON TLIGCOM0 03610000 ( 03620000 CDNUMCOM ASC, 03630000 CDNUMLCO ASC 03640000 ) 03650000 ; 03660000 ------------------------------------------------------------------------03720000 -- CREATION DE LA TABLE FACTURE --03730000 ------------------------------------------------------------------------03740000 CREATE TABLE TFACTUR0 03750000 ( 03760000 CDNUMFAC CHAR (006) NOT NULL , 03770000 DTETAFAC DATE NOT NULL , 03780000 CDNUMCLI CHAR (006) NOT NULL , 03790000 CDNUMCOM CHAR (006) NOT NULL , 03800000 MTHTXFAC DECIMAL (008, 002) NOT NULL , 03810000 PCREMCLI SMALLINT NOT NULL , 03820000 MTREMFAC DECIMAL (007, 002) NOT NULL , 03830000 MTTVAFAC DECIMAL (007, 002) NOT NULL , 03840000 MTTTCFAC DECIMAL (008, 002) NOT NULL , 03850000 IDCREFAC CHAR (008) NOT NULL , 03860000 DTCREFAC DATE NOT NULL WITH DEFAULT, 03870000 HHCREFAC TIME NOT NULL WITH DEFAULT 03880000 ) 03890000 IN DBS21.TSS21 03900004 ; 03910000 ------------------------------------------------------------------------03920000 -- DOCUMENTATION DE LA TABLE FACTURE --03930000 ------------------------------------------------------------------------03940000 LABEL ON TABLE TFACTUR0 03950000 IS 'FACTURE' 03960000 ; 03970000 LABEL ON TFACTUR0 03980000 ( 03990000 CDNUMFAC IS 'NUMERO FACTURE ', 04000000 DTETAFAC IS 'DATE FACTURE ', 04010000 CDNUMCLI IS 'NUMERO CLIENT ', 04020000 CDNUMCOM IS 'NUMERO COMMANDE ', 04030000 MTHTXFAC IS 'MONTANT HORS TAXES ', 04040000 PCREMCLI IS '% REMISE CLIENT ', 04050000 MTREMFAC IS 'MONTANT REMISE ', 04060000 MTTVAFAC IS 'MONTANT TVA ', 04070000 MTTTCFAC IS 'MONTANT TTC ', 04080000 IDCREFAC IS 'USER CREATION ', 04090000 DTCREFAC IS 'DATE CREATION ', 04100000 HHCREFAC IS 'HEURE CREATION ' 04110000 ) 04120000 ; 04130000 ------------------------------------------------------------------------04140000 -- VALIDATION DES MISES A JOUR --04150000 ------------------------------------------------------------------------04160000 COMMIT 04170000 ; 04180000 ------------------------------------------------------------------------04190000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE FACTURE --04200000 ------------------------------------------------------------------------04210000 CREATE UNIQUE INDEX XFACTUR0 04220000 ON TFACTUR0 04230000 ( 04240000 CDNUMFAC ASC 04250000 ) 04260000 ; 04270000 ------------------------------------------------------------------------04330000 -- CREATION DE LA TABLE LIGNE FACTURE --04340000 ------------------------------------------------------------------------04350000 CREATE TABLE TLIGFAC0 04360000 ( 04370000 CDNUMFAC CHAR (006) NOT NULL , 04380000 CDNUMLCO CHAR (002) NOT NULL , 04390000 CDNUMART CHAR (006) NOT NULL , 04400000 QTCOMART DECIMAL (004, 000) NOT NULL , 04410000 MTVTEART DECIMAL (007, 002) NOT NULL , 04420000 PCREMLCO SMALLINT NOT NULL , 04430000 MTREMLFA DECIMAL (007, 002) NOT NULL , 04440000 PCTVAART DECIMAL (004, 002) NOT NULL , 04450000 MTHTXLFA DECIMAL (008, 002) NOT NULL , 04460000 MTTVALFA DECIMAL (007, 002) NOT NULL , 04470000 MTTTCLFA DECIMAL (008, 002) NOT NULL , 04480000 IDCRELFA CHAR (008) NOT NULL , 04490000 DTCRELFA DATE NOT NULL WITH DEFAULT, 04500000 HHCRELFA TIME NOT NULL WITH DEFAULT 04510000 ) 04520000 IN DBS21.TSS21 04530004 ; 04540000 ------------------------------------------------------------------------04550000 -- DOCUMENTATION DE LA TABLE LIGNE FACTURE --04560000 ------------------------------------------------------------------------04570000 LABEL ON TABLE TLIGFAC0 04580000 IS 'LIGNE FACTURE' 04590000 ; 04600000 LABEL ON TLIGFAC0 04610000 ( 04620000 CDNUMFAC IS 'NUMERO FACTURE ', 04630000 CDNUMLCO IS 'NUMERO LIGNE COMMANDE ', 04640000 CDNUMART IS 'NUMERO ARTICLE ', 04650000 QTCOMART IS 'QUANTITE LIGNE COMMANDE ', 04660000 MTVTEART IS 'PRIX UNITAIRE ARTICLE ', 04670000 PCREMLCO IS '% REMISE LIGNE COMMANDE ', 04680000 MTREMLFA IS 'MONTANT REMISE LIGNE FACTURE ', 04690000 PCTVAART IS 'TAUX DE TVA ARTICLE ', 04700000 MTHTXLFA IS 'MONTANT HORS TAXES LIGNE ', 04710000 MTTVALFA IS 'MONTANT TVA LIGNE ', 04720000 MTTTCLFA IS 'MONTANT TTC LIGNE ', 04730000 IDCRELFA IS 'USER CREATION ', 04740000 DTCRELFA IS 'DATE CREATION ', 04750000 HHCRELFA IS 'HEURE CREATION ' 04760000 ) 04770000 ; 04780000 ------------------------------------------------------------------------04790000 -- VALIDATION DES MISES A JOUR --04800000 ------------------------------------------------------------------------04810000 COMMIT 04820000 ; 04830000 ------------------------------------------------------------------------04840000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE LIGNE FACTURE --04850000 ------------------------------------------------------------------------04860000 CREATE UNIQUE INDEX XLIGFAC0 04870000 ON TLIGFAC0 04880000 ( 04890000 CDNUMFAC ASC, 04900000 CDNUMLCO ASC 04910000 ) 04920000 ; 04930000 ------------------------------------------------------------------------04990000 -- CREATION DE LA TABLE DEPARTEMENT --05000000 ------------------------------------------------------------------------05010000 CREATE TABLE TDEPART0 05020000 ( 05030000 CDNUMDEP CHAR (002) NOT NULL, 05040000 LBNOMDEP CHAR (023) NOT NULL, 05050000 CDNUMREG CHAR (002) NOT NULL 05060000 ) 05070000 IN DBS21.TSS21 05080000 ; 05090000 ------------------------------------------------------------------------05100000 -- DOCUMENTATION DE LA TABLE DEPARTEMENT --05110000 ------------------------------------------------------------------------05120000 LABEL ON TABLE TDEPART0 05130000 IS 'DEPARTEMENT GEOGRAPHIQUE ' 05140000 ; 05150000 LABEL ON TDEPART0 05160000 ( 05170000 CDNUMDEP IS 'NUMERO DEPARTEMENT ', 05180000 LBNOMDEP IS 'LIBELLE DEPARTEMENT ', 05190000 CDNUMREG IS 'NUMERO REGION ' 05200000 ) 05210000 ; 05220000 ------------------------------------------------------------------------05280000 -- CREATION DE LA TABLE REGION --05290000 ------------------------------------------------------------------------05300000 CREATE TABLE TREGION0 05310000 ( 05320000 CDNUMREG CHAR (002) NOT NULL, 05330000 LBNOMREG CHAR (026) NOT NULL 05340000 ) 05350000 IN DBS21.TSS21 05360004 ; 05370000 ------------------------------------------------------------------------05380000 -- DOCUMENTATION DE LA TABLE REGION --05390000 ------------------------------------------------------------------------05400000 LABEL ON TABLE TREGION0 05410000 IS 'REGION GEOGRAPHIQUE ' 05420000 ; 05430000 LABEL ON TREGION0 05440000 ( 05450000 CDNUMREG IS 'NUMERO REGION ', 05460000 LBNOMREG IS 'LIBELLE REGION ' 05470000 ) 05480000 ; 05490000 ------------------------------------------------------------------------05550000 -- CREATION DE LA TABLE PARAMETRES GENERAUX --05560000 ------------------------------------------------------------------------05570000 CREATE TABLE TPARGEN0 05580000 ( 05590000 CDTYPPAR CHAR (005) NOT NULL , 05600000 LBPARGEN CHAR (012) NOT NULL , 05610000 QTPARGEN DECIMAL (015, 000) NOT NULL , 05620000 LBDONPAR CHAR (050) NOT NULL 05630000 ) 05640000 IN DBS21.TSS21 05650004 ; 05660000 ------------------------------------------------------------------------05670000 -- DOCUMENTATION DE LA TABLE PARAMETRES GENERAUX --05680000 ------------------------------------------------------------------------05690000 LABEL ON TABLE TPARGEN0 05700000 IS 'PARAMETRES GENERAUX' 05710000 ; 05720000 05730000 LABEL ON TPARGEN0 05740000 ( 05750000 CDTYPPAR IS 'TYPE PARAMETRE ', 05760000 LBPARGEN IS 'LIBELLE PARAMETRE ', 05770000 QTPARGEN IS 'QUANTITE PARAMETRE ', 05780000 LBDONPAR IS 'DONNEES PARAMETRES ' 05790000 ) 05800000 ; 05810000 ------------------------------------------------------------------------05820000 -- VALIDATION DES MISES A JOUR --05830000 ------------------------------------------------------------------------05840000 COMMIT 05850000 ; 05860000 ------------------------------------------------------------------------05870000 -- CREATION DE L'INDEX PRIMAIRE SUR LA TABLE PARAMETRES --05880000 ------------------------------------------------------------------------05890000 CREATE UNIQUE INDEX XPARGEN0 05900000 ON TPARGEN0 05910000 ( 05920000 CDTYPPAR ASC , 05930000 LBPARGEN ASC , 05940000 QTPARGEN ASC 05950000 ) 05960000 ; 05970000 //*-------------------------------------------------------------------* //* CHARGEMENT DE LA BASE DE DONNEES * //*-------------------------------------------------------------------* //INSERT EXEC PGM=IKJEFT01,DYNAMNBR=20 //STEPLIB DD DSN=DB2.RUNLIB.LOAD,DISP=SHR //SYSTSPRT DD SYSOUT=* //SYSPRINT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM (DSN1) RUN PROGRAM(DSNTEP2) PLAN(DSNTEP41) PARMS('/ALIGN(LHS)') END //SYSIN DD * INSERT INTO TCLIENT0 VALUES ( '100001', 'AAZ INFORMATIQUE ', '75017', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '72, RUE DE SAUSSURE ' ); INSERT INTO TCLIENT0 VALUES ( '100002', 'ACSI ', '75012', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '228, RUE DU FG ST ANTOINE ' ); INSERT INTO TCLIENT0 VALUES ( '100003', 'AFA COMPUTER ', '75017', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '8, RUE DES ACACIAS ' ); INSERT INTO TCLIENT0 VALUES ( '100004', 'AGI ', '68100', 'MULHOUSE ', '68', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '2, PLACE DU GENERAL DE GAULLE ' ); INSERT INTO TCLIENT0 VALUES ( '100010', 'AGINFOR ', '75011', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '127, RUE AMELOT ' ); INSERT INTO TCLIENT0 VALUES ( '100011', 'ARDENNE INFORMATIQUE ', '08105', 'CHARLEVILLE-MEZIERES ', '08', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '101, COURS A.BRIAND BP 301 ' ); INSERT INTO TCLIENT0 VALUES ( '100012', 'BRETAGNE INFORMATIQUE ', '44000', 'NANTES ', '44', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '5, AV DE L''HOTEL DIEU ' ); INSERT INTO TCLIENT0 VALUES ( '100020', 'BUMECA ', '94210', 'ST MAUR LA VARENNE ', '94', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '61, BD DES CORNEILLES ' ); INSERT INTO TCLIENT0 VALUES ( '100021', 'CAMEX ', '75008', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '1, RUE DU GAL FOY ' ); INSERT INTO TCLIENT0 VALUES ( '100022', 'CCE SAISIE MONDE ', '75008', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '14, RUE LINCOLN ' ); INSERT INTO TCLIENT0 VALUES ( '100025', 'CIAG ', '08300', 'RETHEL ', '08', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', '1 A 9, RUE PAUL DOUMER ' ); INSERT INTO TCLIENT0 VALUES ( '100030', 'CORSE INFORMATIQUE SERVICE ', '20000', 'AJACCIO ', '20', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', 'CHEMIN BIANCARELLO, IM LE CITISEZ' ); INSERT INTO TCLIENT0 VALUES ( '100037', 'DUFOUR ET IGON INFORMATIQUE ', '31025', 'TOULOUSE ', '31', NULL, 'LOAD ', '2003-06-19', '15:33:46', 'LOAD ', '2003-06-19', '15:33:46', 'RUE DE L''OASIS BP 3056 ' ); INSERT INTO TCLIENT0 VALUES ( '100038', 'ENCODGEST ', '95560', 'MONTSOULT ', '95', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '10, ALLEE MARIE LOUISE ' ); INSERT INTO TCLIENT0 VALUES ( '100059', 'EURO-DATA ', '57603', 'FORBACH ', '57', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', 'ZICARREFOUR DE L''EUROPE BP 180 ' ); INSERT INTO TCLIENT0 VALUES ( '100060', 'FIGOS ', '75008', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '14, RUE LINCOLN ' ); INSERT INTO TCLIENT0 VALUES ( '100061', 'GAMMA GESTION ', '69100', 'VILLEURBANNE ', '69', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '79, RUE RACINE ' ); INSERT INTO TCLIENT0 VALUES ( '100062', 'IMPRIMERIE CLAUDE CHAMBRE ', '57050', 'METZ ', '57', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '3, RUE DREYFUS DUPONT ZI NORD ' ); INSERT INTO TCLIENT0 VALUES ( '100063', 'LOGIX ', '78150', 'ROCQUENCOURT ', '78', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '8, LE PARC DE ROQUENCOURT ' ); INSERT INTO TCLIENT0 VALUES ( '100064', 'MCI ', '31320', 'CASTANET TOLOSAN ', '31', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', 'CHEMIN FALCOU MERVILLE ' ); INSERT INTO TCLIENT0 VALUES ( '100065', 'MIKRO-RAMA ', '31400', 'TOULOUSE ', '31', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '55, AV LOUIS BREGUET ' ); INSERT INTO TCLIENT0 VALUES ( '100066', 'OGIP ', '59505', 'DOUAI ', '59', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '64, RUE DES MINIMES BP 513 ' ); INSERT INTO TCLIENT0 VALUES ( '100080', 'TELEMATIQUE FRANCE ', '75015', 'PARIS ', '75', NULL, 'LOAD ', '2003-06-19', '15:33:48', 'LOAD ', '2003-06-19', '15:33:48', '28, RUE ROSENWALD ' ); INSERT INTO TFOURNI0 VALUES ( '401001', 'AMDHAL ', '75017', 'PARIS ', '75', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '251, BD PEREIRE ' ); INSERT INTO TFOURNI0 VALUES ( '402002', 'AMERICAN COMPUTERS AND ENGINEERS ', '75009', 'PARIS ', '75', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '6, RUE ROCHAMBEAU ' ); INSERT INTO TFOURNI0 VALUES ( '402003', 'ARMS SA ', '75017', 'PARIS ', '75', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '79, AV. DE VILLIERS ' ); INSERT INTO TFOURNI0 VALUES ( '402004', 'BASF (CIE FRANCAISE) ', '92303', 'LEVALLOIS PERRET ', '92', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '140, RUE J. GUESDE BP 87 ' ); INSERT INTO TFOURNI0 VALUES ( '402005', 'BSV INFORMATIQUE ', '13560', 'SENAS ', '13', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', 'ROUTE DE SALON ' ); INSERT INTO TFOURNI0 VALUES ( '404006', 'BULL (DIVISION OEM) ', '78340', 'LES CLAYES SOUS BOIS ', '78', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', 'RUE JEAN JAURES ' ); INSERT INTO TFOURNI0 VALUES ( '404007', 'BULL (DIVISION SUPPORTS D''INFOR.)', '75980', 'PARIS ', '75', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '61-63, RUE D''AVRON ' ); INSERT INTO TFOURNI0 VALUES ( '404008', 'BURROUGHS ', '95015', 'CERGY PONTOISE ', '95', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', 'IM. BURROUGS, BD DE L''OISE ' ); INSERT INTO TFOURNI0 VALUES ( '603009', 'CONTROL DATA FRANCE ', '77000', 'LOGNES ', '77', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '27, COURS DES PETITES ECURIES ' ); INSERT INTO TFOURNI0 VALUES ( '703010', 'DATA GENERAL FRANCE ', '92357', 'LE PLESSIS ROBINSON ', '92', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', 'LA BOURSIDIERE IM L ' ); INSERT INTO TFOURNI0 VALUES ( '603011', 'DIGITAL EQUIPMENT FRANCE ', '91004', 'EVRY ', '91', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '2, RUE GASTON CREMIEUX BP 136 ' ); INSERT INTO TFOURNI0 VALUES ( '603012', 'GOULD INFORMATIQUE SA ', '78390', 'BOIS D''ARCY ', '78', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', 'P.A. BOIS D''ARCY RUE FARADAY ' ); INSERT INTO TFOURNI0 VALUES ( '603013', 'HARRYS ', '78150', 'LE CHESNAY ', '78', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '6, AV.CHARLES DE GAULLE ' ); INSERT INTO TFOURNI0 VALUES ( '603014', 'HEWLETT PACKARD FRANCE ', '91040', 'EVRY ', '91', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', 'PA BOIS BRIARD AV. DU LAC ' ); INSERT INTO TFOURNI0 VALUES ( '603015', 'IBM PARIS ', '75001', 'PARIS ', '75', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '3, PLACE VENDOME ' ); INSERT INTO TFOURNI0 VALUES ( '600016', 'ICL FRANCE ', '75008', 'PARIS ', '75', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '16, COURS ALBERT 1ER ' ); INSERT INTO TFOURNI0 VALUES ( '600017', 'INTERSYS CONCEPT ', '94227', 'CHARENTON LE PONT ', '94', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '72, QUAI DES CARRIERES ' ); INSERT INTO TFOURNI0 VALUES ( '500018', 'LOGABAX (STE NOUVELLE) ', '92130', 'ISSY LES MOULINEAUX ', '92', 'LOAD ', '2003-06-19', '15:37:09', 'LOAD ', '2003-06-19', '15:37:09', '27, BD GAMBETTA ' ); INSERT INTO TARTFOU0 VALUES ( '900100', '401001', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900101', '401001', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900102', '401001', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900103', '401001', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900104', '402002', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900105', '402003', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900106', '402003', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900107', '402004', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900108', '402004', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800200', '402004', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900109', '402005', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900110', '402005', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900111', '402005', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900112', '404006', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900113', '404007', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800201', '404007', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800202', '404008', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800203', '404008', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800204', '603009', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700001', '703010', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700002', '703010', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700003', '703010', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700004', '603011', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700005', '603011', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700006', '603012', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700007', '603012', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700008', '603012', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700020', '603013', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '700030', '603014', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900025', '603015', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900026', '603015', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900030', '603015', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900031', '603016', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900032', '603016', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900033', '603016', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '900034', '603017', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800101', '500018', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800135', '500018', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800136', '500018', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTFOU0 VALUES ( '800140', '500018', NULL, 'LOAD ', '2003-06-19', '15:39:07', 'LOAD ', '2003-06-19', '15:39:07' ); INSERT INTO TARTICL0 VALUES ( '900100', 'L 8530/002 8086 ', 18.60, NULL, NULL, 11008.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900101', 'L 8530/021 8086 ', 18.60, NULL, NULL, 14950.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900102', 'L 8530/H31 80286 ', 18.60, NULL, NULL, 22255.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900103', 'L 8550/061 80286 ', 18.60, NULL, NULL, 27997.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900104', 'L 8555/X31 80386 SX ', 18.60, NULL, NULL, 30336.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900105', 'L 8555/X61 80386 SX ', 18.60, NULL, NULL, 33330.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900106', 'L 8565/051 80386 SX ', 18.60, NULL, NULL, 38400.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900107', 'L 8570/M61 80386 ', 18.60, NULL, NULL, 48893.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900108', 'L 8570/121 80386 ', 18.60, NULL, NULL, 55820.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900109', 'L 8570/A21 80386 ', 18.60, NULL, NULL, 75188.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900110', 'L 8580/071 80386 ', 18.60, NULL, NULL, 49602.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900111', 'L 8580/111 80386 ', 18.60, NULL, NULL, 66211.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900112', 'L 8580/A31 80386 ', 18.60, NULL, NULL, 90543.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900113', 'L 8573/K21 PORTABLE ', 18.60, NULL, NULL, 62398.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800200', 'CLAVIER AZERTY PS/2 ', 18.60, NULL, NULL, 2109.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800201', 'CLAVIER SUP. PORTABLE ', 18.60, NULL, NULL, 2109.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800202', 'L 8503 - 12" MONO ', 18.60, NULL, NULL, 2245.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800203', 'L 8512 - 14" COULEUR ', 18.60, NULL, NULL, 5242.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800204', 'L 8514 - 16" COULEUR ', 18.60, NULL, NULL, 13474.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700001', '4019-001 LASER 10 P/M ', 18.60, NULL, NULL, 20667.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700002', '4019-001 ALIMENTATION ENVELOPPES ', 18.60, NULL, NULL, 2266.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700003', '4019-001 CARTOUCHE DE CARACTERES ', 18.60, NULL, NULL, 1359.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700004', '5202 THERM. 132 COL 273 CPS ', 18.60, NULL, NULL, 11576.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700005', '5202 FEUILLE A FEUILLE 1 TIROIR ', 18.60, NULL, NULL, 2721.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700006', '5202 FEUILLE A FEUILLE 2 TIROIRS ', 18.60, NULL, NULL, 6293.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700007', '5202 ALIMENTATION ENVELOPPES ', 18.60, NULL, NULL, 2214.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700008', '5202 ALIMENTATION PAPIER CONTINU ', 18.60, NULL, NULL, 686.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700020', '4201-003 9 AIG 80 COL 270 CPS ', 18.60, NULL, NULL, 4912.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '700030', '4202-003 9 AIG 132 COL 270 CPS ', 18.60, NULL, NULL, 6398.00, NULL, '603015', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900025', 'MICRAL 200/CPU 1311 ', 18.60, NULL, NULL, 16160.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900026', 'MICRAL 200/CPU 1312 ', 18.60, NULL, NULL, 19324.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900030', 'MICRAL 400/CPU 1320 ', 18.60, NULL, NULL, 28629.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900031', 'MICRAL 500/CPU 1332 ', 18.60, NULL, NULL, 51108.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900032', 'MICRAL 600/CPU 1969 ', 18.60, NULL, NULL, 55684.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900033', 'MICRAL 600/CPU 1975 ', 18.60, NULL, NULL, 51748.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '900034', 'MICRAL 600/CPU 1976 ', 18.60, NULL, NULL, 66360.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800101', 'CLAVIER AZERTY 102 TOUCHES ', 18.60, NULL, NULL, 1230.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800135', 'ECRAN VGA MONO 14" ', 18.60, NULL, NULL, 1799.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800136', 'ECRAN VGA COULEUR 14" ', 18.60, NULL, NULL, 5500.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TARTICL0 VALUES ( '800140', 'CARTE ECRAN VGA COULEUR/M600 ', 18.60, NULL, NULL, 3300.00, NULL, '404006', 'LOAD ', '2003-06-19', '15:37:49', 'LOAD ', '2003-06-19', '15:37:49' ); INSERT INTO TCOMMAN0 VALUES ( '000001', '1990-09-28', NULL, '100001', NULL, NULL, 'LOAD ', '2003-06-19', '15:43:11', 'LOAD ', '2003-06-19', '15:43:11' ); INSERT INTO TCOMMAN0 VALUES ( '000002', '1990-09-28', NULL, '100002', NULL, NULL, 'LOAD ', '2003-06-19', '15:43:11', 'LOAD ', '2003-06-19', '15:43:11' ); INSERT INTO TCOMMAN0 VALUES ( '000003', '1990-09-28', NULL, '100003', NULL, NULL, 'LOAD ', '2003-06-19', '15:43:11', 'LOAD ', '2003-06-19', '15:43:11' ); INSERT INTO TCOMMAN0 VALUES ( '000004', '1990-09-28', NULL, '100010', NULL, NULL, 'LOAD ', '2003-06-19', '15:43:11', 'LOAD ', '2003-06-19', '15:43:11' ); INSERT INTO TCOMMAN0 VALUES ( '000005', '1990-09-28', NULL, '100011', NULL, NULL, 'LOAD ', '2003-06-19', '15:43:11', 'LOAD ', '2003-06-19', '15:43:11' ); INSERT INTO TLIGCOM0 VALUES ( '000001', '01', '900100', 4, 1, 'LOAD ', '2003-06-19', '15:44:25', 'LOAD ', '2003-06-19', '15:44:25' ); INSERT INTO TLIGCOM0 VALUES ( '000001', '02', '900101', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000001', '03', '900102', 3, 2, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000002', '01', '900100', 4, 1, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000002', '02', '900101', 3, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000002', '03', '900102', 3, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000003', '01', '900100', 4, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000003', '02', '900101', 3, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000003', '03', '900102', 3, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000003', '04', '800200', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000004', '01', '800200', 11, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '01', '700001', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '02', '700002', 3, 1, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '03', '700003', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '04', '700004', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '05', '700005', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '06', '700006', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '07', '700007', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TLIGCOM0 VALUES ( '000005', '08', '700008', 1, 0, 'LOAD ', '2003-06-19', '15:44:26', 'LOAD ', '2003-06-19', '15:44:26' ); INSERT INTO TREGION0 VALUES ( '01', 'ALSACE ' ); INSERT INTO TREGION0 VALUES ( '02', 'AQUITAINE ' ); INSERT INTO TREGION0 VALUES ( '03', 'AUVERGNE ' ); INSERT INTO TREGION0 VALUES ( '04', 'BASSE NORMANDIE ' ); INSERT INTO TREGION0 VALUES ( '05', 'BOURGOGNE ' ); INSERT INTO TREGION0 VALUES ( '06', 'BRETAGNE ' ); INSERT INTO TREGION0 VALUES ( '07', 'CENTRE ' ); INSERT INTO TREGION0 VALUES ( '08', 'CHAMPAGNE ARDENNE ' ); INSERT INTO TREGION0 VALUES ( '09', 'CORSE ' ); INSERT INTO TREGION0 VALUES ( '10', 'FRANCHE COMTE ' ); INSERT INTO TREGION0 VALUES ( '11', 'HAUTE NORMANDIE ' ); INSERT INTO TREGION0 VALUES ( '12', 'LANGUEDOC ROUSSILLON ' ); INSERT INTO TREGION0 VALUES ( '13', 'LIMOUSIN ' ); INSERT INTO TREGION0 VALUES ( '14', 'LORRAINE ' ); INSERT INTO TREGION0 VALUES ( '15', 'MIDI PYRENEES ' ); INSERT INTO TREGION0 VALUES ( '16', 'NORD PAS DE CALAIS ' ); INSERT INTO TREGION0 VALUES ( '17', 'PAYS DE LOIRE ' ); INSERT INTO TREGION0 VALUES ( '18', 'PICARDIE ' ); INSERT INTO TREGION0 VALUES ( '19', 'POITOU CHARENTES ' ); INSERT INTO TREGION0 VALUES ( '20', 'PROVENCE ALPES COTE D''AZUR' ); INSERT INTO TREGION0 VALUES ( '21', 'ILE DE FRANCE ' ); INSERT INTO TREGION0 VALUES ( '22', 'RHONE ALPES ' ); INSERT INTO TDEPART0 VALUES ( '67', 'BAS RHIN ', '01' ); INSERT INTO TDEPART0 VALUES ( '68', 'HAUT RHIN ', '01' ); INSERT INTO TDEPART0 VALUES ( '24', 'DORDOGNE ', '02' ); INSERT INTO TDEPART0 VALUES ( '33', 'GIRONDE ', '02' ); INSERT INTO TDEPART0 VALUES ( '40', 'LANDES ', '02' ); INSERT INTO TDEPART0 VALUES ( '47', 'LOT ET GARONNE ', '02' ); INSERT INTO TDEPART0 VALUES ( '64', 'PYRENEES ATLANTIQUES ', '02' ); INSERT INTO TDEPART0 VALUES ( '03', 'ALLIER ', '03' ); INSERT INTO TDEPART0 VALUES ( '15', 'CANTAL ', '03' ); INSERT INTO TDEPART0 VALUES ( '43', 'HAUTE LOIRE ', '03' ); INSERT INTO TDEPART0 VALUES ( '63', 'PUY DE DOME ', '03' ); INSERT INTO TDEPART0 VALUES ( '14', 'CALVADOS ', '04' ); INSERT INTO TDEPART0 VALUES ( '50', 'MANCHE ', '04' ); INSERT INTO TDEPART0 VALUES ( '61', 'ORNE ', '04' ); INSERT INTO TDEPART0 VALUES ( '21', 'COTE D''OR ', '05' ); INSERT INTO TDEPART0 VALUES ( '58', 'NIEVRE ', '05' ); INSERT INTO TDEPART0 VALUES ( '71', 'SAONE ET LOIRE ', '05' ); INSERT INTO TDEPART0 VALUES ( '89', 'YONNE ', '05' ); INSERT INTO TDEPART0 VALUES ( '22', 'COTES DU NORD ', '06' ); INSERT INTO TDEPART0 VALUES ( '29', 'FINISTERE ', '06' ); INSERT INTO TDEPART0 VALUES ( '35', 'ILLE ET VILAINE ', '06' ); INSERT INTO TDEPART0 VALUES ( '56', 'MORBIHAN ', '06' ); INSERT INTO TDEPART0 VALUES ( '18', 'CHER ', '07' ); INSERT INTO TDEPART0 VALUES ( '28', 'EURE ET LOIRE ', '07' ); INSERT INTO TDEPART0 VALUES ( '36', 'INDRE ', '07' ); INSERT INTO TDEPART0 VALUES ( '37', 'INDRE ET LOIRE ', '07' ); INSERT INTO TDEPART0 VALUES ( '41', 'LOIR ET CHER ', '07' ); INSERT INTO TDEPART0 VALUES ( '45', 'LOIRET ', '07' ); INSERT INTO TDEPART0 VALUES ( '08', 'ARDENNES ', '08' ); INSERT INTO TDEPART0 VALUES ( '10', 'AUBE ', '08' ); INSERT INTO TDEPART0 VALUES ( '51', 'MARNE ', '08' ); INSERT INTO TDEPART0 VALUES ( '52', 'HAUTE MARNE ', '08' ); INSERT INTO TDEPART0 VALUES ( '2A', 'CORSE SUD ', '09' ); INSERT INTO TDEPART0 VALUES ( '2B', 'HAUTE CORSE ', '09' ); INSERT INTO TDEPART0 VALUES ( '25', 'DOUBS ', '10' ); INSERT INTO TDEPART0 VALUES ( '39', 'JURA ', '10' ); INSERT INTO TDEPART0 VALUES ( '70', 'HAUTE SAONE ', '10' ); INSERT INTO TDEPART0 VALUES ( '90', 'TERRITOIRE DE BELFORT ', '10' ); INSERT INTO TDEPART0 VALUES ( '27', 'EURE ', '11' ); INSERT INTO TDEPART0 VALUES ( '76', 'SEINE MARITIME ', '11' ); INSERT INTO TDEPART0 VALUES ( '11', 'AUDE ', '12' ); INSERT INTO TDEPART0 VALUES ( '30', 'GARD ', '12' ); INSERT INTO TDEPART0 VALUES ( '34', 'HERAULT ', '12' ); INSERT INTO TDEPART0 VALUES ( '48', 'LOZERE ', '12' ); INSERT INTO TDEPART0 VALUES ( '66', 'PYRENEES ORIENTALES ', '12' ); INSERT INTO TDEPART0 VALUES ( '19', 'CORREZE ', '13' ); INSERT INTO TDEPART0 VALUES ( '23', 'CREUSE ', '13' ); INSERT INTO TDEPART0 VALUES ( '87', 'HAUTE VIENNE ', '13' ); INSERT INTO TDEPART0 VALUES ( '54', 'MEURTHE ET MOSELLE ', '14' ); INSERT INTO TDEPART0 VALUES ( '55', 'MEUSE ', '14' ); INSERT INTO TDEPART0 VALUES ( '57', 'MOSELLE ', '14' ); INSERT INTO TDEPART0 VALUES ( '88', 'VOSGES ', '14' ); INSERT INTO TDEPART0 VALUES ( '09', 'ARIEGE ', '15' ); INSERT INTO TDEPART0 VALUES ( '12', 'AVEYRON ', '15' ); INSERT INTO TDEPART0 VALUES ( '31', 'HAUTE GARONNE ', '15' ); INSERT INTO TDEPART0 VALUES ( '32', 'GERS ', '15' ); INSERT INTO TDEPART0 VALUES ( '46', 'LOT ', '15' ); INSERT INTO TDEPART0 VALUES ( '65', 'HAUTES PYRENNEES ', '15' ); INSERT INTO TDEPART0 VALUES ( '81', 'TARN ', '15' ); INSERT INTO TDEPART0 VALUES ( '82', 'TARN ET GARONNE ', '15' ); INSERT INTO TDEPART0 VALUES ( '59', 'NORD ', '16' ); INSERT INTO TDEPART0 VALUES ( '62', 'PAS DE CALAIS ', '16' ); INSERT INTO TDEPART0 VALUES ( '44', 'LOIRE ATLANTIQUE ', '17' ); INSERT INTO TDEPART0 VALUES ( '49', 'MAINE ET LOIRE ', '17' ); INSERT INTO TDEPART0 VALUES ( '53', 'MAYENNE ', '17' ); INSERT INTO TDEPART0 VALUES ( '72', 'SARTHE ', '17' ); INSERT INTO TDEPART0 VALUES ( '85', 'VENDEE ', '17' ); INSERT INTO TDEPART0 VALUES ( '02', 'AISNE ', '18' ); INSERT INTO TDEPART0 VALUES ( '60', 'OISE ', '18' ); INSERT INTO TDEPART0 VALUES ( '80', 'SOMME ', '18' ); INSERT INTO TDEPART0 VALUES ( '16', 'CHARENTE ', '19' ); INSERT INTO TDEPART0 VALUES ( '17', 'CHARENTE MARITIME ', '19' ); INSERT INTO TDEPART0 VALUES ( '79', 'DEUX SEVRES ', '19' ); INSERT INTO TDEPART0 VALUES ( '86', 'VIENNE ', '19' ); INSERT INTO TDEPART0 VALUES ( '04', 'ALPES DE HAUTE PROVENCE', '20' ); INSERT INTO TDEPART0 VALUES ( '05', 'HAUTES ALPES ', '20' ); INSERT INTO TDEPART0 VALUES ( '06', 'ALPES MARITIMES ', '20' ); INSERT INTO TDEPART0 VALUES ( '13', 'BOUCHES DU RHONE ', '20' ); INSERT INTO TDEPART0 VALUES ( '83', 'VAR ', '20' ); INSERT INTO TDEPART0 VALUES ( '84', 'VAUCLUSE ', '20' ); INSERT INTO TDEPART0 VALUES ( '75', 'VILLE DE PARIS ', '21' ); INSERT INTO TDEPART0 VALUES ( '77', 'SEINE ET MARNE ', '21' ); INSERT INTO TDEPART0 VALUES ( '78', 'YVELINES ', '21' ); INSERT INTO TDEPART0 VALUES ( '91', 'ESSONE ', '21' ); INSERT INTO TDEPART0 VALUES ( '92', 'HAUTS DE SEINE ', '21' ); INSERT INTO TDEPART0 VALUES ( '93', 'SEINE SAINT DENIS ', '21' ); INSERT INTO TDEPART0 VALUES ( '94', 'VAL DE MARNE ', '21' ); INSERT INTO TDEPART0 VALUES ( '95', 'VAL D''OISE ', '21' ); INSERT INTO TDEPART0 VALUES ( '01', 'AIN ', '22' ); INSERT INTO TDEPART0 VALUES ( '07', 'ARDECHE ', '22' ); INSERT INTO TDEPART0 VALUES ( '26', 'DROME ', '22' ); INSERT INTO TDEPART0 VALUES ( '38', 'ISERE ', '22' ); INSERT INTO TDEPART0 VALUES ( '42', 'LOIRE ', '22' ); INSERT INTO TDEPART0 VALUES ( '69', 'RHONE ', '22' ); INSERT INTO TDEPART0 VALUES ( '73', 'SAVOIE ', '22' ); INSERT INTO TDEPART0 VALUES ( '74', 'HAUTE SAVOIE ', '22' ); //SOLER21J JOB 'DB2TP01G',MSGCLASS=X,CLASS=C, 00010000 // RESTART=*, 00020000 // TIME=(0,6), 00021003 // MSGLEVEL=(1,1),NOTIFY=&SYSUID 00030000 //CREATE EXEC PGM=IKJEFT01,DYNAMNBR=20 00040000 //STEPLIB DD DSN=DB2.RUNLIB.LOAD,DISP=SHR 00050000 // DD DSN=SOLERI.FORM.LOADBATC,DISP=SHR 00050201 // DD DSN=SYS1.SCEERUN,DISP=SHR 00050301 //SYSTSPRT DD SYSOUT=* 00060000 //SYSPRINT DD SYSOUT=* 00070000 //SYSTSIN DD * 00080000 DSN SYSTEM (DSN1) 00090000 RUN PROGRAM(DB2TP01G) PLAN(DB2TP01G) 00100000 END 00110000 //SYSOUT DD SYSOUT=* 00120000 //OUT001 DD SYSOUT=* 00130000 // 00140000