DSXchange

Where does your filename come from, the master or detail records? If it is the master, perhaps you could 'pre-process' the master file before job (say in a script) to pre-create all of the files you'll need empty, for example via touch. Then when the job runs those with detail records would be overw...

Your dsjob syntax looks fine, the challenge would be in parsing the output. Rather than a batch file, write a UNIX script with grep for that... I'm assuming you can still do that in your version with whatever is there similar to MKSToolkit. Or is that no longer possible? If not, then perhaps somethi...

Because you're not sending all of the duplicate keys to the same partition. Use hashed partitioning on the key field(s) that drive the duplicate check.

It's simple enough to check the date/time that a job last ran. Or to check and see if a job is running. Will either of those work for you? Both would use dsjob -jobinfo off the top of my head, the former would parse out and check the last runtime while the latter would run at say 5:01AM and check fo...

Nope.

Perhaps Oracle can help?

Any news on this?

Seems to be fixed now! Thanks for the reboot Dennis.

Just out of curiousity, with you doing inserts into an empty table why not bulk load?

I am having a parallel job load which executes from Job control. Sorry, what? Can you clarify what exactly you mean, please. Are you talking about the Job Control tab associated with a specific job, i.e. BASIC code that runs before the job itself? And if so, is there anything on the job's canvas? A...

I prefer the UNIX test commands, for example:

test -f filename returns true if the file exists, false otherwise
test -s filename if the file exists and is not empty, false otherwise

Those are my two ways I use quite a bit. Also note that you check the status of the command, not the output.

Agreed. However, default behaviours can change over time and loopholes get closed so sometimes people see things that 'ran fine' under older versions no longer do so under newer ones. That because DataStage has tighter checks or code fixes that make old jobs that really shouldn't have been working i...

220, 221... whatever it takes.

Fun part is, even if your initial connection times out and 'website cannot be displayed' is all you get, it has still marked you as having visited at that time so all of your unread posts are lost.

crystal_pup wrote:PS : Mods - In case I have posted in wrong forum, please move the topic to appropriate forum.

Oh, not to worry - that happens automatically without asking.

You're fine.