DSXchange

I'm curious what operating system you're running - AIX?

Yes. Drag the table metadata onto the link rather than 'Load' it inside the stage.

Then forget about compiling or running PX jobs.

7.5.2 or 7.5x2? BIG difference and the latter is the only non-8 version that will actually compile/run PX jobs on Windows.

No problem. If this fixes your issue, please mark the post as Resolved using the button at the top of the screen.

Did you try searching for your message? I got 34 matches when I just did, surely your answer is out there in the flotsam and jetsam.

Figured as much. What about the second question?

What is the definition of "Column B" in the Oracle table? Why do you feel the need to CAST the column during the select?

I guess not... or at least not with both clients on the same pc.

As noted in the message, that "-1" means "Invalid JobHandle". Odd that it happens in the WaitForJob part of the process, that should mean it was able to start the job using the handle it established. :? Did you try search for "Invalid JobHandle"? People have reported th...

How much UNIX experience do you have? :? This is a simple "path" issue - you should either specify the path to the command or add the directory where it lives (or "dot") to your PATH so it can be automatically found. For the former, $DSHOME/bin/dsjob will work from anywhere or fr...

Are you sure they're truly empty? This is typically an IE display issue when OCX is blocked. Allow that and they should show up.

Welcome. :D

Search is your friend! An exact search for "newTime" will find posts that explain your issue.

For some reason searching for "newTime < startTime" doesn't find anything, however, obviously the less than sign confuseth it.

nani0907 wrote:Also unable to view premium content.

I really don't understand why people feel the need to mention this. It is obvious who is a Premium member and who isn't, that's clearly marked on every post. All this statement says is you don't want any of the Premium posters to help you. So be it.

Business rule? The business users that I've known wouldn't utter any technical jargon like "truncate table". If your DBAs are concerned about granting truncate privileges, they can always create a stored procedure and grant you access to that. I mean to say that,DBA will not be allowing u...