DSXchange

I have a script which is doing the same,its been tested and running well since a year and giving no issue.PM me and i will send u the code.

I will try to put that script here as well.

No One ??

Wondering if anyone is kind enough to tell me the difference between Routines(parallel,Server,mainframe) vs "Transform". I just tried to create one "Transform" under "File > New > Other > Transform" and felt like this is just another way of calling all those functions w...

Thanks Ernie,I know i can get those information using other hook-ups but I am more interested using MWB because this tool is made for operational data reporting and we are paying its license cost so why not we take an advantage.

I am trying to explore MWB capabilities for operational metadata reporting and wondering if i can get a report for following requirement - we have multipple projects and each project have many jobs which run during different timeslot,I want to find out the time-slot taken by a each project during a ...

Double will round off your data,I find Decimal with large precision works better.

you can use MonthfromDate() function to get month out and then subtract.

Editor seems to be on long vacation

great,I did that and put the source table name in that field but it increased my job execution time to 40 min from 27 min.am i doing something wrong ?

Whenever I use a DB2 EE stage in a job,I see its default execution mode is sequential and it is also greyed-out so I can't make it parallel. I thought Db2EE stage read data parallel from Databases but here it seems to be working just opposite. Anyone knows if this is the nature of EE stage or I am d...

Ray,you said right,when i query RT_Status it returns me zero rows and it is not giving me any information. Craig,using dsjob gives my stats only for last run and I need to get stats or atleast last three or four run. Is there any way to get this information from command line and not by using datasta...

Thanks Craig,Do you know how to retrieve this information,i query this table but did not get any piece of information ??

Anyone done it before ?

I use to think that dsjob command pull all the information from RT_LOGn files but it certainly don't pull everything from their. I did a small test,deleted RT_Logn from universe and ran dsjob -linkinfo for a job and it still returns the row count for all links so certainly dsjob pulls these informat...

no-one ???

Why most of the Webinar is not available,I am trying to watch "Metadata Workbech deep dive" but it seems to be unavailable,Admins can you please fix the link.

Appreciate your help in advance !!
Etler