DSXchange

Should there be an END to correspond with the BEGIN in your awk script?

Welcome aboard. :D I assume that you are performing Import > Table Definition > Sequential File It is known and documented behaviour of this dialog that, when you switch back to the Format tab, any definitions you may have created on the Define tab are discarded. After all, if you change the delimit...

Is it really rounding into the Data Set, or is it merely that the data browser (View Data) that is doing the rounding? If you move the data from the Data Set into a table or text file, are the data complete?

... or use a constraint such as Mod(@OUTROWNUM,4) = 0 on the output link of a Transformer stage, accumulating the four values in stage variables.

Programming Tip Whenever you use malloc(), use free() when finished with that memory. If you call this routine one million times, you end up allocating 20MB of memory. This is known as a "memory leak". You need to test this using a test bed (main() program) and debugger. Is this usage of malloc() -...

Not to the body. You could use a script to redirect stdin from that file. Or you could use a fixed body that says "see attachment".

You may find that your network card needs to be active. Even being connected to a wireless network will suffice.

Create a job to load them into a hashed file then use UtilityHashLookup as the derivation expression for each (needs version 7.5 or later).

Not without a routine somewhere in there, to build and send the email. The Notification Activity can not take an expression as the message body (though attachments are supported in version 7.5, so you could have the job produce the attachment file).

Search the forum for SPINTRIES and SPINSLEEP. These are configuration parameters that affect mutex locks' operation.

Welcome aboard. :D How long is a piece of string? The answer to your question is that it is, more than anything, a function of the resources available on the server where ProfileStage is running. For example, with four CPUs and 16GB of memory you will be able to run far more than with one CPU and 2G...

You can execute any command after connecting via DataStage telnet. Simply use the DOS command in DataStage. Either DOS /C "command" to execute the command then return, or DOS alone to open an interactive DOS shell (use the exit command to return to DataStage).

If you're going to use stage variables for the comparison, then stage variables for the accumulators is probably easiest to implement.

No, the Windows-based server is 7.5x2. There is, separately, a version called 7.5.2 for UNIX servers.

That's good if it's DataStage locks that are at fault, but not at all if it's database locks.

Database locks need to be managed by other database utilities, such as DBA's know about.