DSXchange

Ken - I almost ended up buying a Saturn because I was told that it was the only dealership where "what you see is what you pay" and that there were no negotiations about pricing at all. That alone was enough to convince me of buyng a type of car I really didn't want. Unfortunately the saleslady was ...

I don't know about cable companies (I don't have a TV) but if it weren't for car dealerships what kind of stores would they put on the major throughfares leaving US cities? And what other commercials could you see on local TV at 2am?

The commit interval is time based as opposed to number-of-rows based.

Krish, no need to quote my entire post for that question. Most of the time the /tmp space will be automatically reclaimed, but sometimes when jobs fail badly they will abort and not clean up after themselves. It makes sense to periodically look into the directory you are using for temporary and scra...

I don't think it made TV here, they were probably showing Monty Pyth on or Coronation Street instead. But I have picked up the phrase "Don't mention the War" - everyone know that here but I bet you nobody back in the USA would know what to do with that statement. p.s. Guilty As Charged of the offens...

Tough problem! I hope that support comes back quickly with a solution and look forward to hearing the explanation once they arrive at it.

Lol - I missed that. I've used the "Grasshopper" expression a couple of times here in the UK and I've gotten some really strange looks. Somehow it isn't funny when you explain it...

Can you see it in the manager? If yes, compile it and it should show up in the list.

Try SELECT DISTINCT COMPANY_ID
FROM [TABLENAME]

Do you get the same padding when writing to a sequential file instead of to the Oracle stage? If you were using PX I'd say the culprit is APT_STRING_PAD_CHARACTER but you stated server as the job type. Also, if you declare the Oracle column to be VarChar instead of VarChar2 do you get the same error?

The "you will conform" approach has been tried many times and has failed each time. My test for stringent design documents is that if the design were given to 5 developers and all code produced is essentially identical then you've gone too far with your specifications. What would our work be like wi...

You have a broken file. You can try using UVFIXFILE in TCL to fix it or, if it doesn't contain vital information, do a "CLEAR.FILE RT_LOGnnn" and then you can manually add in the purge settings.

Ken - I like pipes for reformatting and use then often when necessary. If I have one input row that generates {n} output rows I will use a pipe insted of landing the data to a sequential or hashed file. It is usually stable and always fast.

What value do you get if you add a column with "LEN(In.MyLen5VarCharField)" and output that to a text file? I am fairly certain that the length is already 7 before any conversions.

PX will buffer between stages (unlike server, where pure pipes are used) and can, given the right conditions, overflow this buffered data to disk. Have you actually monitored your /tmp and scratch areas while the job was running to make sure that they aren't filling up? Also, how many nodes configur...