DSXchange

You requirement is to trap reject records using a JOIN stage? What kind of a join are you doing?

Nobody suggested that it couldn't be done in a DS transform. The algorithm is to compute the first day of the month that is 2 greater than the current, then to subtract one day from it.

Nope, he can go ahead and corrupt a test project without affecting other projects

Question - how is your current overall CPU load while running jobs? If it isn't consistently high (i.e. over 80%) then your hardware question shouldn't revolve around the CPU and memory but needs to include your I/O subsystem as well. If both have local disks then are they the same type and do you h...

All of the hashed files specific to that job would also need to be deleted. At version 8 you would also need to remove some IIS repository information. I think by doing this manual delete the metadata (i.e. "where used" tables and the like) will get confused.

No, moderators really aren't "grammar police" and shouldn't be. PM's to the really bad offenders haven't worked in the past, so all that is left is posting recommendations. It is the poster's right to ignore any such suggestions just as it is any reponder's right to ignore such posts.

What have you tried and what was the result? Specifically, what method did you use to convert a SBCS representation of a kana "ha" to a DBCS kana "ha"? Which encoding are you using?

I tried it as well yesterday and get a compile error at Version 8.

OddJob - I am in the same camp as Ray and I'm not a native English speaker. I believe using SMS-like English is an abuse of the English language that doesn't belong in a professional forum such as this one. I've stopped being as active as Ray in mentioning abuses of the written language. What I have...

As mentioned earlier in this thread, it cannot be done at the command line.

What is a fifo process, keshav0307?

hiswapnadeep - are you going sequential stage to sequential stage? If so, what happens if you insert a copy stage?

BugFree wrote:You can have a job with just the job control code...

No, you cannot have a PX job with just a sleep and compile it.

What is the string result of your conversion? Shouldn't the ICONV use the format string "D4/YMD"?

Add a reject link to your oracle write stage and put that into a peek statement, then examine the SQL code to find out why the rows are being rejected.

Does "UPDATE" work?