DSXchange

hi to all Can anyone explain me how can I do rollback in DRS stage. My problem is like this.Suppose my source contains 100 records and my job get abort after 50 records.But I don't want these passed 50 records to be seen in my target table and my target is DRS is that possible. Thanks in advance Mohan

Hi to all

Can anyone explain me how can we loop in datastage

Thanks in advance
Mohan

Hi ray

What you understood is correct.Please elaborate little more on this.

Mohan

hi to all

Can anyone help me how can I define hierarchy in datastage jobs.

Thanks in advance

Mohan

hi friends

Please tell me where can I find the log file for the job I will run and what information basically it contains.

Thanks in advance
Regards
mohan

My actuall problem is like this

My job sequence contains 10 jobs and all the jobs contains 10 tables with one common column batch_SID.If I run this sequence then all the tables should get same batch serial number.
How can I achieve this?

Thanks in advance

Mohan

I am really sorry I was in urgent need of answer for the doubts so I just asked why no reply
Nothing else than that
Sorry again to all

mohan

I mean how can we generate batch serial id of the datastage job

I mean batch SID(serial id)

Actually my problem is that how can we generate unique batch SID for the particular job and next SId for next run of the same job.

mohan

hi

why no reply

What is batch SID ? and what is the use of creating it?

Ray.wurload r u there


mohan

hi

Can anyone tell me how can we generate batch SID for the datastage jobs. If there is any routine then plz send it across it to me.

Thanks in advance

Regards
Mohan

hi to all

can anyone tell me how can i count number of records in source(flat file)

Thanks in advance

cheers.....
raju

hi roy

My problem is in one of my column one format of date is yyyymmdd
and one more format is without leading month that is like yyyymdd.

Then how can i convert it into dd-mon-yyyy format

hi to all

Thanks for your replies i got the answer

cheers..
raju