DSXchange

Hi All, I have a very challenging question, it may be bold but it will be very helpful & effective solution if its possible/available; My question is:- 1) Is it possible to convert datastage code of the entire job to SQL code in script? I doubt there's no such convertor tool as of now 2) Also, ...

Hi,

KeyMgtGetNextValue is a built-in routine available in datastage, you have to select this to make use.

I hope it helps.

Thanks,
Yusuf

Could you please pass the solution, I also have same issue

Thanks,
Yusuf

Thanks ArndW

Hi Experts. I have a query regarding Date conversion; We have i/p string like 110404 in yymmdd format. When we convert it to Date, it'll give result as 1911-04-04 But we need value for this century i.e 2011-04-04 Do we have any project level setting which will allow to change the century value? We c...

Hi Ray,

apart from bug fixes - Do you mean to say the present Connector stage have any bugs. If any what are those, can you please mention as we have to decide whether to use Connector stage or not.

Thanks,
Yusuf

Hi,

When do we need to go to pick one of these stages:-

1) DB2 Enterprise stage
2) DB2 Connector Stage
3) DB2 API Stage

As per my knowledge, DB2 Enterprise stage performs well of these. Then when do we go for other stages, what are the advantages of those?

Thanks in advance,
Yusuf

Have you tried to compile the job before running, usually this message is generated when the job has aborted unexpectedly

Hi All, I executed a job with the environment variable - APT_PERFORMANCE_DATA & defined the performance directory. It has to produce performance file in that directory. We ran 3 jobs & I saw 3 performance files got created. But I didn't came to know which file corresponds to which job; the f...

Ask your server admin to do it for you