DSXchange

Welcome aboard. :D DS_AUDIT does not keep the last run date or, indeed, any run-time statistics. DS_AUDIT records changes to design-time objects. Indeed, dssh is not the command you require. You can either interrogate each job separately using dsjob -jobinfo or you can inspect the date/time modified...

Well, not trying to do something that won't work is a resolution of a kind. The usual solution to this is to create your own routine. Something like this one. FUNCTION WaitForFile(WildCard, TimeOut) * Returns 0 if there is at least one file that matches WildCard, * returns 1 if the timeout &...

If they insist upon DataStage for control, why do they insist upon shell scripts? Why not have DataStage do the whole thing? After all, they've paid the money! It is sometimes necessary to push back, particularly when what "they" want can not be intelligently justified. Please be advised by a couple...

Not Enterprise for the second title, as this includes server. "Parallel" would be better.

Almost time for a "Mainframe" title as well, there is a small but steady trickle of questions about DataStage EE MVS, which tend to get buried.

And then, of course, are the on-line help and DataStage manuals. There is a Tutorial that ships with DataStage too. From all of these sources you can get ideas about creating routines. If you want help from DSXchange, it helps to post specific questions. I could spend two days teaching you about wri...

Exactly what information do you need? The dsjob -jobinfo command will give you some information, but you may need to script some looping to invoke dsjob -stageinfo and dsjob -linkinfo based on dsjob -lstages and dsjob -llinks respectively. But if you need information about execution, then you probab...

You've probably already noticed that job sequences do not support before/after subroutines. You will need to use Routine activities within the job sequence itself - the routines themselves will need to be created as transform functions, though these can be interludes to the requisite before/after su...

Get to the operating system, execute the following command, and post the result.

This will show whether you have a root install or a non-root install, and whether impersonation mode is in effect or not.

It might be that the indexing on DS_ROUTINES is not synchronized. Do you get ANY routines in the drop-down list? If so, which ones? Can you see ExecDOS in the Routines branch of the Repository? Go to the Administrator client, open the Command window, and execute the following query SELECT DSRID FROM...

Make it Char and it will be padded automatically with the character defined in APT_STRING_PADCHAR.

There are far too many unsupported assertions in that document, which - if it is or is based upon the one of which I'm thinking - you should not have (it's IBM Internal Confidential, produced by the Center of Excellence for use by IBM consultants). While it is true to claim that performance improvem...

Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property?

This message suggests incomplete metadata.

Let the database do it.

Not unless you collect them onto one partition. And even then how do you now that the last one collected is the highest value in the entire Data Set?

Write as VarChar or do nothing and format the cells in Excel.