DSXchange

You are the customer. Server jobs are - and will remain - part of the product. You are within your rights to demand that IBM support server jobs. Particularly since so few things go wrong with server jobs!

Change the Sybase code page to UTF-8.

I disagree with the design. I design job sequences that never abort. On that basis, my design would be to run one job to count the rows, check the count, and decide whether or not - on that basis - to proceed with the next job.

Transformer stage.

If the elements are of fixed size you can also use Modify stage.

Dates do not have formats. They are stored in a 32-bit structure in a binary format. Therefore your requirement is moot. If you need to "translate" the dates from how they appear (as strings) in source and target, then you need to specify an appropriate format property in the stages that r...

adityavarma wrote:we need to implement the same in parallel

Why ?!!

You are processing ONE ROW. Where's the sense in using parallel execution technology for that?!!

Resist stupid requirements!

priyadarshikunal already showed you how to remove the warnings.

priyadarshikunal already showed you how to remove the warnings.

RCP is usually set on the Output properties, Columns tab.

"%mmm" matches the three-character abbreviation of the month name.

You need to research the correct formulation in the date format picture. From memory - because I can't check at the moment, the full month name is pictured by "%mmmm".

RCP will cause all columns to be retrieved by the SELECT * formulation. And you can pass them all the way through your job design provided you don't need to apply any transformation. If you save to a Sequential File with column headings, then import the table definition of that text file, or if you ...

When's the interview? This can't be done with a single function, you need a minimum of two. Which two will depend on the data types involved, information that you have not supplied. Probably some combination of DateToString() and StringToDate(), with appropriate date format strings, will do it for y...

Curious. Earlier you stated:

rahul8055 wrote:The job runs well some times but sometimes gets aborted.

As to the others, search DSXchange for the texts of the error messages and resolve the respective causes based upon what you find.

Change Capture stage with "All keys and All columns" should detect absolute duplicates happily.

If there are no errors ("fatal") and only warnings and informational messages in the log, then the job does not abort. Tell us what is in the log when the job aborts - particularly the red icon events.

Your DataStage jobs are running as dstage. I suspect this is the user ID under which DataStage services are started.