Query select a.map_name,b.map_type_name,b.is_same_map,a.is_only_id,a.is_id_output,a.is_bulk_map,a.is_match_all,e.source_name,c.obj_type_name,j.attr_name,f.source_name,d.obj_type_name,i.attr_name,a.map_class,a.exec_type,a.map_call,a.safe_point_size from rep_mapping a,rep_map_type b,rep_obj_type c,rep_obj_type d,rep_pds e,rep_pds f,rep_lds g,rep_lds h,rep_attribute i,rep_attribute j,rep_smm_map_rel k,rep_smm l where a.map_type_id=b.map_type_id and a.input_lds_id=g.lds_id and a.output_lds_id=h.lds_id and g.obj_type_id=c.obj_type_id and h.obj_type_id=d.obj_type_id and g.pds_id=e.pds_id and h.pds_id=f.pds_id and g.lds_id=j.lds_id and j.is_key=1 and h.lds_id=i.lds_id and i.is_key=1 and k.map_id=a.map_id and k.smm_id=l.smm_id and l.smm_name='complete' union all select a.map_name,b.map_type_name,b.is_same_map,a.is_only_id,a.is_id_output,a.is_bulk_map,a.is_match_all,e.source_name,c.obj_type_name,'',f.source_name,d.obj_type_name,i.attr_name,a.map_class,a.exec_type,a.map_call,a.safe_point_size from rep_mapping a,rep_map_type b,rep_obj_type c,rep_obj_type d,rep_pds e,rep_pds f,rep_lds g,rep_lds h,rep_attribute i,rep_smm_map_rel j,rep_smm k where a.map_type_id=b.map_type_id and a.input_lds_id=g.lds_id and a.output_lds_id=h.lds_id and g.obj_type_id=c.obj_type_id and h.obj_type_id=d.obj_type_id and g.pds_id=e.pds_id and h.pds_id=f.pds_id and i.is_key=1 and (c.obj_type_name='query' and h.lds_id=i.lds_id) and a.map_id=j.map_id and j.smm_id=k.smm_id and k.smm_name='complete' union all select a.map_name,b.map_type_name,b.is_same_map,a.is_only_id,a.is_id_output,a.is_bulk_map,a.is_match_all,e.source_name,c.obj_type_name,i.attr_name,f.source_name,d.obj_type_name,'',a.map_class,a.exec_type,a.map_call,a.safe_point_size from rep_mapping a,rep_map_type b,rep_obj_type c,rep_obj_type d,rep_pds e,rep_pds f,rep_lds g,rep_lds h,rep_attribute i,rep_smm_map_rel j,rep_smm k where a.map_type_id=b.map_type_id and a.input_lds_id=g.lds_id and a.output_lds_id=h.lds_id and g.obj_type_id=c.obj_type_id and h.obj_type_id=d.obj_type_id and g.pds_id=e.pds_id and h.pds_id=f.pds_id and i.is_key=1 and (d.obj_type_name='query' and g.lds_id=i.lds_id) and a.map_id=j.map_id and j.smm_id=k.smm_id and k.smm_name='complete' union all select a.map_name,b.map_type_name,b.is_same_map,a.is_only_id,a.is_id_output,a.is_bulk_map,a.is_match_all,e.source_name,c.obj_type_name,'',f.source_name,d.obj_type_name,i.attr_name,a.map_class,a.exec_type,a.map_call,a.safe_point_size from rep_mapping a,rep_map_type b,rep_obj_type c,rep_obj_type d,rep_pds e,rep_pds f,rep_lds g,rep_lds h,rep_attribute i,rep_smm_map_rel j,rep_smm k where a.map_type_id=b.map_type_id and a.input_lds_id=g.lds_id and a.output_lds_id=h.lds_id and g.obj_type_id=c.obj_type_id and h.obj_type_id=d.obj_type_id and g.pds_id=e.pds_id and h.pds_id=f.pds_id and h.lds_id=i.lds_id and i.is_key=1 and c.obj_type_name='search' and a.map_id=j.map_id and j.smm_id=k.smm_id and k.smm_name='complete', Wed Feb 10 16:19:18 2010

map_namemap_type_nameis_same_mapis_only_idis_id_outputis_bulk_mapis_match_allsource_nameobj_type_nameattr_namesource_nameobj_type_nameattr_namemap_classexec_typemap_callsafe_point_size
mappingtest1testmapping01110testdb1testobjects1ID1testdb2testobjects2ID2idsqlDriver=org.gjt.mm.mysql.Driver;URL=jdbc:mysql://139.18.13.64:3306/test_db2;user=peter;password=retep;QUERYPATTERN=SELECT ID2,value2 as value from test_objects2 WHERE ID2 in ([Query])-1
querytestobjects1querytest111100testdb1query(null)testdb1testobjects1ID1querysqlDriver=org.gjt.mm.mysql.Driver;URL=jdbc:mysql://139.18.13.64:3306/test_db1;user=peter;password=retep;QUERYPATTERN=SELECT ID1,Value1 as Value from test_objects1 WHERE [Query]10000
querytestobjects2querytest211100testdb2query(null)testdb2testobjects2ID2querysqlDriver=org.gjt.mm.mysql.Driver;URL=jdbc:mysql://139.18.13.64:3306/test_db2;user=peter;password=retep;QUERYPATTERN=SELECT ID2,value2 as value from test_objects2 WHERE [Query]-1