DSXchange

Looks like sample/VCOMM.PORTS was missing from your installation media. This is doubly unfortunate, because this is a hangover from UniVerse that isn't actually used by DataStage.

What part of my initial response, which mentioned three ways you can approach this, gives you the impression that there is no way you can handle it?

Neither of those is a table name in the Repository. Are you referring to the MS Access file into which the reporting assistant moves metadata?

Have you bothered to Search for this information?

Have you bothered to Search for this information?

Have you bothered to Search for this information?

You run it with the same parameters. Or you re-run the entire sequence. These are your only options.

The Sequential File stage can not read spaces that aren't there in the data. Simply specifying Char(6) in the metadata does not magically make it so. If you want the trailing spaces you need to add them either in the file itself or in a Transformer stage within your job - a Fmt() function with "...

What I said was obtained by looking at a version 8 system. Perhaps it is different in 7.5. But, as you note, you can generate it indirectly.

Welcome aboard.

None, as far as I am aware, but in either edition of DataStage you are free to write your own stage types.

Do they provide any standards-based connectivity to their objects, such as ODBC? If so, you could use those.

For server jobs it does not matter whether you're on SMP or MPP architcture. Server jobs execute only on the machine on which DataStage server is installed.

If you use Link Partitioner or Link Collector stage in your job, you MUST enable inter-process row buffering for the job.

See Server Job Developers Guide for proof and more information.

That message tells you that NAME is not a column name in the DS_ROUTINES table. The name of the column that contains the routine name is DSRID.

No, dssh is on the server only. You will need to execute it via rsh or similar.

What message was produced by your query? Deleting only from the local repository is not going to be enough, however.