Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_F
Contributor
Contributor

How to set CTL/BAD/LOG file name and location for tDBBulkExec (oracle)?

Hey All!

I am setting up a tDBBulkExec (oracle) component and it's working fine, however, I'd like to set up a few of the SQLLDR file locations and names i.e ctl/bad/log files and I can't seem to figure out how to do this from the designer.

For example, I want to store all the log files in C:\temp\context.var.log for instance.

I can see this is how they are defined within the code itself, but I am hesitant to touch those:

  1. String ctlf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".ctl";
  2. String badf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".bad";
  3. String dscf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".dsc";
  4. String logf_tDBBulkExec_1 = dataf_tDBBulkExec_1 + ".log";

It is also possible to automatically remove any of these files after the process has completed?

Cheers!

Labels (3)
0 Replies