DSXchange

Are you SURE it's not nullable? Something in the stage wants to set the field to null (perhaps because it's failed lookup?). Seems that it's detecting non-integer values, so that your assertion that there will always be an integer passed to it is looking fairly shaky too. Check in the job log (or de...

Everything gets installed. It won't "go" till you license it.

Isn't the USNAME rule set read-only?

If you have version 8.5 this is a perfect application for the looping capability of the Transformer stage.

Search both here and DeveloperWorks. You are not the first to have reported this.

It is perfectly feasible; a file exported from Windows can be imported when connected to a server built on UNIX. During job development be careful not to do anything "Windows" that won't work on UNIX. For example, build pathnames with a parameter for the directory and a forward slash as th...

WHERE are the two databases?

Almost certainly yes. Have you bothered to Search DSXchange?

Welcome aboard. The only safe answer is "from the insurance company's data systems". There are a few different corporate systems in the insurance industry, such as POLISY. You have to glean this information from the insurance company in question. If you have access to it, you might also li...

... or Julian dates, which are integers.

saraswati wrote:Can anyone take a look on it?

Of course. Your official support provider can. That's what you're paying them to do.

What indicator? Basically, multiply by -1 if the indicator is set to "negative". Positive decimals don't have sign - you would need to change the data type to string if you want to prepend "+", which you could do with a Convert() function. Convert(" ", "+", In...

Do you understand what a fifo is?

Where are the databases in relation to the DataStage engine machine?

You can't use a Modify stage to add hard-coded values. You can use a Column Generator stage (a cycle with one value) or a Transformer stage.