DSXchange

From a server routine it is preferable to use the builtin API calls, in your case it would be: DSAttachJob() DSSetParam() DSRunJob() DSDetachJob() To see how the calls work, create a new Server job. Go into the Job Control tab and, at the top, select the sequence you wish to call and click "Add...

What sort of a "routine" are you talking about here? Is it a DataStage server routine, or perhaps a c++ program linked in as a plugin?

Simple answer - you do it in real-time.

I that isn't specific enough, then perhaps you could narrow down your question.

Yes, it is possible, but complicated. There is no single builtin function to do this. I would use the BitExpand() function to show the binary value for a snigle character, then with some stage variables and a long if-then-else construct you could get the Hex value. SVarBits = BitExpand(SEQ(In.OneASC...

I just spent weeks writing a program which manages log files - you can choose whether by date, or runs or number of log entries and it cleans up broken multi-instance and job run data plus it reorganizes remaining data and performs other housekeeping. Entries removed are archived to an Oracle databa...

With Version 7 it was possible t reinstall the engine and, during the installation process, give a path to an existing DataStage project and that would be added without destroying or overwriting the project contents. With V8 and the added XMETA repository I am not certain that this still functions b...

328 records in the DS_JOBS file that don't have a job number looks far too big - those would normally be category names (or structure paths, to be more precise). The second query with the MCP conversion shows that you have 8 records with undisplayable characters in the key, something that shouldn't ...

I expected 3 entries in your output, not many pages.

What is the output of "COUNT DS_JOBS WITH JOBNO EQ ''"
and "COUNT DS_JOBS" and "COUNT DS_JOBS WITH EVAL 'OCONV(@ID,"MCP")' UNLIKE @ID"

Looks like a broken CATEGORY index, please try "LIST DS_JOBS ID.SUP EVAL 'OCONV(@ID,"MCP")' WITH CATEGORY UNLIKE \... NO.INDEX CATEGORY"

Ok, you can edit your previous post and remove a bunch of the details to make the thread more legible. You have non-displayable characters in your DS_JOBS file. Let us try to localize where they are and if they can be removed. What is the result of "LIST DS_JOBS ID.SUP EVAL 'OCONV(@ID,"MCP...

I think a sort wouldn't work here, because it would change the order of the YEAR columns. A pure DataStage solution with stage variables as mentioned above is possible but complex. Another possibility is to a add a line number column and then sort by descending line number, the you could store "...

could you please post the output from the command " LIST DS_JOBS BY CATEGORY BREAK.ON CATEGORY FMT 64L DET.SUP TOTAL EVAL '1' FMT 4R"

This is a bit trickier to implement, since DataStage does not do "read-ahead" of rows, i.e. a given row cannot know what the next one is. Fortunately with stage variables you can store values from previous rows. So in this case you would collect year numbers and values in stage variables u...

If the file lists are empty after the DS.REINDEX ALL that means that you still have sessions or clients connected and thus the indices could not be rebuilt. Try it again. After it completes, enter "LIST DS_JOBS WITH JOBTYPE EQ 3 REQUIRE.INDEX" - if no jobs are listed then the indices are s...

Which one has the extra text? Which section of the .dsx file is it in?