DSXchange

Phil - they asked about a quick way to add already established environment variables to jobs.

"Not able to"? What happens when you try?

No limit that I am aware of and I've captured 10s of thousands. What O/S? Does the routine use DSExecute() to run the "ls" command? Do anything else... unusual?

What happened when you tried?

ps. Test and Prod users should not be able to edit any jobs. In either project.

From what I recall, the "Complete Set" join type should be what you are looking for.

First bit of advice? Don't post the exact same question again just because you didn't get any answers to the first one. Post a reply to the first one to 'bump' it back up to the top. However, since this one now has a reply and thus cannot be deleted, please go back to your original post and delete i...

Best to leave system hashed files and folders like this alone. See the last post in this thread:

http://www.dsxchange.com/viewtopic.php?t=122893

You can't. You need to "transform" them into something you can compare - either an ISO YYYY-MM-DD external format or an internal date using StringToDate().

Sorry I couldn't be more help, but not having 8.x makes it hard to help with problems / issues / features specific to that version. However, all kinds of people here do have it, so hopefully someone else will chime in. There's a couple of things working against you right now, the fact that it is the...

[sigh] No, just running late and trying to help people out too quickly in an effort to get out the door and on to work that morning. I skimmed over the linked post and only saw the OMIT flag option and assumed it was the same as the GUI export where you can choose to omit/include any read-only objec...

I don't see any evidence that you had more records to load than what it processed. Table dbserver.CUST_PERS_DEV: 2162039 Rows successfully loaded. 0 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Bind array ...

From memory, there should be a "multiserv.pdf" document in your Docs folder that will detail the "itag" installation instructions.

At least that 'problem' is one that is easily solved.

Array Size is the number of records in each network packet - i.e. to send across the network to the database at the same time. Transaction Size should be an even multiple of the Array Size when not set to zero.

Add the Sort stage into the job before the Aggregator, if you want to go that route. Or, load the file directly into a work table and let Oracle do the aggregation.