DSXchange

Check the validity of the date before converting it into DATE datatype in the transformer itself.

Try using routines.

Thanks for your reply chulett. right now I am not infront of datastage. But I am going to write a derivation like I mentioned below. StgVar: If Inlink.Item<>"100" Then 'Y' Else 'N' Constraint: StageVar='Y' Abort After rows=1 Hope this logic will abort my job. Please let me know, If do any...

In change capture stage if we are exckuding any columns it shouldn't be used in comparison for updates.I have a scenrio where after excluding a a column will used in comparing columns for update resords. could anyone tell me the reason for it? is it the descrepance in datastage change caprture stag...

kamtammystuff wrote:I guess it would treat it as a update record if any one of the link has a null value in it , anyways simple testing is the best way to know..

It will treat as a update ecord only if only one has a null value and copy if both are nulls

I guess it would treat it as a update record if any one of the link has a null value in it , anyways simple testing is the best way to know..

Is this newly istalled?

Which folder are you planning to delete? and this approach is not suggestible.

What is the metadata in the sequential file stage?

Try checking the number processes running on the server when it says "Server Busy"

What does your Datastage Admin has to say about this?

If the column mylink.myraw contains the value { 0x31 0x31 0x30 0x35 0x32 0x32 0x30 0x39 }, then the following function returns the string "11052209".

In that case first you need to filter '2f' and '2c' first and then insert the delimiters after converting.

I guess this is just a conventional representation of dates and by following chulett's rpresentation the given string clearly gives us 2 dates as mentioned below 06/01/2011:12/31/9999 ====> where the first date represents the start date and the second represents the End date. So you can convert the ...

Open the stage and then F1.

Its Passive