Jennifer_Jinhong_34

SQL Query list of WorkFlows that contain a specific Informatica Connection Object

Discussion created by Jennifer_Jinhong_34 on Jun 20, 2013
Example queries to return a list of WorkFlows containing Informatica Tasks where the Connection object isn't the default.
Oracle: select oh_name, oh_client from oh where oh_idnr in (select jppcv_oh_idnr from jppcv where jppcv_vname='repository' and dbms_lob.substr(jppcv_value,200,1)='') SQL Server: Select oh_name, oh_client from oh where oh_idnr in  (select jppcv_oh_idnr from jppcv where jppcv_vname='repository' and jppcv_value='')</code></pre> **Update statements below can be ran to mass update a system. Direct updates to the database are not covered by your Maintenance Contract. Please test thoroughly before running in Production**
Oracle: update jppcv set jppcv_value='' where dbms_lob.substr(jppcv_value,200,1)='' and jppcv_vname='repository' SQL Server: update JPPCV set JPPCV_Value='' where JPPCV_Value='' and jppcv_vname='repository' </code></pre>

Outcomes