DSXchange

:!: Please do not hijack other people's threads. Start your own topic and we'd be happy to help you. Hi, Appreciate yours suggestion. I have started posting my question just few days back. Initially, really tired of while finding out the way where I can start my own thread. Could you please help me...

That's not an Oracle DATE, but rather a TIMESTAMP. While the former can hold a time, only the latter can hold milliseconds. That is the root of your 'conversion error'. ... Hello :wink: , I have date format in source is dd-mm-yyyy and want to load in target table as yyyy-dd-mm . Could any body plea...

ray.wurlod wrote:

Code: Select all

DSGetJobInfo(hJob, DSJ.JOBENDTIMESTAMP)

...

Hi Ray,
Thanks a lot for your reply. I am quite new to datastage, could you please bit clear where to write this code to capture job end time.

Regards

ayan wrote:ok.got the idea.will try that out.Thanks.I am very new to this forum but must say,a very dynamic forum with lot of useful info.Very useful for beginners like me.

Hi,

How job end time can be captured in datastage.

Anil

ayan wrote:ok.got the idea.will try that out.Thanks.I am very new to this forum but must say,a very dynamic forum with lot of useful info.Very useful for beginners like me.

Hi,

How job end time can be captured in datastage.

Anil

One thing came in my mind that lets have Execute Command Stage after that particular job where we delete old state file and create a new file with the same name. If there is any other best option, where should not have any manual work in production ... then please....


Anil

I think it is possible in 7.5 but datastage 8 we are creating one state file where last key value get stored and in next run it startes generating key value from next...

Hi,

I am binded to use Surrogate Key Generator stage to generate Surrogate Key in DataStage 8. But my problem is that I want to generate the key value from initial in each run. Is it possible in Surrogate Key Generator stage? If so please help me on this.

Regards,
Anil Kumar

Hi,

I am binded to use Surrogate Key Generator stage to generate Surrogate Key in DataStage 8. But my problem is that I want to generate the key value from initial in each run. Is it possible in Surrogate Key Generator stage? If so please help me on this.

Regards,
Anil Kumar