DSXchange

If you're using an Oracle Enterprise stage you might also use the Open command. This is to be found in the Options folder under available properties to add.

You get one section leader per node per job.

Resource management is up to you - use fewer nodes or run fewer jobs simultaneously.

Contrary to popular belief, DataStage servers do not deliver an infinite supply of resources.

Entire partitioning uses shared memory on SMP environments/configurations. Other partitioning algorithms do not (because they do not need to share anything). If you choose a different partitioning algorithm than Entire (or Auto) for a reference input, then this warning occurs. It's not a "bad" warni...

It's not a particularly helpful message, is it? It can even occur if the process table is full (operating system can not start a new process). It can occur if the section leader process has already reached the limit on number of sub-processes it's allowed to create (this limit is set in the UNIX ker...

By leveraging more than 20 years' experience with the database, usually in exchange for a professional fee.

No. No UNIX supports ActiveX. All DataStage execution occurs on the DataStage server.

Are you doing that command within the same before/after subroutine?

Doing it from the command line proves nothing.

Why do you say "at the moment"? Do you have some inkling that Microsoft is going to change the way it works?

Are you referring to the change maintenance issue, crouse?

dsserver wrote:ps -ef....is it not a UNIX command??? How do we do in windows??

Task Manager

Another possibility is that your row size is larger than that declared - or, perhaps, permissible - in the bulk loader.

FIND may be easier to manage than LOCATE. Or you could make a 1x9 matrix, copy from one to the other (using MAT keyword) and search that using LOCATE. If name found, add six to the where-found value to identify the element number of the desired age. Or you could MATBUILD a nine-element dynamic array...

NLS is either ON globally (all projects) or OFF globally. You need the former. NLS can not be disabled on a per-project basis, which is one of the reasons that the pseudo-map NONE exists. If this map is set, then no mapping occurs. Set project default maps and locales within the project properties d...

Fragmentation will not be an issue. The hashing algorithm pretty much always guarantees the same location in the VOC file, because it is a static hashed file (one in which the number of groups does not change over time without manual intervention).

Yes.