DSXchange

Thanks .. I got it.. Stages like the ODBC stage do not have a delete option in the list of update actions. In order to delete you have select user defined sql and then write the sql statement yourself. Pass in the key column to your delete stage and code your statement similar to the following: Dele...

Hi sonia, Thanks for the same. I agree I will have to delete but how? Manually.. I am new to datastage so pardon me for my poor knowledge. I am trying to find it how to delete ? Hi, In case you have set Rows per Transaction (Commit level) to be greater than zero only then you would run into the prob...

Hi Everybody,
I have the following scenario.
I am getting multiple records based on memeberID. so each memberID has multiple records. If the job gets aborted for a memberID I want to delete the other records for that memberID. How can i implement it?

Thanks in advance.

Hey guys thanks Hi, I am very sorry for posting my query in the wrong place but I didn't get exactly where it shd be posted so I am posting it here. I am querious to know what kind of care is taken in the following situation. Say I have different databases in diff languages & I want to create a ...

Hi, I am very sorry for posting my query in the wrong place but I didn't get exactly where it shd be posted so I am posting it here. I am querious to know what kind of care is taken in the following situation. Say I have different databases in diff languages & I want to create a centarl repositr...

Hi, I am trying to to do a simple job. source is sequential file having a single col. day in the format of (yyyy-mm-dd) . the details are: SQL Type char Length 10 Data Element Date.tag Target is ODBC stage SQL Type Data Length 19 in the transformation , just mapped the column, no other operation is ...

I am new to datastage & had the same problem. Can anybody plz tell me why it works on Unix & not on XP Pro? is it becuase of nos of cpu or something like that ? Thanks Anand, if you mean you are writing a PX job on windows you can't run px on windows. It only runs on unix..... Hi All I am fa...

Hi,
Can anyone help me out to know why Autosys is used for the job scheduling if that can be done using director? You can use UNIX script for scheduling also. Then what is the difference? In what scnerio you shd go for director, autosys or unix script?

Thanks in advance!!