DSXchange

Is this the only way to handle this situation? I would have thought that comma in decimal figure is basic stuff and should be handled either implicitly or explicitly with format string? As Ray would put it sometimes, "Stop thinking like a server developer !!!" DataType conversions are present in En...

Kumar is right, if you look at the DS help of these functions, you will see that JulianDayFromDate() will return an integer. You can perform this function on your incoming dates and do the substraction. If you just need the difference and not concerned about which date is higher, you can also use Ab...

If the so called 'reject table' was designed specifically for this job then I would say standardize the meta data at the table level as well. In otherwords, change the column name to whats in the file. This way there is conformity of metadata.

Get it working outside DataStage first. Once you have a working function,then you can call it inside the database stage wrapped in a sql.

The server routine's code is visible. Examine it and translate the code into C.

Add another column that has a running number. This way when it gets rejected, you will have the row number right there with the row.

As always, great article Vincent.

Craig, what you posted, IMHO, should be on the main page as a reminder for all. Its important piece of information.
Maybe the webmaster can do that. Just a thought....

Enterprise stages utilize full parrallism and can do loads along with inserts. More is available by going through the manuals.

I should have added that in cases where native api stages are faster, its due to the usage of native drivers.

It has line terminators that are converted to @FM by DataStage. Do a field() and get the everything before the first @FM.

First option for environment variable and second for just the job parameter. Try this, just specify a job parameter and see if that works.

Do a count on the file, something like "wc -l" and perform your percentage manipulation. Pass that value as a job parameter to your job. Specify a reject link that will capture all the rejects. The constraint will, along with the .REJECTED, IF @OUTROWNUM > ABORTCOUNT then UtilityAbortToLog("Threshol...

You should be able to use the parameters. I am not a big fan of making all parameters as environment variables, but I test it out in a dummy job and it works here. How did you define the environment variable in the first place? Go to the job properties, click on "Add environment variables", hit on n...

If you hardcode the value. Does it work fine?

RohanSharma wrote:But in a parallel stage we can perform a lookup using the look up stage and datasets always.

And thats how the px engine was designed to perform. Server jobs dont have lookup stage and datasets, period.