I want to create SQLI job that show the location of the VARA files. But I can't find the table where the location is saved. I find this OFS_OH_Idnr_F, but not the location ..
Any idea in what table this info is saved?
I have found a workaround. I have used this to find all the VARA files that are older than 1 month and created in a "LOG" dir:
Select OH.OH_Name, OH.OH_Title, OH.OH_CrDatefrom OH, OFSwhere OH.OH_Idnr = OFS.OFS_OH_Idnr_Oand OH_Client = &$CLIENT#and OH.OH_OType = 'VARA' and OH.OH_CrDate < ADD_MONTHS(TRUNC(SYSDATE), -1)and OFS.OFS_OH_Idnr_F IN(select OH.OH_Idnrfrom OHwhere OH.OH_Idnr = OFS.OFS_OH_Idnr_Fand OH.OH_NAME LIKE '%\LOG')order by OH.OH_Title, OH.OH_CrDate
Retrieving data ...