DSXchange

You right, many thanks!

X=ICONV("3:14AM", "MTH") X=11640
X=ICONV("3:14PM", "MTH") X= 54840

Vladimir

What am I doing wrong? The following two conversions return the same internal value: X=ICONV("3:14 AM", "MTH") X=11640 X=ICONV("3:14 PM", "MTH") X=11640 I can do this conversion in SQL, but would prefer to have all such type transformations inside DataStage. A...

Thanks again, all this info was very useful.

All of a sudden a set of jobs collecting DS log data started performing poorly. It now takes 3 and half hours as opposed to few minutes it took before (jobs run normally for the last couple of years). I assume this should have something to do with possibly corrupted or overloaded DS run-time reposit...

Hi Craig,

We have not had any luck in figuring out how to stop this ugly behavior. If you have a chance to get a solution from IBM technical support, please post a solution here.

Thanks,

Vladimir

A patch for Windows that was delivered by Ascential is ECASE 96969.

Does anyone have any experience using DS OLEDB stage with Microsoft OLE DB Provider for Directory Services (LDAP) using DataStage 7.1x?

Any practical guidelines would be really appreciated.

Thanks,

Vladimir

For archives -- the patch MerrillLynch mentioned has been delivered under eCase 52622. And it's for AIX, not for Windows. Hopefully I will have a patch for Windows from Ascential soon.

Hi Ray,

I tried 009, but it still ends up with "0" as column delimiter in the output file. May be I miss something else?

Vladimir

So if we are not using telnet to manually connect to DataStage it's safe enough to disable it? And this service is not used as an underlying surface for any other DataStage processes, right?

Ray,

What are the consequences if we stop tl_dsservice.exe (DataStage Telnet Service)? Will it break anything?

Thanks,

Vladimir

Is anyone know an easy way to get a list of jobs in a project that do not use $PROJDEF?

Thanks!

Vladimir

I know, but it is still ugly. Hope IBM fix it.

You can paste $PROJDEF instead of typing it, it accepts doing this.

A really ugly pitfall is that you loose ability to view data in a stage. I hope this is fixed in future releases, anyone heard about this?

But I don't see that DSParams.KEEP is getting updated each time after I modify something with normal termination. For example, in the project I am working I don see any of my user defined variables at all. It sounds scaring to me if DS decides to rollback using DSParams.KEEP file! That's why I am st...