Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
MDouglas1687874333
Contributor III
Contributor III

Activate toracleclose on subjobok from two different flows

I currently have two flows that connect to tOracleClose components via SobJobOK connections and was wondering if I could reduce this down to only using a single close component instead of two? The image below is a rough estimation of what I have (the tjava comps are just representaions of the larger data flows). The flow used is dependant on type of file that is passed into the job. I know I can use a OnSubJobOK from one flow and an OnComponentOk from the other but was wondering if there is a more efficient way?

069U1000000pRarIAE.pngI am using tOracleClose components but putting them on seems to change them to tDBClose components for some reason

Labels (3)
1 Reply
Anonymous
Not applicable

Hi

You can use OnComponentOK to connect to only one tDBClose or close the DB connection in end of job using tPostJob component.

 

Regards

Shong