DSXchange

It's not difficult. It's tedious - not the same thing. It's something you only need to do once. Do it. Save into Repository so it's re-usable.

There is a limit imposed at the operating system level, but no practical limit imposed within DataStage itself. The operating system limit is the number of subdirectories in a directory; each job requires six or seven subdirectories in the project directory. This is often an issue in the Version Con...

Use the -lognewest option to get the most recent "job started" event, then everything with a higher event number or higher or equal timestamp.

Please note that 12.32.345.23 would not be counted as numeric in either server or parallel jobs.

Might be worth asking them why.

Certainly the client memory gets hit hard when uploading all of the jobs (which happens, for example, for the drop down list in a Job activity in a job sequence or, more generally, when refreshing the Repository view).

ssunda, please fork over a mere 14 cents per day ($49 per year) so that you can read premium posts, and help us to fund this site. You don't want it to disappear, do you?

Are you absolutely sure that you're looking at the same row? The database server will deliver rows in whatever order it happens to find them, unless you specify (a) a single key value in a WHERE clause, (b) an ORDER BY clause, or (c) a GROUP BY clause. If you have a reproducible case that proves tha...

Hopefully they don't appear. So scheduling their removal ought not to be necessary. If they are appearing with regularity, then you have processes that are failing regularly, and you really should be finding out why.

If you type in orchadmin with no command line options or with the -help command line option you get a syntax summary output. $ bin/orchadmin ##I TFCN 000001 20:40:38(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Sof...

Your support provider should be able to supply at no cost. You receive them when attending IBM training classes. There may be a link from this forum to where they can be downloaded - you could essay a Search.

Are they there in the Stage Types branch of the Repository? It may be that the Palette is not being refreshed. It may also be that the DS_STAGETYPES table needs to be reindexed (the command is DS.REINDEX DS_STAGETYPES). Otherwise it may be that you need to install the stages from the package into pr...

A core file is (may be) dumped when something goes wrong in the software. Because there are many processes in a parallel job, the name core has the process ID of the process that had the problem. You need to be able to identify which process was involved - the easiest way to achieve this is to set A...

Oconv() function is not natively available in parallel jobs. Oconv() with "MTS" is for working with Time data. Had the OP wanted to use Oconv(), the second argument would be "MCN" rather than "MTS", and it would be necessary to use a BASIC Transformer stage (or a server Transformer stage in a server...

Not unconditionally. You really should check whether the job actually needs resetting before doing it.

The routine could always switch them back, returning instead a list of external format dates. I just happen to prefer using internal format in server jobs.