DSXchange

How about FMT(out_fa003_lsmw.PAR_AMOUNT,"16'0'R2") ?

Still struggling with HTML, not ready for "son of" yet.

You can do it in SQL with SQL functions, not with DataStage functions as Ken indicated. One way is to determine whether the difference between the date and the first of the subsequent month is 1. If that is true, then your date is the last day of its month. Different databases use different date man...

To be honest, I have not processed any non-English data with it. But there was some investigation I wanted to do with maps and locales. They seem to come up and load OK using default locations. Here's the message from the event log. DataStage information message: Shared memory addresses: Disk=0x0800...

Nowhere near enough information. The only thing you've told us is that your speed through DataStage averages about 30 rows per second. Extraction What is the source of these rows? Are you retrieving rows in true parallel, or in sequential mode? (For example the Oracle Enterprise stage executes SELEC...

Create a tmp folder on the same driver letter that DataStage engine is installed. For example, I installed DataStage server on D: drive, so I created a D:\tmp folder and this problem went away.

We'll always welcome suggestions, but make no guarantees.

The only place you can use expressions in server jobs is within the Transformer stage. No other stage type supports data modification expressions. Within the Transformer stage is an Expression Editor that allows you to select operands and operators from menus, so that very little (error-producing) t...

I believe you mean the DataStage API, which certainly does let you do these things. Indeed dsjob began life just as an example of how to code an application using the DS API. But, since dsjob now exists and is supported, why re-invent the wheel? If you insist upon pursuing your desire, read the chap...

Inspect the source code for ExecSH or ExecTCL. See what they do with quote characters. They are notorious for it. Clone them and make them work as you would prefer.

... or down but not up successfully? Search also for netstat

Get your employer to provide some training. The vendor (IBM) offers a good range of classes, and there are some third party providers of training.

They must be 100% compatible. Make it so.

Note that it is possible for DataStage to be up even though dsrpcd is not running. Clients and requests will not be able to connect, but jobs started will continue to run and new jobs can be started from already-running job sequences. These do not use the DataStage RPC mechanism. Connection via teln...

DSguru2B wrote:October here on planet earth has just 30 days.

Have you visited planet Earth recently??