DSXchange

With private link caching there is no way available to pre-load the contents of the hashed file into memory.

Are you really going to "create a unix" just for that? Or just create a UNIX shell script? :lol: You need to run dsjob with neither -wait nor -jobstatus (which you could have determined by searching DSXchange); your script must then periodically check the status of each job until the statu...

I'd probably use a double fork-join design, to get counts by key1 and by key1&key2. The rest of the logic will flow nicely downstream of that.

You need to set the Partition Table property.

What kinds of entries are being logged? Changes to dsdlockd.config are not picked up until the next time the deadlock daemon starts. This is usually the next time that DataStage services are started, but you can use the -config option with dsdlockd to the same effect. My guess is that you have chang...

The only way to automate this is to run your sequence (and, incidentally, it's not a Sequencer) from another, parent, sequence that does not abort. In the parent sequence, set the run mode to "reset if required, then run". Actually, that's not the only way, but all the other ways required ...

Welcome aboard. Did you Search DSXchange? Do you have FastTrack? This is a tool that facilitates the construction of mapping documents. Otherwise all you need is a table (in a document, spreadsheet, etc) specifying where each target column comes from - some combination of source column(s) and transf...

You may, of course, have bumped into a period when the DSXchange server is being backed up.

Don't even bother with DataStage. Use the split command.

Depends. It may not even be possible. Which particular Connector stage?

It is not possible to set a job parameter value once the job is running.

So, in words, "the day before the first day of the next month".

"ade"is a generic identifier in DataStage. User shared memory segments have a key that begins with "adeb", hashed files have a magic number that begins with "adef", and so on. A different identifier is used when an -itag installation is performed.

The same limit applies on Solaris operating system.

TimeDate() is a server function. Maybe you needed CurrentTimestamp() function?