DSXchange

So now 10 minutes is a "long running job"? :wink: Skipping the thought that killing the job would be a Bad Idea, you can't do that kind of monitoring from the job itself or via another job. You could, however, write some job control code (or a shell script) to poll the job in a loop to see...

You didn't really answer either of my questions, at least not directly.

I'd also suggest you double-check your kernal tunables in the problem environment.

Is Oracle Exadata supported by the connector? And what exactly do you mean by its "the only difference"?

Still new at this...forum thing... and 8 year old posts exist so we can look at them! :shock: No-one said anything about not looking at them, I only objected to your mostly off-topic reply to one. Have you done much of anything with pulling information from job logs? Feel more comfortable writing s...

Shank... I'm not feeling really confident that your questions are being answered fully or to your satisfaction. Make sure you come back and let us know if you need any other help or clarification with this. And I'm still wondering if the two lookups can be combined into the source SQL, looks to me l...

:!: OK... rather than hijack an 8 year old post that is only somewhat related to your issue, next time please just start a new post. I've done that for you this time and linked back to the original post although it doesn't have much to do with your question. What database are we talking about here? ...

They do not need to be in a text file, simply capture the output of the execute command stage via the StageName.$CommandOutput variable. Make sure it's formatted properly and then it can be leveraged by the Start Loop stage. By that I mean a delimited string containing the filenames and choosing Lis...

One can only hope! :D

Well... you could certainly create and maintain 'temporary' tables within a relational database via DataStage. Otherwise, objects like datasets or filesets or even flat files can be leveraged much like tables, temporary or otherwise.

The latter.

only after deriving column 5 .. we can refer to the other history table. Its like .. if Column 5 is 'x' then, refer to HIstory table A, other wise refer to History table B for populating the rest of the columns in the table. That's fine. Do both lookups and then conditionally decide which result to...

You said "in the first job"... does that imply you've broken this processing up into multiple jobs? I'm not seeing anything that tells me it can't all happen in a single job where you do the lookups before populating the target thus only inserting into "Table A" once. Not sure wh...

That's how a varchar works. If you want the spaces, make it a CHAR and ensure your padding character is set to 0x20, that or explicitly pad it.

Don't left-click on the links - right-click then 'Save target as'.

I may not be clear in the requirement. That much is true. :wink: I did say it can be as simple as concatenating, not that was the only or preferred way. Not clearly knowing what you are trying to accomplish means you may not get the most cogent reply. You could easily build the stage variable to lo...