DSXchange

Yes they are.

Maybe you've had network/internet problems?

There are lots of ways.

Search this site for terms like "surrogate key", "slowly changing dimension" and "sequence" to learn about some of them.

Ultimately you have to capture your start point from the target table and increment from there.

Quite probably. DataStage generates a process to run the job, and possibly (probably) other processes to execute active stages (such as Transformer stages). The operating system is likely to allocate multiple processes to multiple CPUs. Of course, on a Windows machine, there will be many other deman...

I am sorry. It is not an answer to my question. Did you try to answer somebody else? A rough check on line length might suffice. Line length is the quotient after dividing characters in file ( wc -c file ) by lines in file ( wc -l file ) which you can do using the UNIX command expr . Check out the ...

A rough check on line length might suffice.
Line length is the quotient after dividing characters in file (wc -c file) by lines in file (wc -l file) which you can do using the UNIX command expr.
Check out the man pages for the wc, cut and expr commands.

@OUTROWNUM may be a better choice. If you later add constraints to your Transformer stage, you will get gaps in the number sequence (which may not matter if they are only being used for uniqueness). @INROWNUM counts the rows coming in to a Transformer stage. @OUTROWNUM counts the rows leaving a Tran...

You could determine whether there is a C-callable API for the Domino database server and, if there is, you could write a plug-in stage. This is not something for the faint-hearted! You need excellent C programming skills (and C++ if you're going to have a custom GUI). If it's just Lotus spreadsheets...

I concur 100% with the previous responses. However, if you can make a case that you're likely to purchase a license, Ascential may be prepared to issue a 30 day evaluation license. After the 30 days are up, all you have to do is fork over the US$100000 or so that a license costs (actual price depend...

TXMEM sets a limit (before spilling to disk) on the in-memory size of a transaction in the DataStage engine environment. There are very few transactions that occur here (mainly when you're using insert/update with the UV stage). 32KB should be plenty. SYNCALOC is about robustness of operations that ...

T30FILE is hard to hit. Au contraire! You CAN hit it by running lots of jobs simultaneously. Almost all of the repository files (and their dictionaries) associated with a job are hashed files, so there's 6-10 per job already. Now add your lookups and it's not hard to hit 200 on a decent server. (Bu...

You've pretty much got it covered.
You have to build all the options for the dsjob command, then run this as a DOS level command, ideally in a separate memory space.

Welcome to the Forum! There is no server process. That is, there is no process called "the server" or "the engine" that could keep a log. There are some optionally started processes, such as the deadlock daemon. If started, these will keep a log, for example dsdlockd.log. Each job that runs keeps it...

If you're doing this in BASIC there's an easy answer. The ReadSeq statement takes its ELSE path if you are at end of file. So you could: Loop ReadSeq Line From SeqFileVar Else Exit statements Repeat This can also be written using the Boolean context of ReadSeq. Loop While ReadSeq Line From SeqFileVa...

Hi Ray, Thanks a lot Ray but I need u r suggestion ,I have designed a job where in I need to pass the Header Information ,Trailer Information and The Detail info , for more validations , to an other job but How can I pass it a)Thru Job Parameters b)Write to a file and then call that file on the nex...

When you're assigning values anywhere in DataStage GUI, such as initializing or modifying stage variables, you are using an expression, not a statement. Therefore there's no requirement for Set (btw there is no Set in DataStage BASIC, though there is a Let). All you need is an expression that return...