DSXchange

Have you credentialled your Information Server user ID with appropriate DataStage credentials (roles)?

Clean up your system. Remove all unwanted files. Purge log files. Delete all files from &PH&. Allocate more disk space to the resources disk and scratch disk.

Welcome aboard. Please explain your job design in more detail. In particular, are you applying any transformation to this field? If not, you probably need to investigate a function such as StringToDecimal() to convert the data type. Parallel jobs do not manage all data type conversions automatically...

Did you specify scale = 2 in the DataStage column definition?

Even easier is to use a Column Generator stage or a Surrogate Key stage. You can set the initial value via a job parameter added to the partition number. Set the increment to the number of partitions.

You don't need to remove the "-" characters - display of dates is governed by the default date format string you have defined. When Date data types are written to database tables, they are loaded as type Date; display format is ignored. If you are writing to a text file, don't use the Date data type...

It's a known limitation in version in 7.1, resolved in version 7.5.

The answer to that totally depends on how work units are defined in your case. There is no general answer that can be given. IBM appears to prefer the term "unit of work", possibly because UOW can be expressed as a three letter acronym, and possibly because this terminology seems to be more widely u...

Welcome to DSXchange. Get yourself an English dictionary and learn how to spell words like "to". A professional standard of language is expected here, a forum in which professionals communicate with each other and on which not all participants have English as a first language. Then read the DataStag...

Probably the optimal model is to destructively read the input queue, and establish an intemediate "hold" queue in which you can manage your units of work. You might also send your outputs to one queue and your rejects to another.

So how do you propose to call your DLL from the UNIX machine? Leave DataStage out of the picture for the moment - how would you call your DLL from any UNIX application?!!

Yes there is, and Search will allow you to find it.

Running DS.REINDEX ALL in the VERSION project may be beneficial.

In your Lookup stage specify the "Lookup Failed" rule as "Fail".

Wrap your design in Code tags, then use Preview to get it right.