@prefix rr: <http://www.w3.org/ns/r2rml#> .
@prefix db2: <http://demo.openlinksw.com/schemas/db2/> .
@prefix db2-stat: <http://demo.openlinksw.com/db2/stat#> .
@prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
@prefix void: <http://rdfs.org/ns/void#> .
@prefix scovo: <http://purl.org/NET/scovo#> .
@prefix aowl: <http://bblfish.net/work/atom-owl/2006-06-06/> .


<#TriplesMapCL_SCHED> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "CL_SCHED" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/cl_sched/CLASS_CODE={CLASS_CODE}/DAY={DAY}/STARTING={STARTING}/ENDING={ENDING}"; rr:class db2:CL_SCHED; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:class_code ] ; rr:objectMap [ rr:column "CLASS_CODE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:day ] ; rr:objectMap [ rr:column "DAY" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:starting ] ; rr:objectMap [ rr:column "STARTING" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:ending ] ; rr:objectMap [ rr:column "ENDING" ]; ] .

<#TriplesMapDEPARTMENT> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "DEPARTMENT" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/department/DEPTNO={DEPTNO}/DEPTNAME={DEPTNAME}/MGRNO={MGRNO}/ADMRDEPT={ADMRDEPT}/LOCATION={LOCATION}"; rr:class db2:DEPARTMENT; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:deptno ] ; rr:objectMap [ rr:column "DEPTNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:deptname ] ; rr:objectMap [ rr:column "DEPTNAME" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:mgrno ] ; rr:objectMap [ rr:column "MGRNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:admrdept ] ; rr:objectMap [ rr:column "ADMRDEPT" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:location ] ; rr:objectMap [ rr:column "LOCATION" ]; ] .

<#TriplesMapEMPLOYEE> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "EMPLOYEE" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/employee/EMPNO={EMPNO}"; rr:class db2:EMPLOYEE; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:empno ] ; rr:objectMap [ rr:column "EMPNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:firstnme ] ; rr:objectMap [ rr:column "FIRSTNME" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:midinit ] ; rr:objectMap [ rr:column "MIDINIT" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:lastname ] ; rr:objectMap [ rr:column "LASTNAME" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:workdept ] ; rr:objectMap [ rr:column "WORKDEPT" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:phoneno ] ; rr:objectMap [ rr:column "PHONENO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:hiredate ] ; rr:objectMap [ rr:column "HIREDATE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:job ] ; rr:objectMap [ rr:column "JOB" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:edlevel ] ; rr:objectMap [ rr:column "EDLEVEL" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:sex ] ; rr:objectMap [ rr:column "SEX" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:birthdate ] ; rr:objectMap [ rr:column "BIRTHDATE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:salary ] ; rr:objectMap [ rr:column "SALARY" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:bonus ] ; rr:objectMap [ rr:column "BONUS" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:comm ] ; rr:objectMap [ rr:column "COMM" ]; ] .

<#TriplesMapEMP_ACT> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "EMP_ACT" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/emp_act/EMPNO={EMPNO}/PROJNO={PROJNO}/ACTNO={ACTNO}/EMPTIME={EMPTIME}/EMSTDATE={EMSTDATE}/EMENDATE={EMENDATE}"; rr:class db2:EMP_ACT; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:empno ] ; rr:objectMap [ rr:column "EMPNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:projno ] ; rr:objectMap [ rr:column "PROJNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:actno ] ; rr:objectMap [ rr:column "ACTNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:emptime ] ; rr:objectMap [ rr:column "EMPTIME" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:emstdate ] ; rr:objectMap [ rr:column "EMSTDATE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:emendate ] ; rr:objectMap [ rr:column "EMENDATE" ]; ] .

<#TriplesMapEMP_PHOTO> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "EMP_PHOTO" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/emp_photo/EMPNO={EMPNO}/PHOTO_FORMAT={PHOTO_FORMAT}"; rr:class db2:EMP_PHOTO; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:empno ] ; rr:objectMap [ rr:column "EMPNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:photo_format ] ; rr:objectMap [ rr:column "PHOTO_FORMAT" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:picture ] ; rr:objectMap [ rr:column "PICTURE" ]; ] .

<#TriplesMapEMP_RESUME> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "EMP_RESUME" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/emp_resume/EMPNO={EMPNO}/RESUME_FORMAT={RESUME_FORMAT}"; rr:class db2:EMP_RESUME; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:empno ] ; rr:objectMap [ rr:column "EMPNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:resume_format ] ; rr:objectMap [ rr:column "RESUME_FORMAT" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:resume ] ; rr:objectMap [ rr:column "RESUME" ]; ] .

<#TriplesMapIN_TRAY> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "IN_TRAY" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/in_tray/RECEIVED={RECEIVED}/SOURCE={SOURCE}/SUBJECT={SUBJECT}/NOTE_TEXT={NOTE_TEXT}"; rr:class db2:IN_TRAY; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:received ] ; rr:objectMap [ rr:column "RECEIVED" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:source ] ; rr:objectMap [ rr:column "SOURCE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:subject ] ; rr:objectMap [ rr:column "SUBJECT" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:note_text ] ; rr:objectMap [ rr:column "NOTE_TEXT" ]; ] .

<#TriplesMapORG> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "ORG" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/org/DEPTNUMB={DEPTNUMB}/DEPTNAME={DEPTNAME}/MANAGER={MANAGER}/DIVISION={DIVISION}/LOCATION={LOCATION}"; rr:class db2:ORG; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:deptnumb ] ; rr:objectMap [ rr:column "DEPTNUMB" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:deptname ] ; rr:objectMap [ rr:column "DEPTNAME" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:manager ] ; rr:objectMap [ rr:column "MANAGER" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:division ] ; rr:objectMap [ rr:column "DIVISION" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:location ] ; rr:objectMap [ rr:column "LOCATION" ]; ] .

<#TriplesMapPROJECT> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "PROJECT" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/project/PROJNO={PROJNO}/PROJNAME={PROJNAME}/DEPTNO={DEPTNO}/RESPEMP={RESPEMP}/PRSTAFF={PRSTAFF}/PRSTDATE={PRSTDATE}/PRENDATE={PRENDATE}/MAJPROJ={MAJPROJ}"; rr:class db2:PROJECT; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:projno ] ; rr:objectMap [ rr:column "PROJNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:projname ] ; rr:objectMap [ rr:column "PROJNAME" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:deptno ] ; rr:objectMap [ rr:column "DEPTNO" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:respemp ] ; rr:objectMap [ rr:column "RESPEMP" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:prstaff ] ; rr:objectMap [ rr:column "PRSTAFF" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:prstdate ] ; rr:objectMap [ rr:column "PRSTDATE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:prendate ] ; rr:objectMap [ rr:column "PRENDATE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:majproj ] ; rr:objectMap [ rr:column "MAJPROJ" ]; ] .

<#TriplesMapSALES> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "SALES" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/sales/SALES_DATE={SALES_DATE}/SALES_PERSON={SALES_PERSON}/REGION={REGION}/SALES={SALES}"; rr:class db2:SALES; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:sales_date ] ; rr:objectMap [ rr:column "SALES_DATE" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:sales_person ] ; rr:objectMap [ rr:column "SALES_PERSON" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:region ] ; rr:objectMap [ rr:column "REGION" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:sales ] ; rr:objectMap [ rr:column "SALES" ]; ] .

<#TriplesMapSTAFF> a rr:TriplesMap; rr:logicalTable [ rr:tableSchema "db2" ; rr:tableOwner "db2ma" ; rr:tableName "STAFF" ]; 
rr:subjectMap [ rr:termType rr:IRI  ; rr:template "http://demo.openlinksw.com/db2/staff/ID={ID}"; rr:class db2:STAFF; rr:graph <http://demo.openlinksw.com/db2#> ];
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:id ] ; rr:objectMap [ rr:column "ID" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:name ] ; rr:objectMap [ rr:column "NAME" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:dept ] ; rr:objectMap [ rr:column "DEPT" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:job ] ; rr:objectMap [ rr:column "JOB" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:years ] ; rr:objectMap [ rr:column "YEARS" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:salary ] ; rr:objectMap [ rr:column "SALARY" ]; ] ;
rr:predicateObjectMap [ rr:predicateMap [ rr:constant db2:comm ] ; rr:objectMap [ rr:column "COMM" ]; ] .