DSXchange

This isn't about a history of running a job but rather a history of changes made to / versions of a job.

:? Why not simplify the code? You don't really need all that if-then-else. Call DSSetUserStatus(Arg1) Call DSLogInfo(Arg1,"Arg1") Call DSLogInfo(DSGetJobInfo(DSJ.ME, DSJ.JOBNAME),"userstatus") Ans = Arg1 Tell us what "doesn't work" means here for the call to DSGetJobInf...

asorrell wrote:The stored procedure can be parameterized to accept file names for flexibility.

Table names... and so can the Before SQL.

I've got no clue but for the "NoSuchMethodError" I would involve support.

Is there a firewall in play anywhere here, perhaps one with an idle timeout set?

Keep in mind, though, that would take all of the records from the first table and shoot them across the network to the engine and then back across to the same instance it came from to load the table. There are ways to emulate the original "do all the work in the database" technique that th...

Toad.

You don't need a job to do that.

Not quite sure what you are 'testing'... is this resolved? Somehow I don't think so.

FYI - I moved your post here which is the proper place to discuss the issue. I removed the copy you put back in the other forum.

I have tested the code in toad. its fine. But it is not working from datastage. This "test" bothers me as it doesn't really mean anything other than to show that your SQL - whether it be select or update or whatever - is syntactically correct. Toad doesn't care what kind of fields you are...

As is normally the situation, there are multiple solutions to this requirement. Since you are on UNIX, you may be able to only bring in the records desired or you may need to filter what you need out in the job.

Perhaps you should post the xsd? Sounds like it may not be valid...

To 'get the exact number of records from a file' you would need to count them before the job runs. Typically. And off the top of my head you can leverage the @INROWNUM system variable to know what row number you are working with, as long as you are careful with your partitioning. I.E. don't partitio...

Choice discussion, this thread. Implementation issues? New thread.

What was your decision?

Or there.

Yes. The PX Engine's bin directory, I would assume.