DSXchange

Set the Final Delimiter property value to tab.

Why can't you use it in a parallel job? The DSSetUserStatus() function exists in the DataStage C API, therefore you can create a parallel routine and use it, in a similar way that you have to create a server routine to use it in a server job.

Date data types, as I explained elsewhere, do not have formats. It is only when they are represented as string data type that the format becomes relevant. If you have dates, as you state, then your question is moot.

Read about dsjob in the manual. The job status is always available on file unit #2 (stderr).

My thoughts also. First I wanted to check that Modify2 wasn't a "do nothing" Modify stage - one with just a KEEP specification - that would also be optimized out of the design. But you don't need the environment variable; try setting the combinability mode of either (or both) of the Modify stages to...

Provide values for the appropriate properties (including Remote Server where required). The rest happens when you View Data or run the job.

Please post the code of your After-Job subroutine.

If the input column is a Date data type it has no particular format; Date is a binary data type within DataStage. Therefore your fundamental assumption (that you have a date with different formats) is not tenable.

Lots. See Orchestrate Operators manual, particularly the chapter on the modify operator. Here are the main ones: date_from_days_since[date](int32) date_from_julian_day(int32) date_from_string[date_format](string) date_from_ustring[date_format](ustring) month_day_from_date(date) weekday_from_date[ori...

Maveric wrote:First of all how do u use a peek stage as a source?

Just have the Peek stage upstream of the stage in question.

It's a co-ordination nightmare!

Nothing springs to mind. Change Capture is one of three stage types that can detect change. I can envisage no use for Change Apply in SCD2 management.

You search the forum, in which it has been answered many times. Also helpful would be a more meaningful subject, and a description of what you are doing in the Transformer stage that generated the error. The name of the Transformer stage may be obtained from its generated source code, in RT_BP140/JO...