This can be done if the connected objects are not stored in the database as blob fields. We have our connected objects stored on a shared network drive. The view you would want to look at is ifsinfo.documents_connect_objects. If you don’t have this view you can create an IAL that has select statement that would look something like this: SELECT DR.KEY_REF, substr((substr(DR.key_ref,((instr(DR.key_ref,'^ORDER_NO='))+10),((instr(DR.key_ref,'^REL_NO='))-((instr(DR.key_ref,'^ORDER_NO='))+10)))),1,12) ORDER_NO, substr((substr(DR.key_ref,((instr(DR.key_ref,'^LINE_NO='))+9),((instr(DR.key_ref,'^ORDER_NO='))-((instr(DR.key_ref,'^LINE_NO='))+9)))),1,4) LINE_NO, substr((substr(DR.key_ref,((instr(DR.key_ref,'^REL_NO='))+8),((LENGTH (DR.key_ref))-((instr(DR.key_ref,'^REL_NO='))+8)))),1,4) REL_NO, DR.LU_NAME, DC.DOC_NAME, DR.DOC_CLASS, DR.DOC_NO, DR.OBJID FROM IFSAPP.DOC_REFERENCE_OBJECT DR, IFSAPP.DOC_CLASS DC WHERE DR.LU_NAME = 'CustomerOrderLine' and DR.DOC_CLASS = DC.DOC_CLASS The select statement shown above would be used find objects connected to customer order lines. |