DSXchange

mahadev.v provided a workaround, not a solution. rk - you would need to post the actual trigger expressions you are using in order for use to help, not 'something like' them but the actual complete triggers copied from the job. You could also check this post and see if helps clear things up for you.

I tried it and is working fine as of now, but not sure whether this would work for all times. The only reason it appears to be working fine is the fact that you are dealing with a single row. However, this is not something you should be doing and some operating systems will actually prevent this. B...

Anything stopping you from actually using SAS for this? :wink: Server does not support the "select * approach" you mentioned, however a PX job would. For whatever that is worth. So if you really felt the need to do this in DataStage Server, yes you would need as many jobs as you have table...

Best to contact your official support provider for help with this, they're the only ones who will really know what it is attempting to do at the point that it hangs.

First off, posting in ALL CAPS is considered SHOUTING online. Please use your inside voice here. :? The "phantom" directory in each project is &PH& and is used by the background job processes to communicate status with the engine. As noted, once the job completes and this communica...

I would expect that to be true (that using Sequential is faster than using External Source Stage), as the document is at least already loaded from disk. Both solutions still have to parse it though, which is the biggest time consumer. I would expect so too, parsing being where most of the time is s...

So say we all!

Ah... thanks for that.

We now return you to your reguarly scheduled problem...

An exact search for Implicit conversion from source type "int64" found 18 other posts on this subject, see if any of them help.

If you mean the choice of the PI column, then yes, of course. What I mean is when the proper column is picked, it doesn't matter if that column is column number 1 or number 42, it doesn't affect how it functions. All this under the umbrella of Oracle, of course, which is the subject of this post. Ar...

Have you tried logically rejecting them by checking with the IsValid() function? Curious if that would work in this case.

Have you asked... oh, silly perhaps... your official support provider for help? This kind of thing would be right up their alley, I would wager.

First it would need to be made accessible to you, as noted, and that means involving a SysAdmin. This more than likely is not something you can manage by yourself, permissions-wise. Especially considering you have no idea what we are talking about.